Data Mapping Worksheet                                  
                                   
Mapping Definitions   (copy an existing row to permit recording your mappings)                              
  Source   Destination                
  OV.02.05 - Outbound 315         SAP IDoc SHPMNT04   Sourcing Condition[1]       Valid Values[2] Nullable?
(N or Y or leave blank)[3]		 Field Usage / Remarks[4]  
Item Table Name Field Name Description Data Type Length   Table Name  (IDoc Segement) Field Name Business Rule Logic / Conversion Logic / Default        
                                   
1 E1EVMHDR02 EVTID
GIS translate from SCEM text to 2-digit ID		 MAST Status Codes to ANF CHAR 3   E1EDT20 TPBEZ  (Char 20) External identification 2                 
2 E1EVMHDR02 EVTDAT MAST Status Codes to ANF Event date Char 8   E1EDT13: Deadline (delivery), Qualf - "001" IEDD Actual finish: Execution (date)                 
3 E1EVMHDR02 EVTTIM MAST Status Codes to ANF
Event occurred time		 Char 6   E1EDT13: Deadline (delivery), Qualf - "001" IEDZ Actual finish: Execution (time)                 
4 /SAPTRX/EH_CNTRL 1st 4 character of CONTAINER_NUMBER Ocean Container Standard carrier Alpha code CHAR 4   E1EDT20 SIGNI (20) Container ID                
5 /SAPTRX/EH_CNTRL 5th character on of
CONTAINER_NUMBER		 Container Number CHAR 7   E1EDT20 EXTI1 (20) Container ID                
7 /SAPTRX/EH_CNTRL OBOL Ocean OBOL CHAR 30   E1EDL20: Delivery header  BOLNR: Bill of lading (CHAR 35) Ocean OBOL                
8 /SAPTRX/EH_INFO   OCEAN_CONTAINER_SEAL Ocean Container Seal CHAR 20   E1EDT20 EXTI2 (Char 20) External identification 1                 
9 /SAPTRX/EH_INFO SHIPMENT_CTNS Carton Count[7] CHAR 13   E1EDT43 VEMNG (quan 13) Shipment carton count                
10 /SAPTRX/EH_INFO SHIPMENT_WGT (Jerry Lin 04/24/07) Shipment Weight CHAR 15   E1EDT37 BRGEW : Gross weight (QUAN 13) Total Weight of Handling Unit    No need to perform conversion.  UOM will always be in 'KG'.            
11 /SAPTRX/EH_INFO SHIPMENT_WGT_UNIT
 Gross Weight Unit of Measure CHAR 3   E1EDT37 GWEIM Always specify . Should be a mandatory field. THIS FIELD SHOULD ALWAYS BE "G"   (Jerry Lin 02/26/07) Renamed on outpud IDoc.
(Jerry Lin 04/24/07) UOM will always be in 'KG'.
            
12 /SAPTRX/EH_INFO VOYAGE Ocean Voyage Number CHAR 20   E1EDL23: Deliv.Header Addit.Data Descriptions TRSPG_BEZ: Description of reason for shipment block (char 30) Ocean Voyage Number                
13 /SAPTRX/EH_CNTRL VESSEL_NAME Ocean Vessel Name CHAR 20   E1EDL23: Deliv.Header Addit.Data Descriptions(char 20) TRAGR_BEZ: Description of transportation group Ocean Vessel Name                
14 /SAPTRX/EH_INFO/ SHIPMENT_VOL (Jerry Lin 04/24/07) Ocean Volume CHAR 15   E1EDT37 BTVOL (QUAN 15) Description of Handling Unit Content    No need to perform conversion.  Unit of measure will always be in CBM.            
15 /SAPTRX/EH_CNTRL INCO2 Port of Lading CHAR 8   E1EDL20: Delivery header  INCO2 Port of Lading                
16 n/a Based on the Code from Port of Lading, GIS will be required to do the name assignment. NO ACTION REQUIRED FOR THIS FIELD. Port of Lading Name: Based on container_status.port_of_lading_code. char  20       External Identification  THIS FIELD IS NOT POPULATED. GIS will use the port code (E1EDL20-INCO2) and translate to the Port name using the UNLOC table. 

GIS will use the port code and translate to the Port name using the UNLOC table. 

           
17 /SAPTRX/EH_EXPEV Position 2-9 of (EVENT_DATE)

