Data Mapping worksheet [EDI 861 - D1 to SAP EM IDOC EVMSTA02]  
Filteration criteria: This EVMSTA02 IDOC should be generated only for order level records that have PRF05 field in PRFsegment at the order hierarchical level = 'BBW' or 'VSB' or 'BTA / BAV'   
One IDOC should be generated for each unique Ship Number in TD303 segment.   
Time Zone must be posted using the SAP Timezone format standards standard (use T-code STZBC to look up SAP Standard Timezone codes)
All fields in this mapping that are marked as " " should be considered hardcoded                    
    TARGET SYSTEM FIELDS        
PT[1] PT[2] PT[3] PT[4] PT[5]  
Field Data[6]    [7] Data Element Information[8]    [9]  [10] Logic
Table Row No Field Name Short Text   Data No. of
Name (Repeated Rows in the Table) (Columns in the Table)   Value Type Char's
               
IDOC:     EVMSTA02        
               
This mapping should be done when Transaction Set Purpose Code (BRA03 field from BRA segment) is '02' (Add) '03' (Delete) or '04' (Change) and Receiving advice code (BRA04 field from BRA segment) field is '1' (Receiving Dock Advice) or 'R' (Intermediate Po
[Data Concept] Header Table              
E1EDIDC 1 RCVSAD SADR Recipient =ISA07 CHAR 9 R              
E1EDIDC 2 STDMES Message Type 861D1 CHAR 3 = when STO01 =861 and BRA04 = 1 or "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              
E1EVMHDR02 1 EVTID Event Code ID "CFS_ARRIVAL" CHAR 50  
E1EVMHDR02 1 EVTDAT Event Date Date of shipment arrival at CFS DATE   This date will be the actual arrival Date at CFS. In current EDI 861 we believe this value appears in DTM02 field for DTM segment (in the loop for RCD segment) whose DTM01 field is '372'. The date format needs to be CCYYMMDD.
E1EVMHDR02 1 EVTTIM Event Time Time of shipment arrival at CFS TIME   This time will be the actual arrival Time at CFS. In current EDI 861 we believe this value appears in DTM03 field for DTM segment (in the loop for RCD segment) whose DTM01 field is '372'. The time format needs to be HHMMSS.
E1EVMHDR02 1 EVTZON Event Time Zone   CHAR 6 This time zone of the above mapped date/time. In current EDI 861 we believe this value appears in DTM04 field for DTM segment whose DTM01 field is '372'.
E1EVMHDR02 1 REPDAT Reporting Date   DATE   Date when the EDI message was received in the receiving system
E1EVMHDR02 1 REPTIM Reporting Time   TIME   Time when the EDI message was received in the receiving system
E1EVMHDR02 1 REPZON Reporting Time Zone   CHAR 6 Time zone of the receiving system
[Data Concept] Tracking ids              
E1EVMTID 1 TRXCOD Tracking ID Code Set "SHNR" CHAR 20  
E1EVMTID 1 TRXID Tracking ID   CHAR 50 This is the unique Ship_number in the Manu transportation plan tendered to carrier and is available in EDI 856. It is in REF02 field with a qualifier REF01 = 'AG'.
               
E1EVMTID 1 TRXCOD Tracking ID Code Set "HAWBFCR CHAR 20  
E1EVMTID 1 TRXID Tracking ID   CHAR 50 REF02 field with a qualifier REF01 = 'RV in the N1 loop'.
[Data Concept] Parameters              
Do the mapping for Parameters for every PO in the EDI 861 Transaction              
E1EVMPAR 1 PARTYP Parameter Type "I" CHAR 1  
E1EVMPAR 1 PARAM_NAME Parameter Name "RC_" + #REF02_# + #RCD01# CHAR 32 This field is dynamic. The format is "RC_" followed by the value in REF02 with a PO qualifier in REF01, + a "_"  + the value in RCD01. REF02 is the purchase order number. RCD01 is the CFS reciept number.   
E1EVMPAR 1 PARAM_VALUE Parameter Value   CHAR 20 We assume that in the current EDI 861 this field is availablein RCD segment, field RCD02. PARAM_VALUE =  RCD02 when BRA03= '02' or '04';  PARAM_VALUE = 0 (Zero) when BRA03= '03'.
E1EVMPAR 1 ACTION Action Parameter "C" CHAR 1  
E1EVMPAR 2 PARTYP Parameter Type "I" CHAR 1  
E1EVMPAR 2 PARAM_NAME Parameter Name "DG_" + #PRF01# + #RCD01# CHAR 32 When RCD08 = "01" then create a parameter with this name. This field is dynamic. The format is "DG_" followed by the value in PRF01  + a "_"  + the value in RCD01. PRF01 is the purchase order number. RCD01 is the CFS reciept number.   
E1EVMPAR 2 PARAM_VALUE Parameter Value   CHAR 20 We assume that in the current EDI 861 this field is availablein RCD segment, field RCD06. PARAM_VALUE =  RCD06 when BRA03= '02' or '04';  PARAM_VALUE = 0 (Zero) when BRA03= '03'.
E1EVMPAR 2 ACTION Action Parameter "C" CHAR 1  
E1EVMPAR 3 PARTYP Parameter Type "I" CHAR 1    
E1EVMPAR 3 PARAM_NAME Parameter Name "OVR_" + #REF02_# + #RCD01# CHAR 32 When REF01 = "OVR" then create this parameter with this name.  This field is dynamic. The format is "OVR_" followed by the value in REF02  + a "_"  + the value in RCD01. PRF01 is the purchase order number. RCD01 is the CFS reciept number.   
E1EVMPAR 3 PARAM_VALUE Parameter Value   CHAR 20 REF02 where REF01="OVR"  
E1EVMPAR 3 ACTION Action Parameter "C" CHAR 1    
E1EVMPAR 4 PARTYP Parameter Type "I" CHAR 1    
E1EVMPAR 4 PARAM_NAME Parameter Name "SRT_" + #REF02# + #RCD01# CHAR 32 When REF01 = "SRT" then create this parameter with this name. This field is dynamic.  The format is "SRT_" followed by the value in REF02  + a "_"  + the value in RCD01. PRF01 is the purchase order number. RCD01 is the CFS reciept number.   
E1EVMPAR 4 PARAM_VALUE Parameter Value   CHAR 20 REF02 where REF01="SRT"  
E1EVMPAR 4 ACTION Action Parameter "C" CHAR 1    
E1EVMPAR 4 PARTYP Parameter Type "I" CHAR 1    
E1EVMPAR 4 PARAM_NAME Parameter Name "Discrepancy Number" CHAR 32 When REF01= "OVR' or SRT or when RCD08 = "01"  
E1EVMPAR 4 PARAM_VALUE Parameter Value   CHAR 20 =DTM06 (in the header segment); If REF01 = "OVR" or SRT or RCD08 = "01", then DTM01 = "166" and DTM06 is the discrepenacy number  
E1EVMPAR 4 ACTION Action Parameter "C" CHAR 1    
E1EVMPAR 4 PARTYP Parameter Type "I" CHAR 1    
E1EVMPAR 4 PARAM_NAME Parameter Name "Discrepancy Status" CHAR 32 When REF01= "OVR' or SRT or when RCD08 = "01"  
E1EVMPAR 4 PARAM_VALUE Parameter Value   CHAR 20 =N104 when REF01= "OVR" or "SRT" or when RDC08 = "01"  
E1EVMPAR 4 ACTION Action Parameter "C" CHAR 1    
E1EVMPAR 4 PARTYP Parameter Type "I" CHAR 1    
E1EVMPAR 4 PARAM_NAME Parameter Name "Ship Whole?" CHAR 32    
E1EVMPAR 4 PARAM_VALUE Parameter Value   CHAR 20 =TD105 (Y or N)  
E1EVMPAR 4 ACTION Action Parameter "C" CHAR 1    
E1EVMPAR 5 PARTYP Parameter Type "I" CHAR 1    
E1EVMPAR 5 PARAM_NAME Parameter Name "CFS_Location" CHAR 32    
E1EVMPAR 5 PARAM_VALUE Parameter Value   CHAR 20 when TD508 = "MIA" then param_Value ="MIA - Hellmann Miami"; If TD508 = "CMH" then value = "CMH - ODW Columbus'; if TD508 = ORD, then "ORD - ODW Chicago"; if TD508 = "JFK" then value = "JFK - Cargo Connection New York"; if TD508 = "ATL" then "ATL - Cargo   
E1EVMPAR 5 ACTION Action Parameter "C" CHAR 1    
E1EVMPAR 5 PARTYP Parameter Type "I" CHAR 1  
E1EVMPAR 5 PARAM_NAME Parameter Name "CFS_HOLD" CHAR 32 Map this parameter if there is a REF segment when REF01='HP'
E1EVMPAR 5 PARAM_VALUE Parameter Value REF02 CHAR 20 This is the value from REF segment at the header level where REF01 = 'HP'. 
E1EVMPAR 5 ACTION Action Parameter "C" CHAR 1  
[1]
Enter the type of data covered on this field map.  For master data, enter Master Data - <category>.
For other data, enter description.
[2]
Process Team member
[3]
Process Team member
[4]
Process Team member
[5]
Process Team member
[6]
Process Team member
[7]
Go to screen in SAP.
Highlight field.
Press F1 or click on Help to open.
Enter table name from field data section in Help screen.
[8]
Go to screen in SAP.
Highlight field.
Press F1 or click Help to open.
Enter field name from field data section in Help screen.
[9]
Go to screen in SAP.
Highlight field.
Press F1 or click Help to open.
Highlight data element in Help screen, double click to open.
Enter short text from data element screen.
[10]
Go to screen in SAP.
Highlight field.
Press F1 or click on Help to open.
Highlight data element, double click to open.
Enter data type from data element screen.
[11]
Go to screen in SAP.
Highlight field.
Press F1 or click on Help to open.
Highlight data element, double click to open.
Enter No. of characters from data element screen.