Typical X12/EDIFACT/SAP IDoc mapping: relationship between different O2C business concepts and SAP IDoc/X12/EDIFACT structures

In the following table I’ve tried to connect typical business concepts used in order to cash (O2C) process and EDI documents’ groups/loop, segments/records and elements/fields.
I used structures from SAP IDoc of ORDERS05, INVOIC02 and DELVRY03 (but it could be applied to other DELVRY* and SHPMNT* messages); X12 of 850 (Purchase Order), 810 (Invoice) and 856 (Advanced Ship Notice); EDIFACT – segments used everywhere (ORDERS, INVOIC and DESADV in particular)

This table is based on my experience and your implementation might be different. Please also take into account that different formats might use different codelists so you cannot map codes as is – you’ll need a code conversion.

SAP IDoc X12 EDIFACT
Partners
Segments/records used
(ORDERS05, INVOIC02) E1EDKA1 (header), E1EDPA1 (details)
(DELVRY03) E1ADRM1
N1 loop NAD
Partner ID/Type (ORDERS05, INVOIC02) E1EDKA1 / PARTN, Partner number
-or-
E1EDKA1 / LIFNR, Vendor number at customer location

(DELVRY03) E1ADRM1 / PARTNER_ID

N1 / N1-03
N1 / N1-04. Some values are 1 (DUNS), 91 (Seller assigned), 92 (Buyer assigned)
NAD / C082 / 3039
NAD / C082 / 3055. Some values are 16 (DUNS), 91 (Seller assigned), 92 (Buyer assigned)
Name(s) (ORDERS05, INVOIC02) E1EDKA1 / NAME1, NAME2, NAME3 and NAME4
(DELVRY03) E1ADRM1 / NAME1, NAME2, NAME3 and NAME4
N1 / N1-02
N2 / N2-01, N2 / N2-02 (additional names)
NAD / C080 / 3036, might be several
Address Line(s) (ORDERS05, INVOIC02) E1EDKA1 / STRAS and STRS2
(DELVRY03) E1ADRM1 / STREET1, STREET2 and STREET3
N3 / N3-01, N3 / N3-02 NAD / C059 / 3042
City (ORDERS05, INVOIC02) E1EDKA1 / ORT01
(DELVRY03) E1ADRM1 / CITY1
N4 / N4-01 NAD / 3164
Postal/ZIP Code (ORDERS05, INVOIC02) E1EDKA1 / PSTLZ
(DELVRY03) E1ADRM1 / POSTL_COD1
N4 / N4-03 NAD / 3251
State/Province (ORDERS05, INVOIC02) E1EDKA1 / REGIO
(DELVRY03) E1ADRM1 / REGION
N4 / N4-02 (usually for USA/Canada)
N4 / N4-06 where N4 / N4-05 = “RJ” (Region) or other types (for other countries)
NAD / C819 / 3229
Country (ORDERS05, INVOIC02) E1EDKA1 / LAND1
(DELVRY03) E1ADRM1 / COUNTRY1
N4 / N4-04 NAD / 3207. ISO 3166 codelist.
more details here
some typical partners
Ship From (DELVRY03) E1ADRM1 / PARTNER_Q = “OSP” (Shipping Point) N1 where N1-01 = “SF” (Ship From) NAD where NAD / 3035 = “SF” Ship from()
Ship To (ORDERS05, INVOIC02) E1EDKA1 / PARVW, (DELVRY03) E1ADRM1 / PARTNER_Q = “WE” (Goods recipient) N1 where N1-01 = “ST” (Ship To) NAD where NAD / 3035 = “ST” (Ship to) or “CN” (Consignee) or “DP” (Delivery party)
Bill To (ORDERS05, INVOIC02) E1EDKA1 / PARVW, (DELVRY03) E1ADRM1 / PARTNER_Q = “RE” (Invoice recipient) N1 where N1-01 = “BT” (Bill-to-Party) NAD where NAD / 3035 = “IV” (Invoicee)
Buyer (ORDERS05, INVOIC02) E1EDKA1 / PARVW, (DELVRY03) E1ADRM1 / PARTNER_Q = “AG” (Sold-to party) N1 where N1-01 = “BY” (Buying Party (Purchaser)) NAD where NAD / 3035 = “BY” (Buyer)
Seller (ORDERS05, INVOIC02) E1EDKA1 / PARVW, (DELVRY03) E1ADRM1 / PARTNER_Q = “LF” (Vendor) N1 where N1-01 = “SE” (Selling Party) NAD where NAD / 3035 = “SE” (Seller)
Carrier (ORDERS05, INVOIC02) E1EDKA1 / PARVW, (DELVRY03) E1ADRM1 / PARTNER_Q = “SP” (Carrier) N1 where N1-01 = “CA” (Carrier) NAD where NAD / 3035 = “CA” (Carrier)
Contact Information
Segments/records used
(ORDERS05, INVOIC02) E1EDKA1 (header), E1EDPA1 (details)
(DELVRY03) E1ADRM1
PER CTA/COM
Name (ORDERS05, INVOIC02) E1EDKA1 / BNAME PER / PER-02 CTA / C056 / 3412
Phone (ORDERS05, INVOIC02) E1EDKA1 / TELF1
(DELVRY03) E1ADRM1 / TELEPHONE1
PER / PER-04 or 06 or 08 where appropriate PER / PER-03 or 05 or 07 = “TE” (Telephone) COM / C076 / 3148 where COM / C076 / 3155 = “TE” (Telephone)
Fax (ORDERS05, INVOIC02) E1EDKA1 / TELFX
(DELVRY03) E1ADRM1 / TELEFAX
PER / PER-04 or 06 or 08 where appropriate PER / PER-03 or 05 or 07 = “FX” (Fax) COM / C076 / 3148 where COM / C076 / 3155 = “FX” (Fax)
Email (DELVRY03) E1ADRM1 / E_MAIL PER / PER-04 or 06 or 08 where appropriate PER / PER-03 or 05 or 07 = “EM” (Email) COM / C076 / 3148 where COM / C076 / 3155 = “EM” (Email)
References
Segments/records used
(ORDERS05, INVOIC02) E1EDK02 (header), E1EDP02 (details)
(DELVRY03) E1EDL24 / E1EDL41, E1EDL24 / E1EDL41 / E1EDL43 (both deatils)
REF (also N9, L11 and other segments with 127/128 elements) RFF
more details here
some typical references
Purchase Order Number (ORDERS05, INVOIC02) E1EDK02 (or E1EDP02 (details)) / BELNR where QUALF = “001” (Customer Purchase Order)
(DELVRY03) E1EDL24 / E1EDL41 / BSTNR where E1EDL24 / E1EDL41 / QUALI = “001”
REF / REF-02 where REF / REF-01 = “PO​” (Purchase Order Number) RFF / C506 / 1154 where RFF / C506 / 1153 = “ON” (Order number (purchase))
Invoice Number (ORDERS05, INVOIC02) E1EDK02 (or E1EDP02 (details)) / BELNR where QUALF = “009” (Invoice Number) REF / REF-02 where REF / REF-01 = “IV” (Seller’s Invoice Number) RFF / C506 / 1153 = “IV” (IV Invoice number)
Bill of Lading REF / REF-02 where REF / REF-01 = “​BM” (Bill of Lading Number) RFF / C506 / 1153 = “BM” (Bill of lading number)
Dates
Segments/records used
(ORDERS05, INVOIC02) E1EDK03 (header), E1EDP03 (details)
(DELVRY03) E1EDT13
DTM DTM
more details here
some typical dates
Requested Delivery Date (ORDERS05, INVOIC02) E1EDP03 / DATUM where E1EDK03 / IDDAT = “002” (Requested delivery date (customer)) DTM / DTM-02 where DTM-01 = “002” (Delivery Requested) DTM / C507 / 2380 where DTM / C507 / 2005 = “2” (Delivery date/time, requested)
Requested Ship Date (ORDERS05) E1EDP03 / DATUM where E1EDK03 / IDDAT = “010” (Shipping date) DTM / DTM-02 where DTM-01 = “010” (Requested Ship) DTM / C507 / 2380 where DTM / C507 / 2005 = “10” (Shipment date/time, requested)
Actual Ship Date (INVOIC02) E1EDP03 / DATUM where E1EDK03 / IDDAT = “010” (Shipping date)
(DELVRY03) E1EDT13 / NTANF where E1EDT13 / QUALF = “006” (Goods Issue)
DTM / DTM-02 where DTM-01 = “​011” (Shipped) DTM / C507 / 2380 where DTM / C507 / 2005 = “11” (Despatch date and or time)
Estimated Delivery Date (ORDERS05, INVOIC02) E1EDP03 / DATUM where E1EDK03 / IDDAT = “002” (Requested delivery date (customer))
(DELVRY03) E1EDT13 / NTANF where E1EDT13 / QUALF = “007” ((Outbound) Delivery)
DTM / DTM-02 where DTM-01 = “​017” (Estimated Delivery) DTM / C507 / 2380 where DTM / C507 / 2005 = “17” (Delivery date/time, estimated)
Free-form text
Segments/records used
(ORDERS05, INVOIC02) E1EDKT1 + E1EDKT2 (header), E1EDPT1 + E1EDPT2 (details)
(DELVRY03) E1TXTH8 + E1TXTP8 (header), E1TXTH9 + E1TXTP9 (details)
(general rule for IDocs – look for records with TDLINE element)
N9/MSG FTX
more details here
Payment Terms
Segments/records used E1EDK18 where E1EDK18 / QUALF = “001” (Payment term 1) (or “002” or “003” if multiple discounts) ITD​​ PAT​ + PCD (for terms discount data)
Terms code ITD / ITD-01 PAT / 4279
Terms description E1EDK18 / ZTERM_TXT where E1EDK18 / QUALF = “001” (Payment term 1) or “005” (Description of Payment Term) ITD / ITD-12 PAT / C110 / 4276
Basis code (defines the date used as the basis for discount) ITD / ITD-02 PAT / C112 / 2475
Net due date E1EDK03 / DATUM where E1EDK03 / IDDAT = “028” (Due date) ITD / ITD-06 DTM / C507 / 2380 where DTM / C507 / 2005 = “138” (Payment date)
Net days due ITD / ITD-07
Discount: percent E1EDK18 / PRZNT where E1EDK18 / QUALF = “001” (Payment term 1) ITD / ITD-03 PCD / C501 / 5482
Discount: due date ITD / ITD-04 DTM / C507 / 2380 where DTM / C507 / 2005 = “12” (Terms discount due date/time)
Discount: days due E1EDK18 / TAGE where E1EDK18 / QUALF = “001” (Payment term 1) ITD / ITD-05 PAT / C112 / 2152 where PAT / C112 / 2151 = “D” (Day)
Discount: amount ITD / ITD-08 (never seen, but probably this) MOA / C516 / 5004 where MOA / C516 / 5025 = “​52” (Discount amount)
Shipment/Delivery Terms
Segments/records used
(ORDERS05, INVOIC02) E1EDK17 / LKOND and E1EDK17 / LKTEXT​
(DELVRY03) E1EDL20 / INCO1 and E1EDL20 / INCO2
FOB TOD + LOC
INCO (ORDERS05, INVOIC02) E1EDK17 / LKOND
(DELVRY03) E1EDL20 / INCO1
FOB / FOB-05 TOD / C100 / 4053
Location (ORDERS05, INVOIC02) E1EDK17 / LKTEXT​
(DELVRY03) E1EDL20 / INCO2
FOB / FOB-03 LOC / C517 / 3225, usually where 3227 = “1” (Place of terms of delivery)
Transportation Information
Segments/records used (ORDERS05) E1EDK01 TD5 TDT
Mode (method) of transportation (ORDERS05) E1EDK01 / VSART
(DELVRY03) E1EDL20 / VSBED

