Upload data from excel file to "Fast Data Entry" in FB60

[Former Member]

Hi,

I have a requirement from users, they want to load data of G/L accounts items in FB60 using "Fast Data Entry" from an excel file.

I did some research and found out that the framework to transfer clipboard data into an SAP table(http://www.synactive.com/examples/example0016.html) seems to be the suitable solution.

However, I still cannot make it work.

Do you have any suggestion for my case ? How can I load data from an excel file to the transaction FB60?

Thanks in advance,

Hung

[saurabh_khandelwal · Accepted solution]

Dear Hung,

You can upload data through LSMW (Batch Input).

But you need to convert your excel sheet into CSV format or txt format.

Please take help of your ABAP team if required.

This will accommodate your requirement.

Regards

Saurabh

[Former Member]

Hi!

You can do by LSMW or BDC. You can do your own with LSMW and you can do BDC with the help of ABAP people. In LSMW you have to follow the serial steps with out any mistake. Give the transaction code and do the recording carefully.

[srinivasa_maruvada]

Hi

Use LSMW (Transaction code LSMW) or BDC (Transaction code SHD0). For BDC you need technical help where as you can create LSMW for your requirment.

Srinivas