topic Re: Re: data upload in Application Development and Automation Discussions

Re: data upload

Former Member — Tue, 15 May 2012 08:19:53 GMT

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.

Re: Re: data upload

RaymondGiuseppi — Tue, 15 May 2012 08:50:55 GMT

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

Re: Re: data upload

Former Member — Tue, 15 May 2012 09:05:24 GMT

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..

Re: Re: data upload

Former Member — Tue, 15 May 2012 09:07:33 GMT

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

Re: Re: data upload

Former Member — Tue, 15 May 2012 09:10:31 GMT

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

try this link.

Regards

Mahesh

Re: Re: data upload

Former Member — Tue, 15 May 2012 10:34:14 GMT

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,

Re: Re: data upload

Former Member — Tue, 15 May 2012 10:36:19 GMT

Hi saleem,

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

Regards,

Re: Re: data upload

Former Member — Tue, 15 May 2012 10:38:11 GMT

Hi Mahesh,

Please cau suggest me how to proceed with code.

Regards,

Re: Re: data upload

Former Member — Tue, 15 May 2012 10:45:01 GMT

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

Re: Re: data upload

ThomasZloch — Tue, 15 May 2012 10:53:22 GMT

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

Locked.

Thomas