populating sap transaction from excel

[Former Member]

Hi everyone-

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

thanks!

[RichHeilman]

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]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.