data upload

[Former Member]

Hi Expert,

I have to upload the data from excel file into me23n transaction code as in me23n transaction code there is one tab CONFORMATIONS in that tab

three field are there i.e CC,DELIVARY DATE,QUANTITY.my requirement is data from excel should be uploaded into this 3 fields.

Please any one can throw some light on this,

Regards,

Anitha.

[RaymondGiuseppi]

Read data from Excel

- Look at Copying data from Microsoft Excel to ABAP using OLE

Update purchase order

- Look at BAPI : BAPI_PO_CHANGE parameters

Regards,

Raymond

[Former Member]

First of all Get the technical Information of those three fields.

and use SET PARAMETER ID to assign values to these fields(uploaded from excell sheet ).

and call the Transaction.

Regards,

Raj..

[Former Member]

Hi nagaraj,

I have to upload 3 field data from excel i.e field name are EBTYP,EINDT,MENGE.this field we can find in transaction code me23n under tab CONFORMATION.

please can u tell me how to write the code .

Regards,

Am

[Former Member]

Hi Anata,

Please tell me how you uploading the data using BAPI or BDC?

Use the standard BAPI's  BAPI_PO_CREATE or BAPI_PO_CHANGE using the BAPI parameter. OR use BDC recording.

Thanks,

Saleem

[Former Member]

Hi saleem,

using bapi or bdc how to upload this data pleae can suggest the code how to write.

Regards,

Am

[Former Member]

Hi Antha,

use the below link.. and write the code in SE38 transaction.

http://wiki.sdn.sap.com/wiki/display/HOME/Abap+code+on+BAPI+PO+Change

[Former Member]

http://wiki.sdn.sap.com/wiki/display/HOME/Abap+code+on+BAPI+PO+Change

try this link.

Regards

Mahesh

[Former Member]

Hi Mahesh,

Please cau suggest me how to proceed with code.

Regards,

Am

[ThomasZloch]

I think you have received plenty of hints, please start working on this yourself now.

Locked.

Thomas