Hi All - I hope someone could help me with this. I am downloading this report monthly and i think it would be easier to automate the downloading, however, i have zero knowledge on how to do sap script (hopefully this wouldn't be version-sensitive since i am using SAP 7.30 but there are SAP 7.20 version). Please see below step by step process that i do.
I Go to SAP, G4P box then enter transaction code "xxxx" and enter the following details:
Cost Center: "1234567892"
Cost Element Group: "EXPENSES"
Posting Date: 1st Day of the year to the last day of the Closed month
Layout: /pgeorgeCB
I execute the report (F8)
then save it as excel file and then go back to SAP and expand all fields (this is the hardest/tedious part), and then save again the file as excel (this is another file)
Then i consolidate both files into one excel file.
I dont know where to start, if someone can just help me with sap script, i think i can figure out the excel (copy and formatting stuff) on my own.. Thanks in advance!
I Go to SAP, G4P box then enter transaction code "xxxx" and enter the following details:
Cost Center: "1234567892"
Cost Element Group: "EXPENSES"
Posting Date: 1st Day of the year to the last day of the Closed month
Layout: /pgeorgeCB
I execute the report (F8)
then save it as excel file and then go back to SAP and expand all fields (this is the hardest/tedious part), and then save again the file as excel (this is another file)
Then i consolidate both files into one excel file.
I dont know where to start, if someone can just help me with sap script, i think i can figure out the excel (copy and formatting stuff) on my own.. Thanks in advance!