Map excel cells to BAPI

[Former Member]

Hi...

I am trying to map excel cells to a specific BAPI...

can anyone please give me an example of how to do this?

thanks much

[Former Member]

Hi Brian,

You need to first read the Excel contents into an internal table,

there are many function modules available for this,

e.g. TEXT_CIONVERT_XLS_TO_SAP,

ALSM_EXCEL_TO_INTERNAL_TABLE, etc.

then once you get the data into the internal table, you can filter the

reqd data and pass it to the BAPI.

Regards,

Samson Rodrigues.

[Former Member]

You need to read the excel file into an internal table and then map from internal table to your BAPI.

You can use FM GUI_UPLOAD to upload file into an internal table.

[Former Member]

BAPI-step by step procedure

http://www.sapgenie.com/abap/bapi/example.htm

list of all BAPI's

http://www.planetsap.com/LIST_ALL_BAPIs.htm

[Former Member]

Hi Brian,

You need to first read the Excel contents into an internal table,

there are many function modules available for this,

e.g. TEXT_CIONVERT_XLS_TO_SAP,

ALSM_EXCEL_TO_INTERNAL_TABLE, etc.

then once you get the data into the internal table, you can filter the

reqd data and pass it to the BAPI.

Regards,

Samson Rodrigues.

[Former Member]

Hi Samson: Let me try that...thanks for the tip

brian