Sales Shipment Guidelines (IDoc)

See How to Use this Guide before reading the below information.

Message Type: PT_SHIPMENT_TH

Info Exchange Display Name: Shipment Transaction History

Data Element Occurs Format Length Enums Req Description
ZTLASN01 [1...1] - - - M Extended XML IDoc DESADV.DELVRY07.ZTLASN01 root element.
  IDOC [1...1] - - - M IDoc root.
    @BEGIN [1...1] String [0/*] - M Begin of message attribute. *1
    EDI_DC40 [1...1] - - - - IDoc control record.
      @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *2
      TABNAM [1...1] String [0/*] - O IDoc table name. *3
      MANDT [0…1] String [0/3] - O Client. *4
      DOCNUM [0…1] String [0/16] - M IDoc number. *5
      DOCREL [0…1] String [0/4] - O IDoc version release number. *6
      STATUS [0…1] String [0/2] - O Current IDoc processing status. *7
      DIRECT [0…1] String [0/*] - O Direction. *8
      OUTMOD [0…1] String [0/1] - O Output mode. *9
      EXPRSS [0…1] String [0/1] - O Overriding in inbound processing.
      TEST [0…1] String [0/1] UsageIndicator (IDoc) O Test flag.  *10
      IDOCTYP [1...1] String [0/30] - O IDoc basic type. *11
      CIMTYP [0…1] String [0/*] - O Name of extension type. *12
      MESTYP [0...1] String [0/*] - O Logical message type. *13
      MESCOD [0…1] String [0/3] - O Logical message code.
      MESFCT [0…1] String [0/3] - O Logical message function.
      STD [0…1] String [0/1] - O EDI standard.
      STDVRS [0…1] String [0/6] - O Version of EDI standard.
      STDMES [0…1] String [0/6] - O EDI message type.
      SNDPOR [1...1] String [1/10] - O Sender port (e.g. SAP System, EDI subsystem). *14
      SNDPRT [1...1] String [1/2] - O Partner type of sender. *15
      SNDPFC [0…1] String [0/2] - O Partner function of sender.
      SNDPRN [1...1] String [0/10] - O Partner number of sender. *16
      SNDSAD [0…1] String [0/21] - O Sender address (SADR).
      SNDLAD [1...1] String [1/70] - M Logical address of sender. Mandatory for TraceLink. Identifies the sender of the IDoc for the TraceLink system. *17

Must match the value that the sender has configured for themselves in TraceLink.

      RCVPOR [1...1] String [1/10] - O SAP receiver port. *18
      RCVPRT [0...1] String [0/2] - O Partner type of receiver. *19
      RCVPFC [0…1] String [0/2] - O Partner function of receiver. *20
      RCVPRN [1...1] String [1/10] - M Partner number of receiver. *21
      RCVSAD [0…1] String [0/21] - O Receiver address (SADR).
      RCVLAD [1...1] String [1/70] - M Logical address of receiver. Mandatory for TraceLink. Identifies the receiver of the IDoc for the TraceLink system's location ID. *22

Must match the value that the IDoc sender has configured for their receiver partner in TraceLink. GLN recommended.

      CREDAT [0…1] String [0/8] - M Date IDoc was created in format YYYYMMDD. *23
      CRETIM [0…1] String [0/6] - M Time IDoc was created in format HHMMSS. *24
      REFINT [0…1] String [0/14] - O Reference to interchange file.
      REFGRP [0…1] String [0/14] - O Reference to message group.
      REFMES [0…1] String [0/14] - O Reference to message.
      ARCKEY [0…1] String [0/70] - O EDI archive key.
      SERIAL [0…1] String [0/20] - O EDI/ALE: Serialization field.
    E1EDL20 [1...1] - - - M Delivery document header. *25
      @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *26
      VBELN [1...1] String [0/10] - M Delivery document number. *27
     

VSTEL

[0…1] String [0/4] - O Shipping Point/Receiving Point. *28
     

VKORG

[0…1] String [0/4] - O Sales Organization. *29
      ABLAD [0…1] String [0/25] - O Unloading Point. *30
      INCO1 [0…1] String [0/3] - O Incoterms (Part 1). *31
      INCO2 [0…1] String [0/28] - O Incoterms (Part 2). *32
      ROUTE [0…1] String [0/6] - O Shipping route. *33
      VSBED [0…1] String [0/2] - O Shipping conditions. *34
      BTGEW [0…1] String [0/17] - O Total Weight. *35
      NTGEW [0…1] String [0/15] - O Net Weight. *36
      GEWEI [0…1] String [0/3] WeightUOM C Weight Unit. *37
Mandatory if BTGEW or NTGEW populated and greater than zero.
      VOLUM [0…1] String [0/15] - O Volume. *38
      VOLEH [0…1] String [0/3] VolumeUOM C Volume unit. *39
Mandatory if VOLUM populated and greater than zero.
      ANZPK [0…1] String [0/5] - O Total number of packages in delivery. *40
      BOLNR [0…1] String [0/35] - O Bill of lading number. *41
      PODAT [0…1] String [0/8] - O Date (proof of delivery). *42
      POTIM [0…1] String [0/6] - O Confirmation time. *43
      ZTLHEADEREXT [1...1] - - - M Extension for custom header fields.
        @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *44
        DELIVERY_TYPE [1...1] String [1/20] DropShipIndicator (IDoc) O Type of delivery document. Used to identify whether delivery is an ASN or a drop ship notice. *45

If no value is sent, ASN is default.

        LOCATION [0…1] String [0/*] - O Location to associate the Transaction Histories with when they are created. *46

If the Product Track application is configured to use Locations to model your facilities, populate this element with one of the configured location values.

If the Product Track application is not configured to use Locations, omit this element.

        LOCATION_TYPE [0…1] String [0/*] LocationType C Qualifies field LOCATION. Identifies the location types. *47
Mandatory if LOCATION is populated.
        CUSTOMER_PORTAL_HISTORY_CODE [0…1] String [0/*] - O Unique customer-generated code for use in TraceLink portal to retrieve transaction histories. Customer is responsible for generating this code.
        PACKAGING_CODE [0…1] String [0/*] PackagingCode O Header level packaging code. This identifies the top level container type in the shipment. Maps to TD101 in outbound ASN. *48

Optional value for all dispensers.

        SHIPMENT_STATUS [0…1] String [0/*] ShipmentStatus C Status of shipment as a whole. Mapped to TD506 in outbound ASN. *49
Mandatory for Meijer.
        CUSTOMER_VENDORID [0…1] String [0/*] - C Supplier identifier in customer's internal system. Maps to REF segment in outbound ASN. *50
Mandatory for Walgreens, Walmart.
        ZTLADMINCONTACT [0…*] - - - O Administrative communications contact information. Identifies a person or office to whom administrative communications should be directed. Mapped to PER segment in OB ASN.

All fields in segment mandatory for Walgreens.

          @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *51
          CONTACT_FUNCTION [0…1] String [0/*] ContactFunction O Code identifying the major duty or responsibility of the person or group named as contact. Mapped to PER01. *52
  • Manufacturer must provide valid contact information of the person responsible for authenticating the pedigree information.
  • Wholesale Distributor must also provide the manufacturer's contact information. In addition, they must provide contact information for the responsible person in the wholesaler's organization.
  • Secondary Wholesale Distributor must provide their own contact information in addition to the contact information for both the previous wholesale distributor and the manufacturer.
          CONTACT_NAME [0…1] String [0/*] - O Name of the contact person responsible for authenticating the pedigree information. *53
          CONTACT_TELEPHONE [0…1] String [0/*] - O Telephone number of the contact person. *54
          CONTACT_EMAIL [0…1] String [0/*] - O Email address for the contact person. *55
      ZTLTXNSTATEMENT [1...10] - - - M Transaction statement for ASN. Use of segment dependent on FDA.
        @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *56
        QUALF [1...1] String [1/2] TxnStatement M Full transaction statement if all seven are required. Last statement (MeetsAllApplicableTSReqts) is a catch-all TS. The Direct Purchase options have been deprecated. *57
        STATEMENT [1...1] String [1/10] - M Statement of assertion.

Valid values: *58

  • TRUE, YES = Transaction statement assertion is true.
  • FALSE, NO = Transaction statement assertion is false.
        STATEMENT_TEXT [0…1] String [0/*] - O Optional text that can be provided by customer that will be used as the action Transaction Statement text. *59

If no content is provided, default text will be used. Default text based on the value of QUALF will be inserted if no STATEMENT_TEXT sent.

      E1EDL22 [0…1] - - - O Delivery Header Descriptions.
        @SEGMENT [1...1] String [0/*] - O Begin of segment attribute. *60
        VSTEL_BEZ [0…1] String [0/30] - O Description of shipping point. *61
        VKORG_BEZ [0…1] String [0/20] - O Description of sales organization. *62
        INCO1_BEZ [0…1] String [0/30] - O Incoterm description. *63
        ROUTE_BEZ [0…1] String [0/30] - O Route description. *64
        VSBED_BEZ [0…1] String [0/20] - O Description of the shipping conditions. *65
      E1EDL21 [0…1] - - - O Delivery Header Additional Data.
        @SEGMENT [1...1] String [0/*] - O Begin of segment attribute. *66
        LFART [0…1] String [0/4] - O Delivery Type. *67
        LPRIO [0…1] String [0/2] - O Delivery Priority. *68
        KDGRP [0…1] String [0/2] - O Customer group. *69
        TRAGR [0…1] String [0/4] - O Transportation Group. *70
        AULWE [0…1] String [0/10] - O Route schedule.
        E1EDL23 [0…1] - - - O Deliv.Header Addit.Data Descriptions.
          @SEGMENT [1...1] String [0/*] - O Begin of segment attribute. *71
          LFART_BEZ [0…1] String [0/20] - O Delivery type description. *72
          LPRIO_BEZ [0…1] String [0/20] - O Description of delivery priorities. *73
          KDGRP_BEZ [0…1] String [0/20] - O Description of customer group. *74
          TRAGR_BEZ [0…1] String [0/20] - O Description of transportation group. *75
          AULWE_BEZ [0…1] String [0/40] - O Description of route schedule.
      E1EDL18 [0…*] - - - O IDOC: Controlling (Delivery).
        @SEGMENT [1...1] String [0/*] - O Begin of segment attribute. *76
        QUALF [0…1] String [0/3] ControlCodesHeader O IDOC Qualifier: Control (Delivery). Valid value: ORI. *77
        PARAM [0…1] String [0/20] - O IDOC: Control Parameters.
      E1EDL55 [0…*] - - - O IDoc transport document and object reference number segment. Used to store Seal Number and Trailer Number required by Amerisource Bergen. Optional looping segment. Type of identifier stored in segment is defined by QUAL qualifier field.
This is a standard SAP DELVRY03 segment. No change is required to the schema. The only change required here is to use TraceLink custom qualifiers defined in the QUALF field.
        @SEGMENT [1...1] String [0/*] - C Begin of segment attribute. *78
        QUALF [1...1] String [0/3] ObjectReferenceNumber C Qualifier identifying transport object identifier. *79
Mandatory if @segment is populated.
        REFNR [0…1] String [0/17] - O Transport object reference number. Qualifier by QUALF value above. *80
      E1ADRM1 [1…*] - - - M ASN transfer from and transfer to party business and shipping identifiers and addresses.

Standard SAP outputs (not comprehensive):

  • Sold-to (AG)
  • Ship-to (WE)
  • Shipping point (OSP)
  • Sales organization (OSO)
  • Forwarding agent (SO)
  • Vendor (LF)
  • Manufacturer (MF)

To support DQSA partner requirements, use the following:

  • PARTNER_Q = AG sold-to = Recipient transfer-to party business address
  • PARTNER_Q = WE ship-to = Recipient transfer-to party shipping address
  • PARTNER_Q = OSO sales org = Sender transfer-from party business address
  • PARTNER_Q = OSP shipping point = Sender transfer-from party shipping adddress

SCAC carrier code also required. Store in this segment. Use:

  • PARTNER_ID = value for SCAC code
  • PARTNER_Q = ZSC (custom qualifier identifying SCAC code)
        @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *81
        PARTNER_Q [1...1] String [0/3] PartnerType M Qualifier identifying transfer-from or transfer-to business party location data. *82
        PARTNER_ID [0…1] String [0/17] - M Internal SAP sold-to partner number. *83
        JURISDIC [0…1] String [0/17] - O Location for tax calculation - Tax Jurisdiction Code. *84
        LANGUAGE [0…1] String [0/2] - O Language key. *85
        NAME1 [1...1] String [1/*] - M Business name for transfer-from or transfer-to party. *86
        NAME2 [0…1] String [1/*] - O Line 2 of business name transfer-from or transfer-to party.
        STREET1 [1...1] String [0/40] - M Business or shipping address for transfer-from or transfer-to party. *87
        STREET2 [0…1] String [0/40] - O Line 2 of business or shipping address for transfer-from or transfer-to party.
        POSTL_COD1 [1...1] String [0/10] - M Postal code. *88
        CITY1 [1...1] String [0/40] - M Town or city. *89
        TELEPHONE1 [0…1] String [0/30] - O Telephone number. *90
        TELEFAX [0…1] String [0/30] - O Fax number. *91
        E_MAIL [0…1] String [0/*] - O E-Mail Address.
        COUNTRY1 [1...1] String [0/3] - M Country indicator (ISO alphanumeric). *92
        REGION [1...1] String [0/3] - M Region, state code. *93
        TZCODE [0…1] String [0/6] - O Time zone for address location.
        TZDESC [0…1] String [0/35] - O Description of time zone code for address location.
        ZTLCONTACT [0…5] - - - O Custom segment for contact information for party in E1ADRM1 parent segment.
          @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *94
          NAME [1...1] String [0/40] - O Name of contact person. *95
          TITLE [0…1] String [0/40] - O Contact person's title. *96
          TELEPHONE [1...1] String [0/40] - O Telephone number of contact person. *97
          E_MAIL [0…1] String [0/*] - O Email address for contact person. *98
          URL [0…1] String [0/128] - O Website URL for contact person.
        ZTL_LICENSE [0…10] - - - O License number, jurisdiction, and agency for party in E1ADRM1 parent segment.
          @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *99
          LICENSENUMBER [1...1] String [0/30] - M License number for party. *100
          STATE [0...1] String [0/10] - O State or other jurisdiction for license holder. Please use the valid two character ISO state code if sending a state license identification number. *101
          AGENCY [0...1] String [0/40] - O Agency granting license to party. HDMA codes expected for agency codes.

Valid values: *102

  • D3 = National Association of Boards of Pharmacy
  • FW = State License Identification
        E1ADRE1 [0…10] - - - M Central Address Segment Group, Additional Data Segment for party identified in parent E1ADRM1 segment. Use this segment to provide global location type codes for each transfer-from and transfer-to business address in the ASN.

Use custom qualifiers in EXTEND_Q to define these identifiers:

  • EXTEND_Q = CMP = Company ID
  • EXTEND_Q = CMS = Company site ID
  • EXTEND_Q = DEA = DEA
  • EXTEND_Q = DUN = DUNS
  • EXTEND_Q = DN4 = DUNS+4
  • EXTEND_Q = GLN = GLN
  • EXTEND_Q = HIN = HIN
  • EXTEND_Q = STN = Ship-to party store number
  • EXTEND_Q = VAW = VAWD
          @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *103
          EXTEND_Q [1...1] String [0/3] ExternalPartnerIDType M Qualifier defining non-AP identifier stored in segment. *104
          EXTEND_D [1...1] String [0/70] - M Additional data (e.g. ILN or D&B number). *105
      E1EDT13 [0…*] - - - M IDoc: Target and actual begin and end dates for ASN events. Each instance of this segment can include either a start date (and time), or an end date, or both.
        @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *106
        QUALF [1...1] String [0/3] ConstraintDateType M Qualifier identifying ASN milestone constrained by dates in this segment. *107
        NTANF [0…1] String [0/8] - O Constraint for activity start (Basic). *108
        NTANZ [0…1] String [0/6] - O Constraint for activity start time (Basic). *109
        NTEND [0…1] String [0/8] - O Constraint for finish of activity (Basic). *110
        NTENZ [0…1] String [0/6] - O Basic finish time of the activity. *111
        TZONE_BEG [0…1] String [0/6] - O Time zone for the begin date and time recorded. *112
        ISDD [0…1] String [0/8] - M Actual start: Execution (date). TL will only map dates in this segment from this field. *113
        ISDZ [0…1] String [0/6] - C Actual start: Execution/setup (time). *114
Ship time (QUALF = 006) is required for Amerisource Bergen.
        IEDD [0…1] String [0/8] - O Actual finish: Execution (date). *115
        IEDZ [0…1] String [0/6] - O Actual finish: Execution (time). *116
        TZONE_END [0…1] String [0/6] - C Time zone for the end date and time recorded. *117
Amerisource Bergen requires a time zone for ship time (QUALF = 006). Use this field for the time zone.
      E1EDL28 [0…1] - - - O Routes and transportation information.
        @SEGMENT [1...1] String [1/*] - M Begin of segment attribute. *118
        ROUTE [0…1] String [0/6] - O Route. *119
        VSART [0…1] String [0/2] TransportType O Transport type code. From SAP delivery document, field LIKP-VSART (check table T173). Generic SAP codes supported. *120
      E1EDL47 [0…1] - - - O Delivery carrier's tracking connection data.
        @SEGMENT [1...1] String [1/*] - M Begin of segment attribute. *121
        XSITD [0…1] String [0/10] - O Delivery carrier's ID number. *122
        SHIPACCT [0…1] String [0/20] - O Sender's account number with express delivery carrier company.
        TRACKN [0…1] String [0/35] - O Tracking number for package. *123
      E1EDL24 [1…*] - - - M Delivery Item. Total quantities shipped for saleable units by material number, batch number, and quantity are stored here.
        @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *124
        POSNR [1...1] String [0/6] - M Line item number for the ASN saleable or packing material. Required for TL application. Error will be thrown if line item number in POSNR null or empty. *125
        MATNR [0…1] String [0/18] - O Non-Rx product code for items that are not regulated under the DSCSA. *126
        MATWA [0…1] String [0/18] - O Internal SAP identification number for the original material ordered by customer. Will be different from MATNR if the original item ordered was changed. *127
        ARKTX [0…1] String [0/40] - O Text description of material in line item. *128
        MATKL [0…1] String [0/9] - O Material Group. *129
        WERKS [0…1] String [0/4] - O Plant. *130
        LGORT [0…1] String [0/4] - O Storage Location. *131
        CHARG [1...1] String [0/10] - M Batch or lot number for saleable item in shipment. *132
        KDMAT [0…1] String [0/22] - O Customer material number from customer info record. Stores customer NDC or other code used in Purchase Order for current item.
        LFIMG [1...1] String [0/15] - M Total delivery quantity for saleable material and batch number in the ASN, not the number of items in each inner pack or pack. If the item is a packing material, this is the total number of units of the packing material (number of containers) used in the shipment. *133
        VRKME [0…1] String [0/3] QuantityUOM M Sales unit of measure. This is the ISO unit of measure from SAP. *134
        LGMNG [0…1] String [0/15] - O Actual quantity delivered in stock keeping units. *135
        MEINS [0…1] String [0/3] QuantityUOM C Base Unit of Measure for actual quantity in LGMNG. This is the ISO unit of measure from SAP. *136
Mandatory if LGMNG is populated and greater than 0.
        NTGEW [0…1] String [0/15] - O Net Weight. *137
        BRGEW [0…1] String [0/15] - O Gross Weight. *138
        GEWEI [0…1] String [0/3] WeightUOM C SAP ISO weight unit of measure. *139
Mandatory if NTGEW or BRGEW is populated and greater than 0.
        VOLUM [0…1] String [0/15] - O Volume. *140
        VOLEH [0…1] String [0/3] VolumeUOM C SAP ISO volume unit of measure. *141
Mandatory if VOLUM populated and greater than 0.
        HIPOS [0…1] String [0/6] - O Superior item in an item hierarchy. Points to POSNR value of parent item in hierarchy.

Populated only when the E1EDL24 item is part of a batch split. References the main POSNR value for parent saleable material, i.e. 000010, the finished item that has been assigned one or more batch numbers.

This is null when batch split functionality NOT used.

        HIEVW [0…1] String [0/1] - O Use of Hierarchy Item. When present, identifies nature of hierarchy.

Populated only when the E1EDL24 item is part of a batch split. Identifies E1EDL24 segment item as a batch sub-item in a batch split. Null when batch split functionality NOT used.

Values include:

  • Null or empty = Main item, no hierarchy
  • 1 = Batch sub-item. Batch split in use
  • 2 = BOM sub-item
  • 3 = Product selection
  • 7 = Kit component
        LADGR [0…1] String [0/4] - O Loading Group. *142
        TRAGR [0…1] String [0/4] - O Transportation Group. *143
        VKBUR [0…1] String [0/4] - O Sales Office at item level. *144
        VKGRP [0…1] String [0/3] - O Sales Group. *145
        VTWEG [0…1] String [0/2] - O Distribution Channel. *146
        SPART [0…1] String [0/2] - O Division. *147
        GRKOR [0…1] String [0/3] - O Delivery group (items are delivered together). *148
        EAN11 [0…1] String [0/18] - O International Article Number (EAN/UPC). *149
        POSEX [0…1] String [0/6] - O External item number. *150
        VFDAT [0…1] String [0/8] - O Shelf Life Expiration or Best-Before Date. This data element populated by SAP after goods receipt posts either by entering manually or calculated from a date of production. *151
        ZTLTXNDETAILS [1...1] - - - M Details of product being shipped in ASN as required by DQSA.
          @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *152
          NDC_LOOKUP [0…1] String [0/20] - O Enables master data attributes lookup. This must be the NDC542 code for the saleable item. *153

If this field is populated, do not populate the following fields:

  • CONTAINERSIZE
  • DOSAGEFORM
  • MANUFACTURER
  • NDC
  • NDCFORMAT
  • PRODUCTNAME
  • STRENGTH
          NDCFORMAT [0…1] String [0/6] DQSAProductCode O Qualifier identifying the type format for the NDC number. *154
Do not populate if NDC_LOOKUP is present.
          NDC [0…1] String [0/20] - O National drug code number of the product. *155
Do not populate if NDC_LOOKUP is present.
          GTIN [1...1] String [0/30] - M GTIN-14 identifier for product. *156
Do not populate if NDC_LOOKUP is present.
          PRODUCTNAME [0…1] String [0/40] - O The proprietary or established name or names of the product that would appear on the label. *157
Do not populate if NDC_LOOKUP is present.
          MANUFACTURER [0…1] String [0/40] - O The manufacturer of the product. *158
Do not populate if NDC_LOOKUP is present.
          STRENGTH [0…1] String [0/20] - O The strength or potency of the product, including the unit of measure (e.g. 60 mg, 25 ml). *159
Do not populate if NDC_LOOKUP is present.
          DOSAGEFORM [0…1] String [0/20] - O The dosage form of the product (e.g. TABLET, CAPSULE). *160

Do not populate if NDC_LOOKUP is present.
          CONTAINERSIZE [0…1] String [0/12] - O The number of units contained in a package of the product (e.g. 60, 100). *161
Do not populate if NDC_LOOKUP is present.
          SERIALIZEDLOT [0…1] String [0/1] - O Serialized lot identifier. Set to X if current lot will also include serialized data that will be sent to TraceLink in a separate Serialized Operations Manager or TL XML EPCIS message.

Valid values:

  • Null or empty = No.
  • X = Yes, separate serialized message to be sent.
          ITEM_QUANTITY [1...1] String [1/15] - M Number of saleable units in the lot to represent the Transaction Information "number of containers" that were part of the transaction. *162
          DSCSA_EXEMPT [0…1] String [0/*] - O DSCSAExempt Flag set to TRUE indicates the product does NOT require Transaction History (TH).

If Product does not require TH, the system will include the line item in outbound mapping, but will not create a TH for the product.

If not populated, the system will default to a false value.

Valid values: *163

  • TRUE = Indicates the product does NOT require TH.
  • FALSE = Indicates the product DOES require TH.
          SHIP_TH_ACTION [0…1] String [0/*] - O Indicates whether the system should create a new TH (default behavior if value is not set), or match (pick) against an existing TH in the system for the line item.

This is only needed for the use case when the manufacturer is also a re-distributor of other manufacturer's products, and captured the prior TH directly in the Product Track application. In this use case, the manufacturer needs to identify how the product was sourced so that the outbound TH is populated correctly.

Valid values: * 164

  • CREATE
  • PICK
          PRODUCT_ORIGIN [0…1] String [0/*] ProductOrigin (IDoc) O Identifies how the product was sourced, and is used to determine what fields should appear on the outbound TH based on the sourcing. *165

This is only needed for the use case when the manufacturer is also a re-distributor of other manufacturer's products, and captured the prior TH directly in the Product Track application.

In this use case, the manufacturer needs to identify how the product was sourced so that the outbound TH is populated correctly.

          DIRECT_PURCHASE_FLAG [0…1] String [0/*] - O Direct Purchase statement indicator used to provide Direct Purchase Statement or Received DirectPurchase Statement at line item level, where applicable. *166
          DIRECT_PURCHASE_STATEMENT [1...1] String [1/*] DirectPurchaseStatement O Direct Purchase or Received Direct Purchase Statement. Required if DIRECT_PURCHASE_FLAG populated. *167
  • DIRECT_PURCHASE = Acquired as a Direct Purchase.
  • RECEIVED_DIRECT = Received a Direct Purchase statement.
          DIRECT_PURCHASE_TEXT [0…1] String [0/*] - O Optional text that can be provided by customer that will be used as the action Transaction Statement text. If no content is provided, default text will be used based on the value in DIRECT_PURCHASE_STATEMENT. *168

Default Text:

  • DIRECT_PURCHASE = Product was purchased directly from the manufacturer, manufacturer's exclusive distributor or repackager who purchased directly from a manufacturer.
  • RECEIVED_DIRECT = Received direct purchase statement.
          NON_RX_PRODUCTCODE_TYPE [0…1] String [0/*] NonRxProductCode O Non-Rx product code type, products that are not regulated by the requirements of the DSCSA. Identifies type of product code sent. *169
          NON_RX_PRODUCTCODE [0…1] String [0/*] - O Non-Rx product code identification number value. *170
          LINEITEM_STATUS [0…1] String [0/*] LineItemStatus C Line item status for the shipment. Mapped to SN108 in outbound ASN. *171
Mandatory for Walgreens. Optional for RiteAid.
          ZTL_NON_RX_PRODUCTS [0…*] - - - M Looping group to store one or more non-Rx product codes such as UPC codes.
            @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *172
            QUALF [1...1] String [1/*] NonRxProductCode M Non-Rx product code type, products that are not regulated by the requirements of the DSCSA. Identifies type of product code sent. *173
            PRODUCTCODE [1...1] String [1/*] - M Non-Rx product code identification number value. *174
        ZTLTXNHISTORY [0…*] - - - O Captures prior TH fields (e.g. Transfer from, Transfer to party info, role, transactions, dates, direct purchase statement) if products were previously purchased by the company.

This supports the scenario when a manufacturer chooses to manage initial TH outside of Product Track and communicate it at the time of shipment of the product.

          @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *175
          DELIVERY_NUMBER [0…1] String [0/*] - O Delivery or shipment document number for TH. *176
          DELIVERY_DATE [0…1] String [0/*] - O Delivery/shipment document date in SAP date format YYYYMMDD. *177
          TRANSACTION_DATE [0…1] String [0/*] - O Transaction date in SAP date format YYYYMMDD for header level DQSA transaction information for ASN. *178
          SHIPMENT_DATE [0…1] String [0/*] - O Shipment date in SAP date format YYYYMMDD for header level DQSA transaction information for ASN. *179
          ZTLDSCSA_TRANSFER_PARTY [0…*] - - - M Information about the Transfer From and Transfer To Parties prior to the transaction in the TH.
            @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *180
            TRANSFER_PARTY_TYPE [1...1] String [1/*] TransferPartyType M Identifies business party information in TH transfer party group as either "Transfer From" or "Transfer To" party. *181
            BUSINESS_ROLE [0…1] String [0/*] DSCSABusinessRole O The DSCSA supply chain role of the trading partner in the business transaction. *182

This is only needed for the Transfer From Party.

            BUSINESS_NAME [1...1] String [1/*] - M The business name of the trading partner. *183
            BUSINESS_NAME2 [0…1] String [0/*] - O The business name of the trading partner line 2.
            STREET1 [1...1] String [1/*] - M Street address for the transfer business party. *184
            STREET2 [0…1] String [0/*] - O Street address for the transfer business party line 2. *185
            CITY [1...1] String [1/*] - M City name for transfer business party. *186
            STATE [1...1] String [1/*] - M ISO code for state, territory, or region of transfer party. *187
            POSTAL_CODE [1...1] String [1/*] - M Postal code of transfer party. *188
            COUNTRY [1...1] String [1/*] - M ISO country code for transfer party. *189
            ZTLBUSINESS_PARTY_ID [0…*] - - - M Business party ID type or types for transfer party.
              @SEGMENT [1...1] String [0/*]   M Begin of segment attribute. *190
              BUSINESS_ID_TYPE [1...1] String [1/*] AddressIdQualifier M The type of the BusinessID identifier. *191
              BUSINESS_ID [1...1] String [1/*] - M An identifier qualified by the identifier type in BUSINESS_ID_TYPE associated with the address. *192

This identifies the sending party who is transferring ownership of the product to the receiving party.

        E1EDL25 [0…1] - - - O Delivery Item Descriptions.
          @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *193
          LGORT_BEZ [0…1] String [0/16] - O Description of Storage Location. *194
          LADGR_BEZ [0…1] String [0/20] - O Loading group description. *195
          TRAGR_BEZ [0…1] String [0/20] - O Description of transportation group. *196
          VKBUR_BEZ [0…1] String [0/20] - O Description of sales office. *197
          VKGRP_BEZ [0…1] String [0/20] - O Description of sales group. *198
          VTWEG_BEZ [0…1] String [0/20] - O Description of distribution channel. *199
          SPART_BEZ [0…1] String [0/20] - O Description of division. *200
        E1EDL26 [0…1] - - - O Delivery Item Additional Data.
          @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *201
          PSTYV [0…1] String [0/4] - O Sales document item category. *202
          MATKL [0…1] String [0/9] - O Material Group. *203
          PRODH [0…1] String [0/18] - O Product hierarchy.
          UMVKZ [0…1] String [0/6] - O Numerator (factor) for conversion of sales quantity into SKU. *204
          UMVKN [0…1] String [0/6] - O Denominator (Divisor) for Conversion of Sales Qty into SKU. *205
          KZTLF [0…1] String [0/1] - O Partial delivery at item level.
          UEBTO [0…1] String [0/5] - O Overdelivery Tolerance Limit. *206
          UNTTO [0…1] String [0/5] - O Underdelivery Tolerance Limit. *207
          MAGRV [0…1] String [0/4] - O Material Group: Packaging Materials. *208
          E1EDL27 [0…1] - - - O Delivery Item Additional Data Descriptions.
            @SEGMENT [1...1] String [0/*] - O Begin of segment attribute.
            PSTYV_BEZ [0…1] String [0/20] - O Description of item category.
            MATKL_BEZ [0…1] String [0/20] - O Material Group Description.
            PRODH_BEZ [0…1] String [0/20] - O Description of product hierarchy.
            WERKS_BEZ [0…1] String [0/30] - O Plant Description.
        E1EDL15 [0…1] - - - O Batch characters. Populated when batch split functionality used. Records master data attributes for batch.
          @SEGMENT [1...1] String [0/*] - O Begin of segment attribute.
          ATINN [0…1] String [0/10] - O Internal characteristic identifier.
          ATNAM [0…1] String [0/30] - O Characteristic name.
          ATBEZ [0…1] String [0/30] - O Characteristic description.
          ATWRT [0…1] String [0/30] - O Characteristic value.
          ATWTB [0…1] String [0/30] - O Characteristic value description.
          EWAHR [0…1] String [0/24] - O Tolerance from.
        E1EDL43 [0…*] - - - O Sales document reference for ASN.
          @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *209
          QUALF [1...1] String [0/1] ReferenceDocType M SAP Sales & Distribution system document type qualifier. Identifies type of document used as reference for ASN. *210
          BELNR [1...1] String [0/35] - M SD document number. *211
          POSNR [0…1] String [0/6] - O Document line item number. *212
          DATUM [0…1] String [0/8] - O Document date. *213
        E1EDL41 [0…*] - - - M Reference document for the ordering party: Customer Purchase Order (PO).
          @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *214
          QUALI [1...1] String [0/3] PurchaseOrderReferenceID M Qualifier for ordering party reference document. Valid value: 001. *215
          BSTNR [1...1] String [0/35] - M Customer PO number. *216
          BSTDT [0…1] String [0/8] - M Customer PO date. *217
          BSARK [0…1] String [0/4] - O Customer PO type.
          IHREZ [0…1] String [0/12] - O Your Reference number.
          POSEX [0…1] String [0/6] - O Item Number of the Underlying PO. *218
      E1EDL37 [0…*] - - - O Handling unit header. Packing hierarchy stored in this looping group if entered in Delivery document. Each instance of E1EDL37 describes one level of packing hierarchy, with the child levels in E1EDL44:
  • Pallet --> Child Saleable Items
  • Pallet --> Child Packs
  • Pack --> Child Saleable Items
  • Pack --> Child Inner Packs
  • Inner Packs --> Child Saleable Items

Required to build aggregation hierarchy. Links saleable product batches to packaging items that contain them. Will only be output if pack items (handling unit hierarchy) set up in delivery document.

        @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *219
        EXIDV [1...1] String [0/20] - M External Handling Unit Identification. Expecting SSCC-18 identifier code. *220
        TARAG [0…1] String [0/17] - O Total tare weight for packing unit. *221
        GWEIT [0…1] String [0/3] WeightUOM C SAP ISO weight unit of measure for tare. *222
Mandatory if TARAG is populated and greater than zero.
        BRGEW [0…1] String [0/17] - O Total Weight of Handling Unit. *223
        NTGEW [0…1] String [0/17] - O Loading Weight of Handling Unit. *224
        MAGEW [0…1] String [0/17] - O Allowed Loading Weight of a Handling Unit. *225
        GWEIM [0…1] String [0/3] WeightUOM C SAP ISO weight unit of measure. *226
Mandatory if BRGEW, NTGEW, or MAGEW is populated and greater than zero.
        BTVOL [0…1] String [0/17] - O Total Volume of Handling Unit. *227
        NTVOL [0…1] String [0/17] - O Loading Volume of Handling Unit. *228
        MAVOL [0…1] String [0/17] - O Allowed Loading Volume for Handling Unit. *229
        VOLEM [0…1] String [0/3] VolumeUOM C SAP ISO volume unit of measure. *230
Mandatory if BTVOL, NTVOLM, or MAVOL is populated and greater than zero.
        TAVOL [0…1] String [0/17] - O Tare volume of handling unit. *231
        VOLET [0…1] String [0/3] VolumeUOM C SAP ISO volume unit of measure for tare. *232
Mandatory if TAVOL is populated and greater than zero.
        VHILM [1...1] String [0/18] - O Packaging material number - item ID in sender's SAP material master for packaging item. *233
        VEGR4 [0…1] String [0/5] - O Handling Unit Group 4 (Freely Definable).
        LAENG [0…1] String [0/15] - O Length *234.
        BREIT [0…1] String [0/15] - O Width. *235
        HOEHE [0…1] String [0/15] - O Height. *236
        MEABM [0…1] String [0/3] DimensionUOM C Unit of Dimension for Length/Width/Height. *237
Mandatory if LAENG, BREIT, or HOEHE is populated and greater than zero.
        INHALT [0…1] String [0/40] - O Description of the handling unit content. *238
        VHART [0…1] String [0/4] PackagingLevel M Packaging Material Type. *239
        MAGRV [0…1] String [0/4] - O Material Group: Packaging Materials. *240
        LADLG [0…1] String [0/8] - O Length of loading platform in lgth of LdPlat measurement units. *241
        LADEH [0…1] String [0/3] DimensionUOM O Unit of measure to measure the length of loading platform.
        FARZT [0…1] String [0/4] - O Travel Time. *242
        ENTFE [0…1] String [0/8] - O Distance Traveled. *243
        VELTP [0…1] String [0/1] - O Packaging Material Category. *244
        VEBEZ [0…1] String [0/40] - O Description of Packaging Material. *245
        SMGKN [0…1] String [0/1] - O SMG identification for material tag. *246
        ERNAM [0…1] String [0/12] - O Name of Person who Created the Object. *247
        EXIDA [0…1] String [0/1] - O Type of External Handling Unit Identifier. *248
        MOVE_STATUS [0…1] String [0/4] - O Handling unit status. *249
        PACKVORSCHR [0…1] String [0/22] - O Text String 22 characters.
        PACKVORSCHR_ST [0…1] String [0/1] - O Single-Character Indicator. *250
        ZUL_AUFL [0…1] String [0/17] - O 17-Character Field. *251
        E1EDL49 [0…1] - - - O Delivery carrier's tracking connection data at handling unit level.
          @SEGMENT [1...1] String [1/*] - M Begin of segment attribute. *252
          XSITD [0…1] String [0/10] - O Delivery carrier's ID number. *253
          SHIPACCT [0…1] String [0/20] - O Sender's account number with express delivery carrier company.
          TRACKN [0…1] String [0/35] - O Tracking number for package. *254
        E1EDL44 [1…*] - - - M IDoc: Handling Unit Item (Delivery). The child level items within the packing hierarchy, whether packs, inner packs, or salesable items are stored in this segment if the packing is entered into the delivery document.
          @SEGMENT [1...1] String [0/*] - M Begin of segment attribute. *255
          VELIN [1...1] String [0/1] - O Type of Handling-unit Item Content.

Valid values: *256

  • 1 - Saleable item
  • 2 - Auxiliary packing item
  • 3 - Handling unit (packing item: pack, inner pack, etc.)
          VBELN [0…1] String [0/10] - O Sales and distribution document number. This is the ASN delivery document when the child item described in this segment is a saleable item. *257

If it is a packing item, delivery number will not be present. Not present when child record is for pack, inner pack, or other packaging item.

          POSNR [0…1] String [0/6] - O Item number of the SD document. This is the ASN delivery document line item when the child item described in this segment is a saleable item. *258

Not populated for a packing item.

          EXIDV [0…1] String [0/20] - O External handling unit Identification number. This field is populated when a packing item (pack or inner pack) is the child item in the current aggregation.

This links to the EXIDV field in E1EDL37 where the packing item is the parent in an aggregation (e.g. a pack with child inner packs, or an inner pack with child saleable items).

Expecting SSCC-18 identifier code.

          VEMNG [0…1] String [0/17] - M Number of items in E1EDL37 parent packing item. This is the number of saleable items in an inner pack or pack. Not populated for packaging items. *259

The number of packs or inner packs within a higher level pack in the aggregation is equal to the number of E1EDL44 segments associated with the parent E1EDL37.

          VEMEH [0…1] String [0/3] QuantityUOM M SAP ISO base unit of measure for the packed (aggregated) item quantity. *260
          MATNR [0…1] String [0/18] - O SAP material number for the saleable item in the aggregation. Not populated for packs or inner packs. *261

SAP material number for the pack or inner pack can be found in field VHILM in E1EDL37 where the pack or inner pack is the parent of an aggregation.

          KDMAT [0…1] String [0/35] - O Customer's material number for item. *262
          CHARG [0…1] String [0/10] - O Batch or lot number for saleable item in pack. *263
          WERKS [0…1] String [0/4] - O Plant. *264
          LGORT [0…1] String [0/4] - O Storage Location. *265