topic Re: GL upload in Application Development and Automation Discussions

GL upload

Former Member — Thu, 15 Nov 2007 16:47:23 GMT

i need to create a program such that Program reads data from the excel file and uses that data to create FI documents.

Best way to do this as suggested by functional guys was to have the program create a batch input session because then, if there were errors when loading,

the session would remain behind and could be analyzed.

they also suggested that, a standard program that they were familiar with that works this way is RFBIBL00.

The data would need to be converted first and then submitted to RFBIBL00, since the source data will have the old GL accounts, the old cost centers, and so on.

i havent done such a program before, can some one please suggest me how to start this.

thanks.

Re: GL upload

Former Member — Thu, 15 Nov 2007 16:51:14 GMT

You can use LSMW. Very easy to set this up.

Albert

Re: GL upload

Former Member — Thu, 15 Nov 2007 16:52:41 GMT

Hi Sanjana,

Use BAPI BAPI_ACC_DOCUMENT_POST for GL Upload.

Reward If it helps,

Satish

Re: GL upload

Former Member — Thu, 15 Nov 2007 16:54:42 GMT

You are going to need some sort of translation routine to convert the old account numbers, etc. to the new ones.

rob

Re: GL upload

Former Member — Thu, 15 Nov 2007 17:12:45 GMT

hi friends,

thank yppou for the reply,

functional people came back saying that the file being picked up will already be a modified one , so we dont need any changes to that data,

so we just need to directly input that data in BSEG and BKPF tables.

but one thing i didnot understand is , what is this RFBIBL00, and does it serve any special purpose in my program,

will there be any difference if i directly input hte data into these tables using update command on itab,

or using this RFBIBL00 helps in any way.

thnaks again.

Re: GL upload

Former Member — Thu, 15 Nov 2007 17:30:53 GMT

plz help

Re: GL upload

Former Member — Thu, 15 Nov 2007 17:34:19 GMT

Hi Sanajana,

see the documentaion of RFBIBL00 program.

For detailed documentation go through this link

http://help.sap.com/saphelp_45b/helpdata/en/e9/cb8a85eb0011d184650000e8a6bfbe/content.htm

<b>Reward Points if it helps</b>

Regards,

Satish

Message was edited by:

Satish Panakala

Re: GL upload

Clemenss — Thu, 15 Nov 2007 18:00:30 GMT

Hi sanjana,

YOU CAN NOT INPUT YOUR DATA DIRECTLY INTO BSEG and BKPF tables!!!

RFBIBL00 will post the FI documents in the same way as if they were entered manually. Posting means not only to update BKPF and BSEG tables but also a lot of secondary and index tables. The system consistency is guaranteed by standard processing: A documents gets posted completely or not at all.

I never worked with RFBIBL00 but with BAPI as mentioned. But as you are a beginner, you should go for LSMW - A link to an introductory documentation has been given tody in

Regards,

Clemens