please note that these values are coded, so you need to know the codelist.

TD5 / TD5-04 TDT / C220​. UNREC 19 codelist
Transport means (DELVRY03) E1EDL20 / TRATY. Please note that these values are coded, so you need to know the codelist. TDT / C228
Carrier partner with the type of “SP” (Carrier), see Partner section above TD5 / TD5-03 is usually the SCAC code. Or, look for a partner with the type of “CA” (Carrier) TDT / C040. Or, look for a partner with the type of “CA” (Carrier)
Currency
Segments/records used (ORDERS05, INVOIC02) E1EDK01/ CURCY. ISO 4217 codelist CUR. ISO 4217 codelist CUX. ISO 4217 codelist
Total Amounts (Summary)
Segments/records used (INVOIC02) E1EDS01 AMT, TDS MOA
some typical total amounts
​Invoice Total (INVOIC02) E1EDS01 / SUMME where SUMID = “011” (Billed value​) TDS-01.

TDS-01 is the total amount of invoice (including charges, less allowances) before terms discount (if discount is applicable).

MOA / C516 / 5004 where MOA / C516 / 5025 = “​128” (Total amount) or “39” (Invoice total amount) or “77” (Invoice amount)

39 = Invoice total amount. [5444] Total sum charged in respect of one or more Invoices in accordance with the terms of delivery.
77 = Invoice amount. [5068] Total sum charged in respect of a single Invoice in accordance with the terms of delivery.
128 = Total amount. The amount specified is the total amount.

