Mapping from Orders01 to ORDERS05

[Former Member]

Hi,

My scenario is...

There is a purchase order document which is coming from another SAP system. Its in ORDERS01 form.

I have to create a sales order in my system through IDOC. The order type i have to use for this is ORDERS05. This is the requirement from client side.

My interface program should read in the ORDERS01 idoc and reformat the data into the ORDERS05 idoc for the sales order. The PO file is coming in a text format and its rests on the application server of my SAP system whose path I know.

How should I proceed for this reformatting and send me a sample program if u have which does reformatting from ORDERS01 to ORDERS05.

Regards

Nishant

[Former Member]

Hi Nishant,

When you say convert the data from Orders01 format to Orders05, are you supposed to add any addtional data that is not available in your file?

If you do not need to add any addtional data from your program itself, then change read the first record of the file using EDIDC record format and change the IDoc type field to ORDERS05 and save it back into the first record of the file.

Then call the function module edi_data_incoming with your file name and file port (defined in We21). It will take of creating the IDoc in in Orders05 format.

Also, I don't see any custom segment coming in your above pasted data. So clear the extension type in the control record (First record of the file).

If you also have custom segments, then first you need to change your extended iDoc type to refer the basic type orders05 instead of orders01.

Let me know if you find any difficulty in doing that.

Regards,

Nagaraju Chidurupalli.

Message was edited by: Nagaraju Chidurupalli

[Former Member]

Hi Nagaraju,

i am pasting the target file now.

EDI_DC ORDERS052 AG0016000010 X002001850 EDI_I_GEISKU0016000010 19990802092114ORDERS AG

E2EDK01 E2EDK01

E2EDK14 E2EDK14 0081000

E2EDK14 E2EDK14 00710

E2EDK14 E2EDK14 00600

E2EDK03 E2EDK03 00220060412

E2EDKA1 E2EDKA1 AG 0016000010 releaseVL01

E2EDKA1 E2EDKA1 RE 0016000010

E2EDKA1 E2EDKA1 WE 0026000015

E2EDKA1 E2EDKA1 RG 0016000010

E2EDK02 E2EDK02 001POTEST 19990729

E2EDKT1 E2EDKT1 ZXHDE

E2EDKT2 E2EDKT2 ISA@@ 3109786538 3109786538

E2EDKT2 E2EDKT2 N1@@@ST91 ROBERT F KENNEDY MED CNT 3300498

E2EDKT2 E2EDKT2 N1@@@SE92 68400

E2EDKT1 E2EDKT1 Z002E

E2EDKT2 E2EDKT2 DELIVER NEXT DAY

E2EDP01 E2EDP01 001 1 CS

E2EDP19 E2EDP19 002FG-S0FA

E2EDP19 E2EDP19 00100000000001

E2EDPT1 E2EDPT1 ZXITE

E2EDPT2 E2EDPT2 PO106=VCTEST-1

E2EDPT2 E2EDPT2 PO108=IN00000000001

E2EDPT2 E2EDPT2 J2X03=THIS IS A TEST ITEM

E2EDPT1 E2EDPT1 ZXITE

E2EDPT2 E2EDPT2 UOM=EA

DO u still think that just changing the control record will do..

Regards

Nishant

Message was edited by: Nishant Gupta

[Former Member]

Nishant,

Looks like most of the segments are exactly the same between ORDERS01 and ORDERS05. However, please compare each segment individually in the system and make sure that all the fields are same.

Once that is done, we will have to change the CONTROL record and read the file using IDOC_INBOUND_FROM_FILE or EDI_DATA_INCOMING accordingly.

Regards,

Ravi

Note - Please mark the helpful answers

[Former Member]

.

[Former Member]

Nishant,

Can you publish a sample data here?

Regards,

Ravi

[Former Member]

EDI_DC40 200000000000292803746C 3013 ORDERS01 Z1ORDERS ORDERS X3010 850 SAPD01 LS D01 850_O_SINGLILF0000102750 20060421155904 20060421155902

E2EDK01005 200000000000292803700000100000001 USD 1.00000 1028 ZPQA4500050098 0000102750

E2EDK14 200000000000292803700000200000002014CORP

E2EDK14 200000000000292803700000300000002009033

E2EDK14 200000000000292803700000400000002013ZPQA

E2EDK14 200000000000292803700000500000002011CARDINAL HEALTH MED PRODS AND SRVCS

E2EDK03 20000000000029280370000060000000201220060421

E2EDK03 20000000000029280370000070000000201120060421

E2EDKA1003 200000000000292803700000800000002AG M011 HOSP. SUPPLY/SCIENTIFIC PROD El Paso Replenishment Center P.O. BOX 95300 ALBUQUERQUE 87199 847- - NM M011 Custom Sterile(CS) CORP Cardinal Health 033

E2EDKA1003 200000000000292803700000900000002LF 0000102750 SAGE PRODUCTS INC E 26000019 S0FA 0000000000000 EN

E2EDKA1003 200000000000292803700001000000002WE M011 El Paso Replenishment Center El Paso 1 Butterfield Trail EL PASO 79906 US E EL PASO TX EN

E2EDK02 2000000000002928037000011000000020014500050098 20060421155902

E2EDK18 20000000000029280370000120000000200128 1.000

E2EDP01006 20000000000029280370000130000000200010 0010 10.000 EA 10.000 EA 29 1 290 LB 000000001 1 1

E2EDP20001 20000000000029280370000140000130310.000 0.000 20060620

E2EDP19001 2000000000002928037000015000013030016038 5 GL CAN -SPECIAL

E2EDS01 200000000000292803700001600000002001 1

E2EDS01 200000000000292803700001700000002009 10

how can i attach the file???

[Former Member]

.

[Former Member]

.