How to upload document records from excel?

[Former Member]

Hi,

I want to know if there is any way we can upload document records from excel file into the F-02, FB50, FB60, FB70 screens. My users wants to enter the records in the excel file with the correct posting key and have it uploaded to those screens instead of manually entering it in the screens.

I know lsmw can do this but we can move lsmw into production. we also dont want to hire abapers to write a program for this.

i heard sap is very powerful so i want to know if they already have this simply function built into their system.

[former_member662602 · Accepted solution]

Hi Raja Kumar,

SAP is powerful but it also has their own limitation. : )

There's some options you can do eg: in Txn F-02. You can use account assignment model or fast data entry. You can manually upload the data in the template into this field.

If u use account assignment model, there's no need for u to key in the same GL every month. Just enter it for the first time and u can edit and post it anytime u want.

If u use fast data entry, u can upload manually the template into each field in the screen.

Other ways, you have to ask ABAPer to create one program that can upload the data into the F-02, FB50, FB60, FB70 screens. It's advisable u ask ABAPer to create one program that can upload the template into F-02, FB50, FB60, FB70 screens. Only one time the program created and u can use for the whole life of the SAP. : )

Hope this will help.

TQ

Regards,

Nazrul

[Former Member]

You can use LSMW to do this or in my previous company, they developed a customized program to upload entries from excel to SAP 😃

[Former Member]

Hi,

The updation to SAP dependa uopon the volume of data. You can use LSMW . If your requirement is not fullfilled use BDC program that will call the document. Get the help of your ABAP er foe BDC.

If the volume is very high go for BDC.

Regards,

APT

[Former Member]

The best way to upload excel files voluminously is by using lsmw... but if you dont want to use it....Ask you ABAPER to create a BDC program that will call the document. It is an ABAP issue. I know your ABAPER can do this.