​Gross Invoice Amount (INVOIC02) E1EDS01 / SUMME where SUMID = “010” (​Net invoice value) TDS-02.

TDS-02 indicates the amount upon which the terms discount amount is calculated.

MOA / C516 / 5004 where MOA / C516 / 5025 = “​86” (Message total monetary amount)
​Total Less Cash Discount TDS-03.

TDS-03 is the amount of invoice due if paid by terms discount due date (total invoice or installment amount less cash discount).

MOA / C516 / 5004 where MOA / C516 / 5025 = “​129” (Total amount subject to payment discount)

129 = Total amount subject to payment discount. Part of the invoice amount which is subject to payment discount.

Total Discounts/Surcharges. There might be differences between formats. It could be terms discount amount (i.e. “if you pay this invoice before YYYYMMDD you’ll have the following discount”) or sum of all allowances/charges – implementation depends on such details. (INVOIC02) E1EDS01 / SUMME where SUMID = “020” (Total discounts/surcharges) TDS-04. This one is used for Terms Discount (i.e. discount described in ITD Terms of Sale segment) and is (might be) slightly different from other formats.

TDS-04 indicates the total amount of terms discount.

MOA / C516 / 5004 where MOA / C516 / 5025 = “​131” (Total charges/allowances) or “109” (Payment discount amount) or “136” (Total invoice additional amount)

