topic Re: Map excel cells to BAPI in Application Development and Automation Discussions

Map excel cells to BAPI

Former Member — Mon, 12 Nov 2007 18:47:08 GMT

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 — Mon, 12 Nov 2007 21:37:28 GMT

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 — Tue, 13 Nov 2007 03:26:57 GMT

BAPI-step by step procedure

list of all BAPI's

Former Member — Tue, 13 Nov 2007 03:32:53 GMT

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 — Tue, 13 Nov 2007 14:30:07 GMT

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

brian