Data Mapping Worksheet (EDI 315 -> SCEM IDOC EVMSTA02)                      
Data mapping for LPE 08 02 D1_FSPEC_SCEM 07_EDI315_International Functional Specification For Status Details (Ocean)                              
General Requirements                              
Filteration Criteria: Generate an IDOC only when the following conditions are met:   Only transactions with an importer of record code (IC) of “BBW, BTA, MII, MST, MFE, and/or MNV should create an iDoc.  It is only in situations where no MAST or personal   
IDOC Level: One IDOC should be generated for a combination of Container number (Concatenation of B407 and B408 in EDI 315), OBOL Number(N902 when N901 = "BM" in EDI 315) and Status(B403 in EDI 315)  
All fields in this mapping that are marked in quotes (" ") should be considered as hardcoded   
• Only transactions with an importer of record code (IC) of “BBW, BTA, MII, MST, MFE, and/or MNV should create an iDoc.  It is only in situations where no MAST or personal care is loaded into the container should there be no iDoc created.    
The Idoc should be generated only when Shipment status code is either of "AM" or "RL" or "AR" or "AL" or "OA" or "VA" or "UV" or "D", or "ZZ". Do not generate an Idoc for status codes "CT"; "VD"; "AE" or "E" or "K"  
Data Mapping                              
Source:EDI X12(315V4010)             Target IDOC:EVMSTA02                
EDI SEG Seg.ID Element Req.Des. Data Type Length Desc IDOC Segment Name Row No Field Name Field Descripition Value Data Type Data Format # of Char Mapping Logic
              [Data Concept] Header Table                
              E1EDIDC 1 RCVSAD SADR Recipient =ISA07 CHAR 9 R  
              E1EDIDC 2 STDMES Message Type =ST01 CHAR 3 R  
              E1EDIDC 3 SNDSAD SADR Sender =ISA06 CHAR 9 R  
              E1EDIDC 4 REFINT Interchange File =ISA12 NUM 9 R  
              E1EDIDC 5 REFGRP Message Group =GS06 NUM 9 R  
              E1EDIDC 6 REFMES Reference Message =ST02 CHAR 9 R  
