topic Re: Sample Mapping Template for X12 850 with iDoc in Application Development and Automation Discussions

Sample Mapping Template for X12 850 with iDoc

Former Member — Wed, 17 Oct 2012 05:17:32 GMT

Hi All,

I have requirement to generate text file with X12 format for transaction set 850(Purchase Order), Please any one can share Mapping Template for X12 850 with Message type ORDERS and iDOC type(ORDRS01 or ORDRS02 or ORDRS03 or ORDRS04).

Thanks!

Jelli

Re: Sample Mapping Template for X12 850 with iDoc

Former Member — Tue, 23 Oct 2012 10:42:49 GMT

Hi All,

Please suggest some solution, I am stuck at Mapping of X12 850 to iDoc type(ORDERS01,ORDERS02, ORDERS03, ORDERS04, ORDERS05) and have to complete the project.

Appreciate Suggestions

Thanks!

Jelli

Re: Sample Mapping Template for X12 850 with iDoc

Former Member — Tue, 23 Oct 2012 11:03:51 GMT

Hi,

Is there any specific mapping you are stuck with? Or you are looking for sample mapping as whole? Do a search over the internet with "mapping x12 850 to idoc" and you should get some sample mapping.

Regards,

Re: Sample Mapping Template for X12 850 with iDoc

Former Member — Tue, 23 Oct 2012 11:59:55 GMT

Hi Rudhra,

Thanks for yours quick replying, I have prepared Mapping Field from iDoc(ORDERS04) with X12 850 from sample mapping from google.

Looking for specific fields, The Following fields i have not found with our iDoc structure, Could you please add yours suggestion on this or would like to appreciate if you can share any mapping sheet if you have.

Data Fields
CUR	CUR01	Entity Identifier Code
FOB	FOB01	Shipment Method of Payment
	FOB02	Location Qualifier
	FOB04	Transportation Terms Qualifier Code
	FOB05	Transportation Terms Code
	FOB08	Risk of Loss Qualifier
	FOB09	Description
ITD	ITD02	Terms Basis Date Code
	ITD05	Terms Discount Days Due
	ITD12	Description
TD5	TD502	Identification Code Qualifier
	TD503	Identification Code
	TD504	Transportation Method/Type Code
	TD512	Service Level Code
SCH	SCH11	Request Reference Number
	SCH12	Assigned Identification
PID	PID01	Item Description Type
REF	REF01	Reference Identification Qualifier
	REF03	Description
AMT	AMT01	Amount Qualifier Code

Control Information
ISA	ISA01	Authorization Information Qualifier
	ISA02	Authorization Information
	ISA03	Security Information Qualifier
	ISA04	Security Information
	ISA05	Interchange ID Qualifier
	ISA06	Interchange Sender ID
	ISA07	Interchange ID Qualifier
	ISA08	Interchange Receiver ID
	ISA09	Interchange Date
	ISA10	Interchange Time
	ISA11	Interchange Control Standards ID
	ISA12	Interchange Control Version Number
	ISA13	Interchange Control Number
	ISA14	Acknowledgement Requested
	ISA15	Test Indicator
	ISA16	Subelement Separator
ST	ST02	Transaction set control number
SE	SE02	Transaction set control number

Thanks!

Jelli

Re: Sample Mapping Template for X12 850 with iDoc

Former Member — Tue, 23 Oct 2012 12:31:44 GMT

You can go to WE60 and look for the documentation for ORDERS05 idoc. There may be different source/target based on the business requirement and the way your system is set up.

Still...Just for your reference

CUR : E1EDK01

FOB : E1EDK17 ( Look for correct qualifier )

ITD : E1EDK18 ( Look for correct Qualifier)

TD : E1EDKA1/E1EDKP1 ( Look for correct qualifier both sides )

AMT : E1EDP01

PID : E1EDP19 ( Look for correct Qualf )

REF : Should be mapped to/from based on Qualf : E.G : Customer PO No - E1EDK02 ( Qualf = "001" )

ISA Segmant should be mapped to/from the control record of the Idoc

ST/SE : Your middleware should be able to generate this for you.

The above maping may not be accurate but will give you an idea as I have explained already in the beginning. Best way is to generate an idoc and then search the field from WE02. and Then map it the sample X12(EDI text file) you are having.

Hope this helps.

Regards,