131 = Total charges/allowances. The amount specified is the total of all charges/allowances
109 = Payment discount amount. Self-explanatory
136 = Total invoice additional amount. (5140) Amount to be added to the sum of invoice line amounts to arrive at the total invoice amount.

Tax Total (INVOIC02) E1EDS01 / SUMME where SUMID = “005” (Sales tax total) No dedicated segment/qualifier. Use the sum of TXIs MOA / C516 / 5004 where MOA / C516 / 5025 = “​176” (Message total duty/tax/fee amount)

176 – Message total duty/tax/fee amount. Total of all duty/tax/fee amounts

​Line Item Total. The sum of line items amounts, without any additional charges (like freight charge) (INVOIC02) E1EDS01 / SUMME where SUMID = “017” (Total item net value​) ​I saw AMT / AMT-02, where AMT / AMT-01 = “NE” (Net Billed) MOA / C516 / 5004 where MOA / C516 / 5025 = “​203” (Line item amount) or “66” (Goods item total) or “79” (Total line items amount)

203 Line item amount. Goods item total minus allowances plus charges for line item. See also Code 66
66 Goods item total. Net price x quantity for the line item.
79 Total line items amount. The sum of all the line item amounts.

Taxes
Segments/records used (ORDERS05, INVOIC02) E1EDK04 (header), E1EDP04 (details) TXI TAX
Tax type/code E1EDK04 (or E1EDP04 for details) / MWSKZ. SAP uses its own codelists TXI / TXI-01 TAX / C241 / 5153
Percent E1EDK04 (or E1EDP04 for details) / MSATZ TXI / TXI-03 TAX / C243 / 5278. This is AN field – check the format used in your implementation!
Tax Jurisdiction E1EDK04 (or E1EDP04 for details) / TXJCD TXI / TXI-05
Tax amount E1EDK04 (or E1EDP04 for details) / MWSBT TXI / TXI-02 MOA / C516 / 5004 where MOA / C516 / 5025 = “1” (VAT) or “124” (Tax amount)
Taxable amount TXI / TXI-08 MOA / C516 / 5004 where MOA / C516 / 5025 = “125” (Taxable amount)
Allowances/Charges
Segments/records used (ORDERS05, INVOIC02) E1EDK05 (header), E1EDP05 (details) Usually you should ask the client to provide all the codes used. SAC ALC + MOA (8)
A/C indicator E1EDK05 (or E1EDP05 for details) / ALCKZ SAC / SAC-01 ALC / 5463
Code E1EDK05 (or E1EDP05 for details) / KSCHL. SAP uses its own codelists SAC / SAC-02 ALC / C214 / 7161
Description E1EDK05 (or E1EDP05 for details) / KOTXT SAC / SAC-15 (in ALC group) FTX where FTX / 4451 = “ALC”
Amount E1EDK05 (or E1EDP05 for details) / BETRG SAC / SAC-05 MOA / C516 / 5004 where MOA / C516 / 5025 = “8” (Allowance or charge amount)
Percent E1EDK05 (or E1EDP05 for details) / KPERC SAC / SAC-07
more details here
Measurements
Segments/records used there are no dedicated records but elements
(INVOIC02) E1EDK01 / BRGEW and NTGEW (header), E1EDP01 / BRGEW and NTGEW (details)
(DELVRY03) E1EDL20 / BTGEW and NTGEW (header), E1EDL24 / BRGEW and NTGEW (details)
MEA MEA
MEA / 6311 is Measurement application qualifier
MEA / C502 / 6311 is Measurement dimension, coded
some typical measurements
Gross Weight (INVOIC02) E1EDK01 / BRGEW (header), E1EDP01 / BRGEW (details)
(DELVRY03) E1EDL20 / BTGEW (header), E1EDL24 / BRGEW (details)
MEA / MEA-03 where MEA / MEA-01 = “WT” (Weights) and MEA / MEA-02 = “G” (Gross Weight) MEA / 6311 = “WT” (Weights) or “AAE” (Measurement)
MEA / C502 / 6311 = “AAD” (Total gross weight) or ​”AAE” (Item gross weight) or “AAG” (Gross weight (item level)) or “G” (Gross weight)
Net Weight (INVOIC02) E1EDK01 / NTGEW (header), E1EDP01 / NTGEW (details)
(DELVRY03) E1EDL20 / NTGEW (header), E1EDL24 / NTGEW (details)
MEA / MEA-03 where MEA / MEA-01 = “WT” (Weights) and MEA / MEA-02 = “N” (Actual Net Weight) MEA / 6311 = “WT” (Weights) or “AAE” (Measurement)
MEA / C502 / 6311 = “AAC” (Total net weight) or “AAL” (Net weight) or “N” (Actual net weight)
Tare Weight E1EDL37 / TARAG MEA / 6311 = “WT” (Weights) or “AAE” (Measurement)
MEA / C502 / 6311 = “​”T (Tare weight)
Volume MEA / 6311 = “VOL” (Volume) or “AAE” (Measurement)
MEA / C502 / 6311 = “ABJ” (Volume) or “​AAW” (Gross volume​​) or “​AAX” (Net volume)
Product Information
Segments/records used
(INVOIC02, ORDERS05) E1EDP01 group
(DELVRY03) E1EDL24 group