B4 020 B403 O ID 2 Shipment Status Code E1EVMHDR02 1 EVTID Event Code ID Mapped (see Logic) CHAR   50 if Shipment status code (B403) = "AL" (Loaded on Rail), then EVTID = "LOADED_RAIL";
If Shipment status code (B403) = "AM", then EVTID = "LOADED_TRUCK";
if Shipement status code (B403) = "AR", then EVTID = "RAIL_ARRIVAL";`
if Shipment status code (B403) = 
HARD CODED VALUE BASED ON LOGIC           E1EVMHDR02 1 SRCTX Event Reason text   CHAR   100 if Shipment status code (B403) = "AR", then SRCTX = "RAIL ARRIVAL AT INTERMODAL RAMP";
if Shipmnt stauts code (B403) = "D", then SRCTX = "DELIVERED TO FINAL DESTINATION"                                                           If V901 = "ZZZ", then SRCTX
B4 020 B404 O date 8 Date E1EVMHDR02 1 EVTDAT Event Date Mapped (see Logic) DATE CCYYMMDD 8 Date when this event happened; = B404
B4 020 B405 O TM 4 Time E1EVMHDR02 1 EVTTIM Event Time Mapped (see Logic) TIME HHMMSS 6 Time when this event happened; = B405
MAPPED BASED ON LOGIC (see logic)             E1EVMHDR02 1 EVTZON Event Time Zone Mapped (see Logic) CHAR   6 Time zone when the event happened. EDI Translator will calculate based on the Status Location and pass the timezone to SAP EM IDOC EVMSTA02. Use the Status Location: B406 to to look the timezone in GIS/XI Table 
System date             E1EVMHDR02 1 REPDAT Reporting Date Mapped (see Logic) DATE CCYYMMDD 8 Date when the EDI message was received by the receiving system
System time             E1EVMHDR02 1 REPTIM Reporting Time Mapped (see Logic) TIME HHMMSS 6 Time when the EDI message was received by the receiving system
Hardcoded value             E1EVMHDR02 1 REPZON Reporting Time Zone Mapped (see Logic) CHAR   6 Time zone of the receiving system
              [Data Concept] Tracking IDs                
Hard coded value             E1EVMTID 1 TRXCOD Tracking ID Code Set Hard coded = "OBOL_CNTR" CHAR   20  
N902 (when N901='BM') + B407 + B408              E1EVMTID 1 TRXID Tracking ID Mapped (see Logic) CHAR   50 OBOL Number (N902 when N901 = "BM" in EDI 315) + Container Number (B407 + B408 in EDI 315) [Concatenation of OBOL # , Equipment Initial and Equipment #]
              [Data Concept] Location Codes                
Hardcoded value             E1EVMLID 1 LOCCOD Location code set "LCNR" CHAR   20  
B4 020 B406 X String 30 Status Location E1EVMLID 1 LOCID1 Location Code ID - 1 Location Identifier CHAR   50 Location id of the location where event happened = B406. Assumption - this field will be the same as the Location id available in Manu.
B4 020 B411 X String 30 Location Identifier E1ADRM3 1 CITY1 City Mapped (see Logic) CHAR   40 City where the Event Happened = B411
                   
N902  (when N901 = "SCA") Mapped based on Logic   N902 X AN 30 Interline Carrier ID E1EVMPAR   ACTION Action Parameter "A" CHAR   1  
              E1EVMPAR   PARTYP Parameter Type "I" CHAR   1  
              E1EVMPAR   PARAM_NAME Parameter Name "INTERLINE_CARRIER" CHAR   25 PARAM_NAME ="INTERLINE_CARRIER"
              E1EVMPAR   PARAM_VALUE Parameter Value   CHAR   4 Interline carrier SCAC code; 
N902  (when N901 = "ET") Mapped based on Logic   N902 X AN 30 Mode E1EVMPAR   ACTION Action Parameter "A" CHAR   1  
              E1EVMPAR   PARTYP Parameter Type "I" CHAR   1  
              E1EVMPAR   PARAM_NAME Parameter Name "INTERLINE_MODE" CHAR   25 PARAM_NAME ="INTERLINE_MODE"
              E1EVMPAR   PARAM_VALUE Parameter Value   CHAR   4 if = "T", then map "TRUCK"; if = "O" then map "Ocean"; if "R" then map "RAIL"
V902 when V901 = "ZZZ"   V902 X AN 30 Remarks E1EVMPAR   ACTION Action Parameter "A" CHAR   1  
              E1EVMPAR   PARTYP Parameter Type "I" CHAR   1  
              E1EVMPAR   PARAM_NAME Parameter Name "Ocean_Comments" CHAR   25 PARAM_NAME ="OCEAN_COMMENTS"
              E1EVMPAR   PARAM_VALUE Parameter Value   CHAR   30 =V902; free form text
N902  (when N901 = "IB") Mapped based on Logic   N902 X AN 30 Inbond Number E1EVMPAR   ACTION Action Parameter "A" CHAR   1  
              E1EVMPAR   PARTYP Parameter Type "I" CHAR   1  
              E1EVMPAR   PARAM_NAME Parameter Name "Inbond_Number" CHAR   25 PARAM_NAME ="Inbond_Number"
              E1EVMPAR   PARAM_VALUE Parameter Value   CHAR   4 if N901 = "IB" then map N902 to "inbond_number"
                               
B401  Mapped based on Logic   B401 X AN 30 Load By E1EVMPAR   ACTION Action Parameter "A" CHAR   1  
              E1EVMPAR   PARTYP Parameter Type "I" CHAR   1  
              E1EVMPAR   PARAM_NAME Parameter Name "Container_Load_By" CHAR   25 PARAM_NAME ="Container_Load_By"
              E1EVMPAR   PARAM_VALUE Parameter Value   CHAR   4 If B401 = "CF", then "container_load_by" = "factory"; else, "container_load_by" = "consolidator"