Typical X12/EDIFACT/SAP IDoc mapping: scheduled line items in Purchase Orders

A short explanation on how companies describe/schedule multiple deliveries in their Purchase Orders in different EDI formats. For example, a company wants to purchase 200 kilograms of product ABC, but they want it to be delivered within several days, like 50 kilogram on 06 Oct 2020, 50 kilogram on 08 Oct 2020, 40 kilogram on 10 Oct 2020 and 60 kilogram on 12 Oct 2020.

Order #0000001
Product ABC123 - 200 KG
    2020-10-06: 50 KGM
    2020-10-08: 50 KGM
    2020-10-10: 40 KGM
    2020-10-12: 60 KGM

X12 850
X12 uses SCH loop for this purpose. SCH-01 is the quantity, SCH-02 is the unit of measurement, SHC-05 is the date qualifier (usually 002 – Delivery Requested) and SCH-06 is the requested delivery date.

PO1*00010*200*KG***IN*ABC123'
    SCH*50*KG***002*20201006'     << 002 Delivery Requested
    SCH*50*KG***002*20201008'
    SCH*40*KG***002*20201010'
    SCH*60*KG***002*20201012'

EDIFACT ORDERS
EDIFACT usually uses SCC group with 4017 element of “1” (Firm) + QTY (11, Split quantity) and DTM (2, Delivery date/time, requested)

LIN+00010++ABC123:BP'
    QTY+21:200:KGM'     << 21 Ordered quantity
    SCC+1'     << 1 Firm
        QTY+11:50:KGM'          << 11 Split quantity
        DTM+2:20201006:102'     << 2 Delivery date/time, requested
    SCC+1'
        QTY+11:50:KGM'
        DTM+2:20201008:102'
    SCC+1'
        QTY+11:40:KGM'
        DTM+2:20201010:102'
    SCC+1'
        QTY+11:60:KGM'
        DTM+2:20201012:102'

SAP IDoc ORDERS
IDoc uses E1EDP20 segments with WMENG for quantity and EDATU for requested delivery date.

<E1EDP01 SEGMENT="1">
      <POSEX>000010</POSEX>
      <MENGE>200</MENGE>
      <MENEE>KGM</MENEE>

      <E1EDP20 SEGMENT="1">
            <WMENG>50</WMENG>
            <EDATU>20201006</EDATU>
      </E1EDP20>
      <E1EDP20 SEGMENT="1">
            <WMENG>50</WMENG>
            <EDATU>20201008</EDATU>
      </E1EDP20>
      <E1EDP20 SEGMENT="1">
            <WMENG>40</WMENG>
            <EDATU>20201010</EDATU>
      </E1EDP20>
      <E1EDP20 SEGMENT="1">
            <WMENG>60</WMENG>
            <EDATU>20201012</EDATU>
      </E1EDP20>

      <E1EDP19 SEGMENT="1">
            <QUALF>001</QUALF>
            <IDTNR>ABC123</IDTNR>
      </E1EDP19>
</E1EDP01>

Gennady Kim