(850) PO1 loop
(810) IT1 loop
(856) HL where HL-01 = “I” (Item) loop, LIN segment in particular
LIN group with appropriate segments
Product Identification (INVOIC02, ORDERS05) E1EDP19 / IDTNR where QUALF is one of “001”, “002”, “003”, “004”
(DELVRY03) E1EDL24 / KDMAT, MATNR, EAN11
(850) PO1, (810) IT1, (856) LIN – pairs of elements with ID of 234 (ID) and 235 (qualifier) LIN, PIA
Buyer product ID (INVOIC02, ORDERS05) E1EDP19 / IDTNR where QUALF is one of “001” (Material number used by customer)
(DELVRY03) E1EDL24 / KDMAT (Material belonging to the customer)
(850) PO1, (810) IT1, (856) LIN – pairs of elements with ID of 234 (ID) and 235 (qualifier) where qualifier is “BP” (Buyer’s Part Number) or “IN” (Buyer’s Item Number) LIN (or PIA) / C212 / 7140 where LIN (or PIA) / C212 / 7143 = “IN” (Buyer’s item number)
Seller/supplier/vendor product ID (INVOIC02, ORDERS05) E1EDP19 / IDTNR where QUALF is one of “002” (Material number used by vendor)
(DELVRY03) E1EDL24 / MATNR (Material Number)
(850) PO1, (810) IT1, (856) LIN – pairs of elements with ID of 234 (ID) and 235 (qualifier) where qualifier is “VP” (Vendor’s (Seller’s) Part Number) or “VN” (Vendor’s (Seller’s) Item Number) LIN (or PIA) / C212 / 7140 where LIN (or PIA) / C212 / 7143 = “VP” (Vendor’s (seller’s) part number) or “SA” (Supplier’s article number) or “VN” (Vendor item number)
Manufacturer product ID (INVOIC02, ORDERS05) E1EDP19 / IDTNR where QUALF is one of “004” (Manufacturer part number) (850) PO1, (810) IT1, (856) LIN – pairs of elements with ID of 234 (ID) and 235 (qualifier) where qualifier is “MG” (Manufacturer’s Part Number) LIN (or PIA) / C212 / 7140 where LIN (or PIA) / C212 / 7143 = “MF” (Manufacturer’s (producer’s) article number)
SKU (Stock Keeping Unit) (850) PO1, (810) IT1, (856) LIN – pairs of elements with ID of 234 (ID) and 235 (qualifier) where qualifier is “SK” (Stock Keeping Unit (SKU)) LIN (or PIA) / C212 / 7140 where LIN (or PIA) / C212 / 7143 = “SK” (SKU (Stock keeping unit))
UPC/EAN (INVOIC02, ORDERS05) E1EDP19 / IDTNR where QUALF is one of “003” (International Article Number(EAN))
(DELVRY03) E1EDL24 / EAN11
(850) PO1, (810) IT1, (856) LIN – pairs of elements with ID of 234 (ID) and 235 (qualifier) where qualifier is “UP” (U.P.C. Consumer Package Code) or “EN” (European Article Number (EAN) (2-5-5-1)) or some other codes starting with “U” (see documentation) LIN (or PIA) / C212 / 7140 where LIN (or PIA) / C212 / 7143 = “UP” (UPC (Universal product code))
Product Name/Description (INVOIC02, ORDERS05) E1EDP19 / KTEXT where QUALF is one of QUALF is one of “001”, “002”, “003”, “004”
(DELVRY03) E1EDL24 / ARKTX (Short text for sales order item)
PID / PID-05 where PID / PID-01 = “F” (Free-form) IMD / C273 / 7008
Product Quantity (INVOIC02, ORDERS05) E1EDP01 / MENGE + MENEE (UoM)
(DELVRY03) E1EDL24 / LFIMG + VRKME (UoM)
(850) PO1 / PO1-02 + PO1 / PO1-03 (UoM)
(810) IT1 / IT1-02 + IT1 / IT1-03 (UoM)
(856) SN1 / SN1-02 + SN1 / SN1-03 (UoM)
QTY / C186 / 6060 usually where QTY / C186 / 6063 = depends on the document, usually:
(ORDERS) “21” (Ordered quantity)
(INVOIC) “47” (Invoiced quantity)
(DESADV) “12” (Despatch quantity)
Price (Net) (ORDERS05, INVOIC02) E1EDP01 / VPREI (Price (net))
(INVOIC02) E1EDP26 where E1EDP26 / QUALF = “006” (Net price)
(850) PO1 / PO1-04
(810) IT1 / IT1-04

