Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

populating sap transaction from excel

Former Member
0 Kudos
219

Hi everyone-

Is it possible to populate an SAP transaction (FV50 specifically) from an Excel worksheet?

thanks!

1 ACCEPTED SOLUTION

Former Member
0 Kudos
127

Use function module 'ALSM_EXCEL_TO_INTERNAL_TABLE' to get the excel data in an internal table and use BDC to load data from the internal table to FV50 transaction

cheers

sharmistha

5 REPLIES 5

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos
127

You could copy and paste rows and columns from excel into the table control. If that is what you are asking. There is no function button on the FV50 screen that provides this functionality.

Regards,

Rich Heilman

Former Member
0 Kudos
128

Use function module 'ALSM_EXCEL_TO_INTERNAL_TABLE' to get the excel data in an internal table and use BDC to load data from the internal table to FV50 transaction

cheers

sharmistha

0 Kudos
127

Can you give me a bit more detail on this? How is the function module 'ALSM...' called in the abap code? How is BDC called to get the data from the internal table to the fv50 transaction?

thanks.

0 Kudos
127

can a function module be called from the transaction line (called at the same place you would call se16, for example)?

0 Kudos
127

I mean to say,

you write a program which will call function module

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = specify full path of excel file

i_begin_col = 1

i_begin_row = 2

i_end_col = 50

i_end_row = 1000

TABLES

intern = it_itab1

EXCEPTIONS

inconsistent_parameters = 1

upload_ole = 2

OTHERS = 3.

You can record FV50 in SHDB and pass the required values from the internal table in FV50 an then call transaction in display mode.

All the values from the excel sheet will be populated in FV50 transaction.