When EVENT_CODE='OCEAN_DEP
and EVENT_STATUS = 'R'		 Port of Lading Actual Departure Date CHAR 8   E1EDT13: Deadline (delivery), Qualf - "013" IEDD: Actual execution date (date 8) Actual Start Execution (Date)                
18 /SAPTRX/EH_EXPEV Position 10-15 of (EVENT_DATE)

When EVENT_CODE='OCEAN_DEP
and EVENT_STATUS = 'R'		 Port of Lading Actual Departure Time Char 8   E1EDT13: Deadline (delivery), Qualf - "013" IEDZ Actual finish: Execution (time)                 
19 /SAPTRX/EH_EXPEV EVENT_TZONE

When EVENT_CODE='OCEAN_DEP
and EVENT_STATUS = 'R'		 Port of Lading Actual Departure Time Zone Char 6   E1EDT13: Deadline (delivery), Qualf - "013" TZONE_END Time Zone                 
20 /SAPTRX/EH_CNTRL  PORT_OF_DISCHARGE_LOC_ID Based on container_status.port_of_final_discharge_code. CHAR 5   E1EDL21: Delivery Header Additional Data (char 6) BZIRK: Sales district Description of shipping point                 
22 n/a Based on the Code from Port of Discharge, GIS will be required to do the name assignment. NO ACTION REQUIRED FOR THIS FIELD. Port_of_Discharge_Name Based on container_status.port_of_final_discharge_code. char 20       Loading point description  THIS FIELD IS NOT POPULATED. GIS will use the port code (E1EDL21-BZIRK) and translate to the Port name using the UNLOC table.                
23 /SAPTRX/EH_INFO PORT_OF_DISCHARGE_ETA_DATE Port of Discharge ETA Date CHAR 8   E1EDT13: Deadline (delivery), Qualf - "007" (date 8) IEDD: Actual execution date Earliest Delivery Date                 
24 /SAPTRX/EH_INFO PORT_OF_DISCHARGE_ETA_TIME Port of Discharge ETA Time Char 6   E1EDT13: Deadline (delivery), Qualf - "007" IEDZ Actual finish: Execution (time)                 
25 /SAPTRX/EH_CNTRL  FINAL_DEST_LOC_ID Based on container_status.port_of_delivery_code. char 4   E1EDT47 ADD01 (char 10) Site Descript                
27 n/a Based on the Code from Port of Delivery, GIS will be required to do the name assignment. NO ACTION REQUIRED FOR THIS FIELD. Port_of_Delivery_Name Based on container_status.port_of_delivery_code. char 20       Description of storage location  THIS FIELD IS NOT POPULATED. GIS will use the port code (E1EDT47-ADD01) and translate to the Port name using the UNLOC table. 

             
28 /SAPTRX/EH_INFO FINAL_DEST_ETA_DATE Port of Delivery Date[8] CHAR 8   E1EDT13: Deadline (delivery), Qualf - "003" (date 8) IEDD: Actual execution date Latest Delivery Date                 
29 /SAPTRX/EH_INFO FINAL_DEST_ETA_TIME Port of Delivery Time Char 6   E1EDT13: Deadline (delivery), Qualf - "003" IEDZ Actual finish: Execution (time)                 
30 E1EVMLID LOCID1  UN Location Code:
(UN country + UN city)  which pertains to the specific shipment status code		 UN location code for the event 4   E1EDT10 VORNR (4)  Activity Number  GIS will use the port code (E1EDT10-VORNR) and translate to the Port name using the UNLOC table.             The “location UN Code” will require a transaction of the port code sent to identify where the action is taking place.  The action is the status that is being sent in the EDI transaction.   
31  E1EVMPAR PARM_VALUE
when PARAM_NAME = 'INBOND_NUMBER'		 In Bond Number CHAR  20   E1EDT10 VSTGA_BEZ (Char 20) Description                 
32 EDIDC  ARCKEY EDI Archive Key CHAR 70   EDIDC  ARCKEY CHAR 70              
                                   
[1]
Aaron Rorstrom:
"Required" if applicable
Record the condition, if any, in which the source will upate the destination.
[2]
Aaron Rorstrom:
"Required" if applicable
Record the list of acceptable values or a document that specifies the accaptable values.
[3]
Aaron Rorstrom:
"Required" if applicable
[4]
Aaron Rorstrom:
"Optional"
[5]
Aaron Rorstrom:
This row is an example.
[6]
LTS User:
Per Issue Log, I fixed the Segment Typo and Field.
[7]
Registered User:
QNTY CAN BE DIFFERENT THAT THE CORRESPONDING PO
[8]
ETA to termination point.