it is also possible to use CTP segment if additional information is required

PRI / C509 / 5118 where PRI / C509 / 5125 = “AAA” (Calculation net)
Price (Gross) (INVOIC02) E1EDP26 where E1EDP26 / QUALF = “001” (Gross price) (850) PO1 / PO1-04
(810) IT1 / IT1-04

it is also possible to use CTP segment if additional information is required

PRI / C509 / 5118 where PRI / C509 / 5125 = “AAB” (Calculation gross)
Lot/Batch number (INVOIC02) E1EDP19 / IDTNR where QUALF is one of “010” (Batch number)
(DELVRY03) E1EDL24 / CHARG (Batch Number)
(850) PO1, (810) IT1, (856) LIN – pairs of elements with ID of 234 (ID) and 235 (qualifier) where qualifier is “LT” (Lot Number)
-or-
REF / REF-02 where REF / REF-01 = “LT” (Lot Number) or “BT” (Batch Number) or “B8” (Batch Number)
PIA / C212 / 7140 where PIA / C212 / 7143 = “NB” (Batch number)
-or-
RFF / C506 / 1154 where RFF / C506 / 1153 = “BT” (Batch number/lot number)
Manufactured Date DTM / DTM-02 where DTM-01 = “094” (Manufacture) DTM / C507 / 2380 where DTM / C507 / 2005 = “94” (Production/manufacture date)
Expiration Date (DELVRY03) E1EDL24 / VFDAT (Shelf Life Expiration or Best-Before Date) DTM / DTM-02 where DTM-01 = “036” (Expiration) or “511” (Shelf Life Expiration) DTM / C507 / 2380 where DTM / C507 / 2005 = “36” (Expiry date)
Country of Origin (DELVRY03) E1EDL35 / HERKL

(INVOIC02, ORDERS05) E1EDP19 / IDTNR where QUALF = “011” (Country of origin of material)

(850) PO1, (810) IT1, (856) LIN – pairs of elements with ID of 234 (ID) and 235 (qualifier) where qualifier is “CH” (Country of Origin Code) ALI / 3239
Hazardous Material Information (DELVRY03) E1EDD10 group DGS


Gennady Kim

3 thoughts on “Typical X12/EDIFACT/SAP IDoc mapping: relationship between different O2C business concepts and SAP IDoc/X12/EDIFACT structures

  1. Thank you so much for sharing this. I am working on developing my 1st interface with EDI and this really helped with the mapping. Do you have any such blogs related to mapping for RECADV D96A?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s