o856v4010 template
TRANSCRIPT
document.xls
Overview Wella Corp. Confidential Page 1
856 Mapping Template
X12 Transaction 856X12 Version 4010Idoc Type DELVRY02Extension Type ZLVRY02Message Type DESADVDirection to SAP OutboundCreated by Kevin WilsonSystem ID SAPP20Sender Port SAPEDILogical System LOGSYS300Client 300
Partner Number 12345678
Remit To Company X
Order Type ZORDSales Org 1000Dist 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 deliverySAP configuration must restrict combining of orders on deliveries
BOL number (Mandatory) - Populate BOL Number on Transport relevant screen of deliveryCarrier reference number - Populate the external delivery number on the overview screen of the deliverySCAC ID code (Mandatory) - Assumed that SCAC is entered into ROUTE field on transport relevant screen on the delivery
document.xls
856 Template The Wella Corporation Confidential Page 2
ANSI Detail Idoc DetailSeg Data Element Name Codes and comments Constant Idoc Segment Field Qual Field Qual Value Notes on Mapping Document
ISA - Interchange HeaderISA01 Authorization Information Qualifier "00" No Authorization informationISA02 Authorization information Ten Blank PositionsISA03 Security information Qualifier "00" No Security InformationISA04 Security information Ten Blank PositionsISA05 Interchange ID Qualifier 01ISA06 Interchange Sender ID 0111222333ISA07 Interchange ID Qualifier 01ISA08 Intechange Receiver ID 2223334445ISA09 Interchange DateISA10 Interchange TimeISA11 Interchange Standards Identifier XISA12 Interchange version ID 00401ISA13 Interchange Control NumberISA14 Acknowledgement Requested 0ISA15 Test Indicator PISA16 Component Element Separator >
GS - Functional Group HeaderGS01 Functional ID "SH" Shipping AdviceGS02 Application Senders Code 123GS03 Application Receiver's Code 54321GS04 DateGS05 TimeGS06 Group Control NumberGS07 Responsible agency code XGS08 Version 4010
ST -Transaction HeaderST01 Transaction Set ID 856ST02 Transaction Set Control Number
BSN - Beginning segment for ship notice(Mandatory)01 Transaction Set Purpose Code OO ORI = Original02 Shipment Identification E1EDL20 VBELN Delivery no.03 Date System date System date CCYYMMDD - Current system date04 Time System time System time HHMMSS - Current system time
HL - Hierarchial level - Shipment Level (Mandatory)01 Hierarchical ID Number HL segment sequential number Sequential accumulator HL03 Hierarchical Level Code 1 Occurrence S = Shipment
TD1 - Carrier details - Quantity and Weight (Mandatory)
01 Packaging Code Z1HEAD PACK_CODE
02 Lading Quantity Number of Pieces in Shipment E1EDL20 ANZPK Number of pieces relating to TD10106 Weight qualifier G = Gross weight G
07 Weight E1EDL20 BTGEW
08 UOM E1EDL20 GEWEI
TD5 - Carrier details - Routing sequence / Transit time (Mandatory)
02 Identification Code Qualifier 2 SCAC Qualifier
BOX = BoxBXI = Box with inner cntnrCTN = CartonPLT = Pallet90 = Standard
Pallets = PLTBoxes = BOX
KGM = KilogramLBR = Pounds
KG = KilogramLB = Pounds
2 = SCAC4 = IATA92 = Assigned by Buyer
document.xls
856 Template The Wella Corporation Confidential Page 3
Seg Data Element Name Codes and comments Constant Idoc Segment Field Qual Field Qual Value Notes on Mapping Document
03 Identification Code E1EDL20 ROUTE
04 Transportation Method/Type Code M
06 Shipment / Order status code CC Shipment status
TD3 - Carrier details -Equipment01 Equipment description code Any valid ANSI X12 Code02 Equipment initial Prefix of unit’s identifying number03 Equipment number Unit’s identifying number
REF - Shipment Reference number - Carrier reference number01 Reference Identification Qualifier CN=Carrier Reference # CN02 Reference Identification E1EDL20 LIFEX
REF - Shipment Reference number - Bill of lading (Mandatory)01 Reference Identification Qualifier BM = Bill of Lading no. BM02 Reference Identification E1EDL20 BOLNR
DTM - Date time reference for shipment - Shipped (Mandatory)01 Date\Time Qualifier 011 = Shipped 01102 Date E1EDT13 IEDD QUALF 006 Goods issue date03 Time
DTM - Date time reference for shipment - Current scheduled delivery01 Date\Time Qualifier 067 = Current scheduled delivery 06702 Date03 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 City02 State or province code E1ADRM1 REGION PARTNER_Q OSP State03 Postal code E1ADRM1 POSTL_COD1 PARTNER_Q OSP ZIP
HL - Hierarchial level - Order Level (Mandatory)01 Hierarchical ID Number HL segment sequential number Sequential accumulator HL03 Hierarchical Level Code O = Order O Max 1 occurrence
PRF - Purchase Order Reference (Mandatory)
01 Purchase Order Number Z1HEAD BSTKD
TD5 - Carrier details - Routing sequence / Transit time (Mandatory)
A = AirD = Parcel postH = Customer pickupM = Motor (common Carrier)AE = Air ExpressLT = less than trailer load
CC = Shipment completeCP = Partial shipment, No backorderPD = PO completePR = Partial shipmentSH = ShippedSJ = Shipped as indicated
Rite Aid's PO #. This is stored at the line item level in segment E1EDL41 but was included in Z1HEAD for ease of mapping
document.xls
856 Template The Wella Corporation Confidential Page 4
Seg Data Element Name Codes and comments Constant Idoc Segment Field Qual Field Qual Value Notes on Mapping Document
06 Shipment / Order status code CC Order StatusP
acka
ge
Tar
e Le
vel
HL - Hierarchial level - Tare Level01 Hierarchical ID Number HL segment sequential number Sequential accumulator HL03 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
Pac
k Le
vel
HL - Hierarchial level - Pack Level01 Hierarchical ID Number HL segment sequential number Sequential accumulator HL03 Hierarchical Level Code P = Pack P
MAN - Markings and Numbers
01 Marks and Numbers Qualifier UC UPC Shipping container code
02 Marks and Numbers Z1ITEM1 EAN11 Corresponding number to MAN01
Item
Lev
el
HL - Hierarchial level - Item Level (Mandatory)01 Hierarchical ID Number HL segment sequential number Sequential accumulator HL03 Hierarchical Level Code I = Item I
LIN - Item Identification (Mandatory)
02 Product/Service ID Qualifier Preferred qualifer = IN IN
03 Product/Service ID Z1ITEM1 KDMAT04 Product/Service ID Qualifier UA UPC/EAN Case Code (2-5-5)05 Product/Service ID Z1ITEM1 EAN11B06 Product/Service ID Qualifier UI UPC CPC (1-5-5)07 Product/Service ID08 Product/Service ID Qualifier VN Vendor's MFI Number09 Product/Service ID10 Product/Service ID Qualifier ND NDC Number11 Product/Service ID
SN1 - Item Detail (Mandatory)02 Number of Units Shipped Z1ITEM1 VEMNG03 Unit or Basis for Measurement Code Each or Case EA or CA Z1ITEM1 VEMEH04 Quantity shipped to date05 Quantity ordered06 UOM Each or Case EA or CA
CC = Shipment completeCP = Partial shipment, No backorderPD = PO completePR = Partial shipmentSH = ShippedSJ = Shipped as indicated
UC = UPC Shipping Container CodeGM = UCC-128 Serial shipping container code
Rite Aid's Item Number. Only 1 of these is required
document.xls
856 Template The Wella Corporation Confidential Page 5
Seg Data Element Name Codes and comments Constant Idoc Segment Field Qual Field Qual Value Notes on Mapping Document
Pac
kage
Item
Lev
el
08 Line item status code AC
P04 - Item Physical Details01 Pack Z1ITEM1 UMVKZ02 Size03 UOM04 Inner Pack
PID - Item Description (Mandatory)01 Description type Free form F05 Description Z1ITEM1 ARKTX
DTM - Date \ Time Reference01 Date \ Time Qualifier Expiration date 03602 Date Z1ITEM1 EXP_DATE
AC Accepted and ShippedBP Accepted, Partial, Balance BackorderedIA Item AcceptedIB Item BackorderedIC Item Accepted, Changes MadeID Item DeletedIE Item Accepted, Price PendingIF Item on Hold, Incomplete DescriptionIH Item on HoldIP Item Accepted, Price ChangedIQ Item Accepted, Quantity ChangedIR Item RejectedIS Item Accepted, Substitution MadeIW Item on Hold, Waiver RequiredR2 Rejected, Invalid Item Product NumberR3 Rejected, Invalid Unit of Issue
document.xls
Config Notes The Wella Corporation Confidential Page 6
Step Action Considerations
1 VD02
2 XK02
3 WE20
4 SPRO Configure an output type for EDI ASNs…. Copy LAVA to Z8565 VHAR
BOL number (Mandatory) - Populate BOL Number on Transport relevant screen of delivery
The expiration date has not been implemented
TransCode
Maintain the customer master data for the ship-to:Enter sold-to customer number.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.
Output in IDoc field E1ADRE1-EXTEND_D where E1ADRE1-EXTEND_Q = '300' and E1ADRM1-PARTNER_Q = 'WE'
Maintain the vendor master data for the carrier (forwarding agent) partner:Select General Data, Control view.Enter Reference data - SCAC value.
Output in IDoc field E1ADRE1-EXTEND_D where E1ADRE1-EXTEND_Q = '304' and E1ADRM1-PARTNER_Q = 'SP' (external code 'CR')
Create a partner profile for the sold-to partner:Partner type: KUMake 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
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:
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
document.xls
DEV Testing The Wella Corporation Confidential Page 7
Trading Partner Delivery IDoc Number Notes
Company Y 80000075 1223012 (DELVRY02) See Screendump for packing detailCompany Y 80000075 1223013 (DESADV01) See Screendump for packing detailCompany Y 80000075 1226028
Idoc type: DELVRY02, Extension type: ZLVRY02. See Screendump 1 for packing detail
document.xls
Screendump The Wella Corporation Confidential Page 8
Delivery: 80000075
Materials: PS1003 "E" ContainersPS1040 PalletPS1041 UPS Box
document.xls
Screendump1 The Wella Corporation Confidential Page 9
document.xls
Change Log The Wella Corporation Confidential Page 10
Date Name Version RevisionNature of Change
document.xls
Sample The Wella Corporation Confidential Page 11
Segment Data Element Name Codes and comments Idoc Segment Field Constant Qual Field Qual Value Notes on Mapping DocumentISA - Interchange HeaderISA01 Authorization Information Qualifier "00" No Authorization informationISA02 Authorization information Ten Blank PositionsISA03 Security information Qualifier "00" No Security InformationISA04 Security information Ten Blank PositionsISA05 Interchange ID Qualifier 01ISA06 Interchange Sender ID 0111222333ISA07 Interchange ID Qualifier 01ISA08 Intechange Receiver ID 2223334445ISA09 Interchange DateISA10 Interchange TimeISA11 Interchange Standards Identifier XISA12 Interchange version ID 00401ISA13 Interchange Control NumberISA14 Acknowledgement Requested 0ISA15 Test Indicator PISA16 Component Element Separator >
GS - Functional Group HeaderGS01 Functional ID "IN" InvoiceGS02 Application Senders Code 123GS03 Application Receiver's Code 54321GS04 DateGS05 TimeGS06 Group Control NumberGS07 Responsible agency code XGS08 Version 4010
ST -Transaction HeaderST01 Transaction Set ID 856ST02 Transaction Set Control Number
BSN01 E1EDL18 QUALF "00" ORI = Original02 E1EDL20 VBELN Delivery no.03 CCYYMMDD - Current system date04 HHMMSS - Current system time
DTM01 "011" Shipped02 E1EDT13 IEDD QUALF "006" CCYYMMDD - Goods Issue final date
03 E1EDT13 IEDZ QUALF "006"
04 "PT"
HL01 Hierarchical ID Number HL segment sequential number
02 Hierarchical Parent ID Number HL01 of parent level03 Hierarchical Level Code (Max 1 occurrence for CUST X) S = Shipment04 Hierarchical Child Code Indicates if child exists
TD1
HHMMSS - Goods Issue final time (If no time in IDoc, map must use current system time)
CT = Central timeET = Eastern timeGM = Greenwich Mean timeMT = Mountain timePT = Pacific time
document.xls
Sample The Wella Corporation Confidential Page 12
01 Packaging Code E1EDL38 VHART_BEZ Packaging material type descriptions
02 Lading Quantity Z1EDS01 SUMME SUMID 00406 Weight qualifier G = Gross weight
07 Weight qualifier Z1EDS01 SUMME SUMID 022
08 UOM Z1EDS01 GEWEI Weight UoM - take first 2-char of SAP value
TD501 Routing Sequence Code O = Origin carrier O
02 Identification Code Qualifier 2
03 Identification Code E1ADRE1 EXTEND_D EXTEND_Q 304
04 Transportation Method/Type Code E1EDL28 VSART05 Routing E1ADRM1 NAME1 PARTNER_Q SP Carrier name
REF01 Reference Identification Qualifier AW = Air Waybill no. AW
02 Reference Identification E1EDL20 LIFEX
REF01 Reference Identification Qualifier BM = Bill of Lading no. AW02 Reference Identification E1EDL20 BOLNR
REF01 Reference Identification Qualifier PK = Packing List no. AW02 Reference Identification E1EDL20 VBELN SAP delivery no.
N101 Entity Identifier Code E1EDKA1 PARVW SE SE = Selling party02 Name E1ADRM1 NAME1 PARTNER_Q OSO03 Identification Code Qualifier 92 92 = Assigned by Buyer
04 Identification Code E1ADRE1 EXTEND_D 300
HL01 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 = Item04 Hierarchical Child Code Indicates if child exists
LIN
BOX = BoxBXI = Box with inner cntnrCTN = CartonPLT = Pallet90 = Standard
Pallets = PLTCartons = CTNBoxes = BOXOther = 71
Ship quantity in PCE - sum of E1EDL24-LGMNG (check E1EDL24-MEINS = 'PCE')
Sum of E1EDL37-BRGEW. (The gross weight in E1EDL20-BTGEW does not include packaging material.) Follows E1EDL20
KG = KilogramLB = Pound
KGM = KilogramLBS = Pounds
2 = SCAC4 = IATA92 = Assigned by Buyer
ID code - Assumed that SCAC is entered into SCAC field on carrier vendor master
A = AirD = Parcel postH = Customer pickupM = Motor (common Carrier)AE = Air ExpressLT = less than trailer load
May be multiple - comma-separated in IDoc field
E1ADRM1-PARTNER_Q = 'AG' andEXTEND_Q
CUST X vendor number (from Acct. at Cust., VNVV-EIKTO, on ship-to customer master)
document.xls
Sample The Wella Corporation Confidential Page 13
01 Assigned Identification Z1SUBITEM POSEX02 Product/Service ID Qualifier BP BP = Buyer's part no.03 Product/Service ID E1EDL24 KDMAT35 mandatory04 Product/Service ID Qualifier EC EC = Eng. Change level05 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 Origin09 Product/Service ID Z1SUBITEM STABE mandatory
SN1
02 Number of Units Shipped Z1SUBITEM LFIMG
03 Unit or Basis for Measurement Code EA = Each E1EDL44 VEMEH PCE or ROL
PRF
01 Purchase Order Number Z1SUBITEM EBELN
03 Change Order Sequence Number
CTT01 Number of Line Items Z1EDS01 SUMME SUMID 001 Count of ZSUBITEM segs.
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-QUALI='001').
Custom code must combine qtys for all L37 segs for this item for this country of origin - sum of E1EDL44-VEMNG
If not PCE, custom code must calculate correct EA qty
See LIN01 - from VBLB-USR01 linked via VBEH
Number assigned by orderer to identify a specific change or revision to a previous transaction set - not used