help needed on bapi

[Former Member]

hi,

I would be extremely gratefull if anyone could guid me how to upload & post excel data sheet in sap using bapi or bapi active X control.Also how data coversion are to be carried off ?

Scenario :

Excel sheet:

Name1 Name2 Age

joe dave 24

smith S 26

I want to upload this using bapi & then post the document in transaction zf12.

[Former Member]

Amna,

You can upload the file from the

Presentation Server - CL_GUI_FRONTEND_UTILITIES->GUI_UPLOAD

Application Server - OPEN DATASET.

However, you have not mentioned what data you are uploading as the BAPI will change depending on that. Look at the BAPI transaction and you will find a list of BAPI's classified according to the business functionality.

Once the data is internal table, you need to pass that to the BAPI function module.

Regards,

Ravi

Note : Please mark the helpful answers.

[Former Member]

You said, that you have to post the data to transaction ZF12. This no standard SAP transaction, so there won't be a standard BAPI for this transaction. Perhaps you want to try the function module RFC_CALL_TRANSACTION. This works like the ABAP-command CALL TRANSACTION, see the ABAP-docu for details.