‎2008 Aug 20 2:50 PM
Hi all,
I never done a workflow,..
I have a basic requirement,.. in VF01 , when an invoce is created, that is after the save button ( after comiting to the database ), i need to push the details to an excel sheet. I do not have a user exit nor badi. Could you please tell me how will i do this with Workfolw,... thank u
‎2008 Aug 20 3:01 PM
My suggestion is once the billing is created, you can find change document entries in table CDHDR & CDPOS , write a small program to read from this tables of unique billing document numbers and read billing document tables VBRK, VBRP and download to excel in specified interval of time
Change document object name : FAKTBELEG
I don't have much info on workflow side
a®
‎2008 Aug 20 3:01 PM
My suggestion is once the billing is created, you can find change document entries in table CDHDR & CDPOS , write a small program to read from this tables of unique billing document numbers and read billing document tables VBRK, VBRP and download to excel in specified interval of time
Change document object name : FAKTBELEG
I don't have much info on workflow side
a®
‎2008 Aug 20 3:06 PM
Hi,.
Your suggestion was considered,... but the problem here was i cannot schedule because the data cannot be uploaded into an excel from SAP in the background mode. Am i correct ?
‎2008 Aug 20 3:14 PM
In background mode you have to only create CSV (comma delimited) file instead of XLS.
a®
‎2008 Aug 20 3:17 PM
Yes,. but the problem is , this data that will be downloaded has to be put into excel , this is because it is been picked from another third party system that is done in VB,. and it has to be an excel. I cannot dowload it into application server and keep the file tab limited..
‎2008 Aug 20 3:33 PM
U can use BO : BUS2081 in which you have method Create .
You can create a very simple workflow which will send a mail with the required details to the destination Inbox.
You can also send attachments required.
Regards,
Krishna.