| Data | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Mapping Definitions | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Source | Destination | LEVEL 1 | LEVEL 1 A | LEVEL 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| OV.02.01 - Outbound 856 (E3)(E4) | SAP Idoc: SHPMNT04 | OBOL/MAWB | HAWB/FCR | PO | Valid Values | Nullable? (N or Y or leave blank) |
Field Usage / Remarks | |||||||||||||||||||||||||||||||||||||||||||||||
| Item | Table Name | Field Name | Description | Data Type | Length | Segment | Field Name | Data type | Length | |||||||||||||||||||||||||||||||||||||||||||||
| Header | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| E1EVMTID 856(E3) |
TRXID when TRXCOD = 'HAWBFCR' |
Ocean FCR | CHAR | 20 | E1EDL22: Delivery Header Descriptions | VSBED_BEZ: Description of the shipping conditions | CHAR | 20 | X | Based on the SCEM event, the FM will trigger either the EV3 or EV4 - not both | ||||||||||||||||||||||||||||||||||||||||||||
| E1EVMTID 856(E4) |
TRXID when TRXCOD = 'HAWBFCR' |
Air HAWB | CHAR | 20 | E1EDL22: Delivery Header Descriptions | VKORG_BEZ: Description of sales organization | CHAR | 20 | X | Based on the SCEM event, the FM will trigger either the EV3 or EV4 - not both | ||||||||||||||||||||||||||||||||||||||||||||
(05/17/07) Hardcoded with following text: 'Limited Logistics Services' |
Forwarder | CHAR | 35 | E1TXTH8 : General Text Header, | TDID = '001' TDOBNAME : Name |
CHAR | 70 | X | ||||||||||||||||||||||||||||||||||||||||||||||
| E1EVMREF02 856(E4) |
REFID when REFCOD = 'MAWB' |
Air MAWB | CHAR | 20 | E1EDL20: Delivery header | BOLNR: Bill of lading | CHAR | 35 | X | |||||||||||||||||||||||||||||||||||||||||||||
| \SAPTRX\EH_INFO | SCAC | Ocean Carrier SCAC | CHAR | 4 | E1EDL20: Delivery header | VSTEL: Shipping Point/Receiving Point | CHAR | 4 | X | |||||||||||||||||||||||||||||||||||||||||||||
| \SAPTRX\EH_CNTRL 856(E3) |
OBOL | Ocean OBOL | CHAR | 30 | E1EDL20: Delivery header | BOLNR: Bill of lading | CHAR | 35 | X | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR If not found in IDoc, then get data from /SAPTRX/EH_INFO/ All events |
DOX_RECV_DATE |
Documents Received Date | CHAR | 8 | E1EDT13: Deadline (delivery), Qualf - "003" | IEDD: Actual execution date | DATS | 8 | X | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR If not in IDoc, then get data from /SAPTRX/EH_INFO/ All events |
DOX_RECV_TIME | Documents Received Time | CHAR | 8 | E1EDT13: Deadline (delivery), Qualf - "003" | IEDZ | TIMS | 6 | ||||||||||||||||||||||||||||||||||||||||||||||
| E1EVMHDR02 856(E3)(E4) |
EVTDAT | Actual Departure Date | CHAR | 8 | E1EDT13: Deadline (delivery), Qualf - "001" | IEDD: Actual execution date | DATS | 8 | X | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMHDR02 856(E3)(E4) |
EVTTIM | Actual Departure Time | CHAR | 8 | E1EDT13: Deadline (delivery), Qualf - "001" | IEDZ: Actual finish: Execution (time) | TIMS | 6 | X | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E3)(E4) |
PARAM_VALUE when PARAM_NAME = 'PORT_OF_ENTRY_ETA_DATE' |
ETA Date at Port of Entry | CHAR | 8 | E1EDT13: Deadline (delivery), Qualf - "007" | IEDD: Actual execution date | DATS | 8 | X | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E3)(E4) |
PARAM_VALUE when PARAM_NAME = 'PORT_OF_ENTRY_ETA_TIME' |
ETA Time at Port of Entry | CHAR | 8 | E1EDT13: Deadline (delivery), Qualf - "007" | IEDZ: Actual finish: Execution (time) | TIMS | 6 | X | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E4) |
PARAM_VALUE when PARAM_NAME = 'AIR_CARRIER_NAME |
Air Carrier Name | CHAR | 20 | E1EDL23: Deliv.Header Addit.Data Descriptions | TRAGR_BEZ: Description of transportation group | CHAR | 4 | X | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E4) |
PARAM_VALUE when PARAM_NAME = 'VOYAGE'' |
Air Flight Number | CHAR | 20 | E1EDL23: Deliv.Header Addit.Data Descriptions | KDGRP_BEZ: Description of customer group | CHAR | 10 | X | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E3) |
PARAM_VALUE when PARAM_NAME = 'VESSEL_NAME' |
Ocean Vessel Name | CHAR | 20 | E1EDL23: Deliv.Header Addit.Data Descriptions | TRAGR_BEZ: Description of transportation group | CHAR | 4 | X | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E3) |
PARAM_VALUE when PARAM_NAME = 'VOYAGE' |
Ocean Voyage Number | CHAR | 10 | E1EDL23: Deliv.Header Addit.Data Descriptions | TRSPG_BEZ: Description of reason for shipment block | CHAR | 10 | X | |||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_CNTRL | INCO2 | Port of Lading | CHAR | 8 | E1EDL20: Delivery header | INCO2 | CHAR | 30 | X | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E3) If not found then /SAPTRX/EH_INFO |
PARAM_VALUE
when PARAM_NAME = 'PORT_OF_DISCHARGE_LOC_ID' If not found then PORT_OF_DISCHARGE |
Port of Discharge | CHAR | 5 | E1EDL21: Delivery Header Additional Data | BZIRK: Sales district | CHAR | 3 | X | |||||||||||||||||||||||||||||||||||||||||||||
E1EVMPAR |
FINAL_DEST_LOC_ID |
Place
of Destination UNLOC Code: Destination_City + Destination_Ctry |
CHAR | 5 | E1EDL21: Delivery Header Additional Data | BEROT |
CHAR | 4 | X | The
customer is loking for the UNLOC code associated with the destination city
and country shown on the PO; need to translate the fields identified by SCEM
into the UNLOC code. This is a type of code that we do not use in LBI and it will require a transla |
||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_INFO 856(E3)(E4) |
SHIPMENT_CTNS | Carton Count by HAWB or FCR; need to sum to the HAWB level for the air shipments. | CHAR | 13 | E1EDT43: Shipping Unit Item (Shipment) | VEMNG :Base Quantity Packed in the Handling Unit Item | QUAN | 13 | X+ | |||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_INFO | SHIPMENT_VOL | Ocean Volume | CHAR | 30 | E1EDT37: Shipping unit header | INHALT |
QUAN | 13 | X+ | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E4) |
1st 3-character of MAWB from row #14 | Air Carrier Code | CHAR | 10 | E1EDL47 : Express Delivery Company's Tracking Connection Data | XSITD : Express Delivery Company | CHAR | 10 | X | |||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E3) |
PARAM_VALUE
when PARAM_NAME = 'CONTAINER_SIZE' |
Ocean Container Type | CHAR | 20 | E1EDL47 : Express Delivery Company's Tracking Connection Data | TRACKN:
Tracking number |
CHAR | X | ||||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_CNTRL 856(E3) |
1st
4 character of (PARAM_VALUE) ' |
Ocean Container SCAC | CHAR | 4 | E1EDL47 : Express Delivery Company's Tracking Connection Data | XSISRVC: Express Delivery Company's Service Code | CHAR | 18 | X | aass19832 | aass | |||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_CNTRL 856(E3) |
5th
chracter on (PARAM_VALUE) |
Ocean Container Number | CHAR | 7 | E1EDL47 : Express Delivery Company's Tracking Connection Data | SHIPACCT: Sender's Account Number with Express Delivery Company | CHAR | 20 |
"5th character on" means from 5th character to the end of the field. | X | 19832 | |||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_INFO 856 (E3) (E4) |
SHIPMENT_WGT | Gross Weight by FCR or HAWB; will need to sum all of the ship_projects associated with the cited FCR for the shipment. There will be one FCR per Ship_project | CHAR | 30 | E1EDT37: Shipping unit header | NAMEF | QUAN | 13 | X+ | |||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_INFO 856 (E3) (E4) |
SHIPMENT_WGT_UNIT | Gross Weight Unit of Measure | CHAR | 3 | E1EDL20: Delivery header | GEWEI:Weight Unit | CHAR | 3 | Always specify . Should be a mandatory field | |||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_CNTRL | TRANS_MODE (05/18/07) Use 1st character of TRANS_MODE. E.g. 'O' for Ocean and 'A' for Air. |
Transportation Method/Type Code | CHAR | 2 | E1EDT20 | ROUTE | CHAR | 4 | X | |||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_CNTRL | INCO2 | Place of Acceptance | CHAR | 8 | E1EDL22 : Delivery Header Descriptions | VSTEL_BEZ : Description of shipping point | CHAR | 30 | X | Place of acceptance implies where the goods are received. Place of destination are where the goods are delivered. As we need the latter, I believe that is covered. The “place of acceptance” will be the same as the “port of lading” for the ANF shipments | ||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_INFO | OCEAN_CONTAINER_SEAL | Ocean Container Seal | CHAR | 20 | E1EDT20 | EXTI1 | CHAR | 20 | ||||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E3)(E4) |
PARAM_VALUE when PARAM_NAME = 'PORT_OF_ENTRY_ETA_DATE' This is same as row #19 (Actual = Estimated) |
Actual Arrival Date | DATS | 8 | E1EDT13 Qualf - "006" |
IEDD:
Actual execution date |
Char | 8 | ||||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E3)(E4) |
PARAM_VALUE when PARAM_NAME = 'PORT_OF_ENTRY_ETA_TIME' This is same as row #20 (Actual = Estimated) |
Actual Arrival Time | TIMS | 6 | E1EDT13 Qualf - "006" |
IEDZ:
Actual finish: Execution (time) |
Char | 6 | ||||||||||||||||||||||||||||||||||||||||||||||
| E1EVMPAR 856(E3)(E4) |
PARAM_VALUE when PARAM_NAME = 'PORT_OF_ENTRY_ETA_TZONE |
Actual Arrival Time Zone | CHAR | 6 | E1EDT13 Qualf - "006" |
TZONE_END:
Time Zone |
Char | 6 | ||||||||||||||||||||||||||||||||||||||||||||||
| DETAILS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_INFO (E3)(E4) |
SHIPMENT_CTNS | PO Carton Ct | CHAR | 10 | E1EDL24 | CHARG | Char | 10 | X | |||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_INFO 856(E3) E4) |
SHIPMENT_VOL | PO Volume | CHAR | 10 | E1EDL24 | NTGEW Net weight | QUAN | 13 | X | |||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_INFO 856(E3) (E4) |
SHIPMENT_WGT | PO Weight | CHAR | 10 | E1EDL24 | LIEFFZ Cumulative qty for delivery/MAIS in base unit of measure | QUAN | 13 | X | |||||||||||||||||||||||||||||||||||||||||||||
| n/a | n/a | Vendor Name | CHAR | 20 | E1EDL25 | LADGR_BEZ | Char | 20 | MAST INDUSTRIES, INC.' | X | ||||||||||||||||||||||||||||||||||||||||||||
| ZXPARAM | n/a | Vendor ID: | CHAR | 20 | E1EDL25 | VTWEG_BEZ: Description of distribution channel | Char | 20 | Retrieve
Vendor ID from ZXPARAMS table using 1st character of CPO_NUMBER. ZXPARAMS should have these values: If ‘A’ or ‘K’ then Vendor ID# = ‘55816’ If ‘H’ then Vendor ID# = ‘70061’ If ‘R’ then Vendor ID# = ‘42001’ (05/17/07) Convert to uppercase before |
X | ||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_INFO | Sum of {DELIVERY_QTY} | Item Quantity: Unit quantity associated with the carton quantity for the PO (i.e. 500 cartons said to contain 5000 units). | CHAR | 12 | E1EDL24 : Delivery Item | LFIMG : Actual quantity delivered (in sales units) | QUAN | 13 | X | “Item” is a sub-level to the PO—there can be multiple “items” or “article variants”/SKUs on a PO. In reviewing the IG and the qualifier that the mapping interpreted as “item” (Q1) means “eaches” in the IG. It is the unit quantity associated with the car | ||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_INFO | CPO_NUMBER | CPO Number | CHAR | 20 | E1EDL41 : Reference data ordering party - where Qualf:"001" | BSTNR : Customer purchase order number | CHAR | 35 | X | |||||||||||||||||||||||||||||||||||||||||||||
| VBAK (R/3) | ZZ_CUSTREVLVL | CPO Revision: This is the order revision number from the ANF PO (850) to reference a change to the order | CHAR | 30 | E1EDL41 : Reference data ordering party | IHREZ: Customer's or vendor's internal reference | CHAR | 35 | Use Search Help VMVAA 'Sales document according to customer PO number' and CPO_NUMBER to get to the sales order number in VBAK. | X | ||||||||||||||||||||||||||||||||||||||||||||
| /SAPTRX/EH_CNTRL | ORIGIN_CTRY | Country of Origin | CHAR | 2 | E1EDL35 : Export Data Delivery Item | HERKL : Country of origin of the article | CHAR | 3 | X | |||||||||||||||||||||||||||||||||||||||||||||
| EDIDC | ARCKEY | EDI Archive Key | CHAR | 70 | EDIDC | ARCKEY | CHAR | 70 | X | |||||||||||||||||||||||||||||||||||||||||||||