on 05-09-2006 2:35 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Nishant,
Can you publish a sample data here?
Regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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???
.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.