11-12-2007 6:47 PM
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
11-13-2007 3:32 AM
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.
11-12-2007 9:37 PM
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.
11-13-2007 3:26 AM
11-13-2007 3:32 AM
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.
11-13-2007 2:30 PM