Input File Format for Creating SO's using BAPI
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?
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.
Revert back if any issues,
Reward if helpful.