1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
856 Mapping Template
X12 Transaction 856
X12 Version 4010
Idoc Type DELVRY02
Extension Type ZLVRY02
Message Type DESADV
Direction to SAP Outbound
Created by Kevin Wilson
System ID SAPP20
Sender Port SAPEDI
Logical System LOGSYS300
Client 300
Partner Number 12345678
Remit To Company X
Order Type ZORD
Sales Org 1000
Dist Channel 10
Division 20
Unit of Measure CS
Language E
Currency USD
Sender ID 0111222333
Sender ID Qual 01
Receiver ID 2223334445
Receiver ID Qual 01
GS02 123
GS03 54321
Comments: Please log all changes to this document in the Change Log worksheet of this, explaining reason for changes.
There is requirement for one purchase order per delivery
SAP configuration must restrict combining of orders on deliveries
BOL number (Mandatory) - Populate BOL Number on Transport relevant screen of delivery
Carrier reference number - Populate the external delivery number on the overview screen of the delivery
SCAC ID code (Mandatory) - Assumed that SCAC is entered into ROUTE field on transport relevant screen on the delivery
Overview Wella Corp. Confidential Page 1
1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
856 Mapping Template
ANSI Detail Idoc Detail
Seg Data Element Name Codes and comments Constant Idoc Segment Field Qual Field Qual Value Notes on Mapping Document
ISA - Interchange Header
ISA01 Authorization Information Qualifier "00" No Authorization information
ISA02 Authorization information Ten Blank Positions
ISA03 Security information Qualifier "00" No Security Information
ISA04 Security information Ten Blank Positions
ISA05 Interchange ID Qualifier 01
ISA06 Interchange Sender ID 0111222333
ISA07 Interchange ID Qualifier 01
ISA08 Intechange Receiver ID 2223334445
ISA09 Interchange Date
ISA10 Interchange Time
ISA11 Interchange Standards Identifier X
ISA12 Interchange version ID 00401
ISA13 Interchange Control Number
ISA14 Acknowledgement Requested 0
ISA15 Test Indicator P
ISA16 Component Element Separator >
GS - Functional Group Header
GS01 Functional ID "SH" Shipping Advice
GS02 Application Senders Code 123
GS03 Application Receiver's Code 54321
GS04 Date
GS05 Time
GS06 Group Control Number
GS07 Responsible agency code X
GS08 Version 4010
ST -Transaction Header
ST01 Transaction Set ID 856
ST02 Transaction Set Control Number
BSN - Beginning segment for ship notice(Mandatory)
01 Transaction Set Purpose Code OO ORI = Original
02 Shipment Identification E1EDL20 VBELN Delivery no.
03 Date System date System date CCYYMMDD - Current system date
04 Time System time System time HHMMSS - Current system time
HL - Hierarchial level - Shipment Level (Mandatory)
01 HL segment sequential number Sequential accumulator HL
Hierarchical ID Number
03 1 Occurrence S = Shipment
Hierarchical Level Code
TD1 - Carrier details - Quantity and W eight (Mandatory)
BOX = Box
BXI = Box with inner cntnr
01 Packaging Code Pallets = PLT Z1HEAD PACK_CODE
CT N = Carton
Boxes = BOX
PLT = Pallet
90 = Standard
02 Lading Quantity Number of Pieces in Shipment E1EDL20 ANZPK Number of pieces relating to TD101
06 W eight qualifier G = Gross weight G
07 W eight E1EDL20 BTGEW
08 UOM KGM = Kilogram KG = Kilogram E1EDL20 GEWEI
LBR = Pounds LB = Pounds
TD5 - Carrier details - Routing sequence / Transit time (Mandatory)
2 = SCAC
02 Identification Code Qualifier 4 = IAT A
2 SCAC Qualifier
92 = Assigned by Buyer
03 Identification Code E1EDL20 ROUTE
A = Air
D = Parcel post
04 Transportation Method/Type Code H = Customer pickup
M
M = Motor (common Carrier)
AE = Air Express
LT = less than trailer load
CC = Shipment complete
CP = Partial shipment, No backorder
06 Shipment / Order status code PD = PO complete CC Shipment status
PR = Partial shipment
SH = Shipped
SJ = Shipped as indicated
TD3 - Carrier details -Equipment
01 Equipment description code Any valid ANSI X12 Code
02 Equipment initial Prefix of unit’s identifying number
03 Equipment number Unit’s identifying number
REF - Shipment Reference number - Carrier reference number
01 Reference Identification Qualifier CN=Carrier Reference # CN
02 Reference Identification E1EDL20 LIFEX
REF - Shipment Reference number - Bill of lading (Mandatory)
01 Reference Identification Qualifier BM = Bill of Lading no. BM
02 Reference Identification E1EDL20 BOLNR
DTM - Date time reference for shipment - Shipped (Mandatory)
01 Date\Time Qualifier 011 = Shipped 011
02 Date E1EDT13 IEDD QUALF 006 Goods issue date
03 Time
DTM - Date time reference for shipment - Current scheduled delivery
01 Date\Time Qualifier 067 = Current scheduled delivery 067
02 Date
03 Time
N1 - Name (Mandatory)
01 Entity Identifier Code SF = Ship from SF
02 Name Location Name of shipment origin E1ADRM1 NAME1 PARTNER_Q OSP Shipping point
N4 - Geographic location (Mandatory)
01 City name E1ADRM1 CITY1 PARTNER_Q OSP City
02 State or province code E1ADRM1 REGION PARTNER_Q OSP State
03 Postal code E1ADRM1 POSTL_COD1 PARTNER_Q OSP ZIP
HL - Hierarchial level - Order Level (Mandatory)
01 HL segment sequential number Sequential accumulator HL
Hierarchical ID Number
03 O = Order O Max 1 occurrence
Hierarchical Level Code
PRF - Purchase Order Reference (Mandatory)
Rite Aid's PO #. This is stored at the line
01 Purchase Order Number Z1HEAD BSTKD item level in segment E1EDL41 but was
included in Z1HEAD for ease of mapping
TD5 - Carrier details - Routing sequence / Transit time (Mandatory)
CC = Shipment complete
CP = Partial shipment, No backorder
06 Shipment / Order status code PD = PO complete CC Order Status
PR = Partial shipment
SH = Shipped
SJ = Shipped as indicated
HL - Hierarchial level - Tare Level
01 Hierarchical ID Number HL segment sequential number Sequential accumulator HL
Tare Level
03 Hierarchical Level Code T = Tare T
MAN - Markings and Numbers
01 Marks and Numbers Qualifier GM UCC-128 Serial shipping container code
02 Marks and Numbers Z1PACK1 EXIDV Corresponding number to MAN01
HL - Hierarchial level - Pack Level
01 Hierarchical ID Number HL segment sequential number Sequential accumulator HL
03 P = Pack
Pack Level
Hierarchical Level Code P
MAN - Markings and Numbers
UC = UPC Shipping Container Code
01 Marks and Numbers Qualifier GM = UCC-128 Serial shipping UC UPC Shipping container code
container code
02 Marks and Numbers Z1ITEM1 EAN11 Corresponding number to MAN01
HL - Hierarchial level - Item Level (Mandatory)
01 HL segment sequential number Sequential accumulator HL
Hierarchical ID Number
03 I = Item I
Hierarchical Level Code
LIN - Item Identification (Mandatory)
02 Product/Service ID Qualifier Preferred qualifer = IN IN Rite Aid's Item Number. Only 1 of these is
required
03 Product/Service ID Z1ITEM1 KDMAT
04 Product/Service ID Qualifier UA UPC/EAN Case Code (2-5-5)
05 Product/Service ID Z1ITEM1 EAN11B
06 Product/Service ID Qualifier UI UPC CPC (1-5-5)
07 Product/Service ID
08 Product/Service ID Qualifier VN Vendor's MFI Number
09 Product/Service ID
10 Product/Service ID Qualifier ND NDC Number
11 Product/Service ID
Package
SN1 - Item Detail (Mandatory)
02 Number of Units Shipped Z1ITEM1 VEMNG
03 Unit or Basis for Measurement Code Each or Case EA or CA Z1ITEM1 VEMEH
04 Quantity shipped to date
05 Quantity ordered
06 UOM Each or Case EA or CA
AC Accepted and Shipped
BP Accepted, Partial, Balance
Item Level
Backordered
IA Item Accepted
IB Item Backordered
IC Item Accepted, Changes Made
ID Item Deleted
IE Item Accepted, Price Pending
IF Item on Hold, Incomplete
08 Line item status code AC
Description
IH Item on Hold
IP Item Accepted, Price Changed
IQ Item Accepted, Quantity Changed
IR Item Rejected
IS Item Accepted, Substitution Made
IW Item on Hold, Waiver Required
R2 Rejected, Invalid Item Product
Number
R3 Rejected, Invalid Unit of Issue
P04 - Item Physical Details
01 Pack Z1ITEM1 UMVKZ
02 Size
03 UOM
04 Inner Pack
PID - Item Description (Mandatory)
01 Description type Free form F
05 Description Z1ITEM1 ARKTX
DTM - Date \ Time Reference
01 Date \ Time Qualifier Expiration date 036
02 Date Z1ITEM1 EXP_DATE
856 Template Page 2
The W ella Corporation Confidential
1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
856 Template Page 3
The W ella Corporation Confidential
1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
856 Template Page 4
The W ella Corporation Confidential
1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
Step Trans Action Considerations
Code
1 VD02 Maintain the customer master data for the ship-to: Output in IDoc field E1ADRE1-EXTEND_D where E1ADRE1-EXTEND_Q =
Enter sold-to customer number. '300' and E1ADRM1-PARTNER_Q = 'WE'
Click on [Sales area data].
On the Sales view, enter the Acct. at Cust. (KNVV-EIKTO) - This value must be returned
to the customer in the N104 field where N101=SE.
2 XK02 Maintain the vendor master data for the carrier (forwarding agent) partner: Output in IDoc field E1ADRE1-EXTEND_D where E1ADRE1-EXTEND_Q =
Select General Data, Control view. '304' and E1ADRM1-PARTNER_Q = 'SP' (external code 'CR')
Enter Reference data - SCAC value.
3 WE20 Create a partner profile for the sold-to partner:
Partner type: KU
Make an Outbound parmtrs. record for Message type 'DESADV' -
1. Outbound Options -
Receiver Port: ??
Syntax check: x
Basic type: DELVRY03
Transfer Immediately: x
2. Message Control -
Application: V2
Message type: Z856
Process Code: ZDEL
4 SPRO Configure an output type for EDI ASNs…. Copy LAVA to Z856
5 VHAR Packaging material types:
Check for values to cross-reference in map
The following are required in the delivery creation process to enable the various
components of the 856:
BOL number (Mandatory) - Populate BOL Number on Transport relevant screen of
delivery
Carrier reference number - Populate the external delivery number on the overview screen
of the delivery
SCAC ID code (Mandatory) - Assumed that SCAC is entered into ROUTE field on
transport relevant screen on the delivery
The expiration date has not been implemented
Config Notes The Wella Corporation Confidential Page 5
1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
Trading Partner Delivery IDoc Number Notes
Company Y 80000075 1223012 (DELVRY02) See Screendump for packing detail
Company Y 80000075 1223013 (DESADV01) See Screendump for packing detail
Company Y 80000075 1226028 Idoc type: DELVRY02, Extension type: ZLVRY02. See
Screendump 1 for packing detail
DEV Testing The Wella Corporation Confidential Page 6
1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
Delivery: 80000075
Materials: PS1003 "E" Containers
PS1040 Pallet
PS1041 UPS Box
Screendump The Wella Corporation Confidential Page 7
1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
Screendump1 The Wella Corporation Confidential Page 8
1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
Date Name Version RevisionNature of Change
Change Log The Wella Corporation Confidential Page 9
1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
Segment Data Element Name Codes and comments Idoc Segment Field Constant Qual Field Qual Value Notes on Mapping Document
ISA - Interchange Header
ISA01 Authorization Information Qualifier "00" No Authorization information
ISA02 Authorization information Ten Blank Positions
ISA03 Security information Qualifier "00" No Security Information
ISA04 Security information Ten Blank Positions
ISA05 Interchange ID Qualifier 01
ISA06 Interchange Sender ID 0111222333
ISA07 Interchange ID Qualifier 01
ISA08 Intechange Receiver ID 2223334445
ISA09 Interchange Date
ISA10 Interchange Time
ISA11 Interchange Standards Identifier X
ISA12 Interchange version ID 00401
ISA13 Interchange Control Number
ISA14 Acknowledgement Requested 0
ISA15 Test Indicator P
ISA16 Component Element Separator >
GS - Functional Group Header
GS01 Functional ID "IN" Invoice
GS02 Application Senders Code 123
GS03 Application Receiver's Code 54321
GS04 Date
GS05 Time
GS06 Group Control Number
GS07 Responsible agency code X
GS08 Version 4010
ST -Transaction Header
ST01 Transaction Set ID 856
ST02 Transaction Set Control Number
BSN
01 E1EDL18 QUALF "00" ORI = Original
02 E1EDL20 VBELN Delivery no.
03 CCYYMMDD - Current system date
04 HHMMSS - Current system time
DTM
01 "011" Shipped
02 E1EDT13 IEDD QUALF "006" CCYYMMDD - Goods Issue final date
HHMMSS - Goods Issue final time
(If no time in IDoc, map must use current system
03 E1EDT13 IEDZ QUALF "006" time)
CT = Central time
ET = Eastern time
GM = Greenwich Mean time
MT = Mountain time
04 "PT" PT = Pacific time
HL
01 Hierarchical ID Number HL segment sequential number
02 Hierarchical Parent ID Number HL01 of parent level
03 Hierarchical Level Code (Max 1 occurrence for CUST X) S = Shipment
04 Hierarchical Child Code Indicates if child exists
TD1
BOX = Box
BXI = Box with inner cntnr Pallets = PLT
CT N = Carton Cartons = CT N
PLT = Pallet Boxes = BOX
01 Packaging Code 90 = Standard E1EDL38 VHART_BEZ Other = 71 Packaging material type descriptions
Ship quantity in PCE - sum of E1EDL24-LGMNG
02 Lading Quantity Z1EDS01 SUMME SUMID 004 (check E1EDL24-MEINS = 'PCE')
06 Weight qualifier G = Gross weight
Sum of E1EDL37-BRGEW. (The gross weight
in E1EDL20-BTGEW does not include packaging
07 Weight qualifier Z1EDS01 SUMME KGM = SUMID 022 material.) Follows E1EDL20
KG = Kilogram Kilogram
08 UOM LB = Pound Z1EDS01 GEWEI LBS = Pounds Weight UoM - take first 2-char of SAP value
TD5
01 Routing Sequence Code O = Origin carrier O
2 = SCAC
4 = IAT A
02 Identification Code Qualifier 92 = Assigned by Buyer 2
ID code - Assumed that SCAC is entered into
03 Identification Code E1ADRE1 EXTEND_D EXTEND_Q 304 SCAC field on carrier vendor master
A = Air
D = Parcel post
H = Customer pickup
M = Motor (common Carrier)
AE = Air Express
04 Transportation Method/Type Code LT = less than trailer load E1EDL28 VSART
05 Routing E1ADRM1 NAME1 PARTNER_Q SP Carrier name
REF
01 Reference Identification Qualifier AW = Air Waybill no. AW
02 Reference Identification E1EDL20 LIFEX May be multiple - comma-separated in IDoc field
REF
01 Reference Identification Qualifier BM = Bill of Lading no. AW
02 Reference Identification E1EDL20 BOLNR
REF
01 Reference Identification Qualifier PK = Packing List no. AW
02 Reference Identification E1EDL20 VBELN SAP delivery no.
N1
01 Entity Identifier Code E1EDKA1 PARVW SE SE = Selling party
02 Name E1ADRM1 NAME1 PARTNER_Q OSO
03 Identification Code Qualifier 92 92 = Assigned by Buyer
E1ADRM1-
PARTNER_Q
= 'AG' and CUST X vendor number (from Acct. at Cust.,
04 Identification Code E1ADRE1 EXTEND_D EXTEND_Q 300 VNVV-EIKTO, on ship-to customer master)
HL
01 Hierarchical ID Number HL segment sequential number
02 Hierarchical Parent ID Number HL01 of parent level
03 Hierarchical Level Code (Max 1 occurrence for CUST X) I = Item
04 Hierarchical Child Code Indicates if child exists
LIN
Custom code reads VBEH with key: scheduling
agreement no. = E1EDL43-BELNR and item no.
= E1EDL43-POSNR (where E1EDL43-
QUALF='E') and delivery date = E1EDL24-
ABRDT. Note that the delivery line item may be
from a sales order instead of a scheduling
agreement - in this case, the PO number would
be found in the E1EDL41-BSTNR field and line
item in E1EDL41-POSEX (where E1EDL41-
01 Assigned Identification Z1SUBITEM POSEX QUALI='001').
02 Product/Service ID Qualifier BP BP = Buyer's part no.
03 Product/Service ID E1EDL24 KDMAT35 mandatory
04 Product/Service ID Qualifier EC EC = Eng. Change level
05 Product/Service ID N/A Optional - not used by UTY
06 Product/Service ID Qualifier VP VP = Vendor's part no.
07 Product/Service ID E1EDL24 MATNR
08 Product/Service ID Qualifier COO Country of Origin
09 Product/Service ID Z1SUBITEM STABE mandatory
SN1
Custom code must combine qtys for all L37 segs
for this item for this country of origin - sum of
02 Number of Units Shipped Z1SUBITEM LFIMG E1EDL44-VEMNG
If not PCE, custom code must calculate correct
03 Unit or Basis for Measurement Code EA = Each E1EDL44 VEMEH PCE or ROL EA qty
PRF
01 Purchase Order Number Z1SUBITEM EBELN See LIN01 - from VBLB-USR01 linked via VBEH
Number assigned by orderer to identify a specific
change or revision to a previous transaction set -
03 Change Order Sequence Number not used
CTT
01 Number of Line Items Z1EDS01 SUMME SUMID 001 Count of ZSUBITEM segs.
Sample Page 10
The W ella Corporation Confidential
1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
Sample Page 11
The W ella Corporation Confidential
1d72231b-8d73-4daa-a9d9-0fedd66558a6.xls
Sample Page 12
The W ella Corporation Confidential