Automate

 View Only
  • 1.  Script a Transaction that outputs a report?

    Posted 07-31-2023 06:13

    HI All

    Im trying to create a script that outputs a file from an SAP transaction (its Customer Classification data) i cant do it via Query as its not a fixed table, and Transaction doesn't seem to let me action a script to put out a report either.

    Has anyone come across this method or query before and has a suitable resolution that might work please? Im using Winshuttle 12.1.

    Thanks in advance.

    Christian



    ------------------------------
    christian stratford
    Univar Europe Ltd
    Fontenay-sous-Bois
    ------------------------------


  • 2.  RE: Script a Transaction that outputs a report?

    Posted 07-31-2023 08:45

    I Managed to action this using a BAPI script in Transaction, allows me to set the folder location and report name and set a variable too, for anyone whos interested.



    ------------------------------
    christian stratford
    Univar Europe Ltd
    Fontenay-sous-Bois
    ------------------------------



  • 3.  RE: Script a Transaction that outputs a report?

    Posted 07-31-2023 10:48

    [OFFICIAL]


    Apologies team i have just been told I need to log my questions though someone else they deal with all of our requests.

    Apologies for inconvenience caused I am new to Anglo and I did not read the process.

    Thanks James 

    Sent from Outlook for iOS





  • 4.  RE: Script a Transaction that outputs a report?

    Employee
    Posted 08-02-2023 17:10

    Glad you found a BAPI,  Christian.

    You may potentially be able to do it in Query, too, but it's a somewhat complex process to join all of the tables, i.e. SAP didn't make it easy. :)

    If a BAPI works, that's the way to go! 

    Thanks for sharing!

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------



  • 5.  RE: Script a Transaction that outputs a report?

    Posted 08-03-2023 03:08

    Thanks Sigrid, Agreed SAP likes to keep us on our toes at times, but its all part of the learning journey fun right! :)



    ------------------------------
    christian stratford
    Univar Europe Ltd
    Fontenay-sous-Bois
    ------------------------------



  • 6.  RE: Script a Transaction that outputs a report?

    Posted 09-07-2023 14:09

    Hello christian

    I'm interested in how you were able to do this.  We have a custom Z transaction that pulls in our daily production schedule  that we then export to a .txt file that we then upload to another app .    Looking to automate the exporting of that report.

    Thanks in advance 



    ------------------------------
    GERMAN ABREU
    Estee Lauder Companies -Hq Ny
    ------------------------------



  • 7.  RE: Script a Transaction that outputs a report?

    Posted 09-08-2023 04:00

    Hi so i actually ran it with a GUI, not a BAPI, my apologies.

    and i recorded them as transactions, with a fixed file location our shared network and the same file name ending .txt.

    Script runs fine but does require me to be logged onto the machine as its a daily/weekly schedule, and then we pick up the .txt for the end use.

    happy to discuss further if you still need a steer in the right direction :)



    ------------------------------
    christian stratford
    Univar Europe Ltd
    Fontenay-sous-Bois
    ------------------------------