Input File Format for Creating SO's using BAPI

This question is answered

Hi,

Iam using BAPI_SALESORDER_CREATEFROMDAT1 to create sales orders by writing custom program. The input file is in excel format with different sizes of rows as I have header record, Item record, Conditions, Partners etc..

Can anyone tell me how can I upload this type of file in my program?

Thanks,

Smitha.

Tags:

abap

Former Member

October 10, 2007 at 06:47 AM

0
Likes

Correct Answer

Former Memberreplied

October 10, 2007 at 05:07 AM

Hi,

U can dircetly upload the exel file using the FM :

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'.

Declare internal table which has fields equivalent to number of columns in Excel file.