Data Mapping worksheet [EDI 861 - E9 to SAP EM IDOC EVMSTA02]
One IDOC should be generated for each unique HAWB or FCR in REF02 field when REF 01 = 'AW' or "OB"
The IDOC should be generated for ADD (00), REPLACE (05) and DELETE CODES (03) (BRA03  = '00' or '03' or '05')
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 '00' (Original), '03' (Delete) and or '05' (Replace) and Receiving advice code (BRA04 field from BRA segment) field is '2' (Post Receipt Advice)
[Data Concept] Header Table             "
E1EDIDC 1 RCVSAD SADR Recipient =ISA07 CHAR 9 R              
E1EDIDC 2 STDMES Message Type 861E9 CHAR 3 = when STO01 =861 and BRA04 = 2              
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_SHIPMENT" CHAR 50 = when STO01 =861 and BRA04 = 2
E1EVMHDR02 1 EVTDAT Event Date CFS Shipment Date DATE   This date will be the date goods are shipped to Destination from CFS. In current EDI 861 we believe this value appears in DTM02 field for DTM segment (in the header) where DTM01 field is '011'. The date format needs to be CCYYMMDD.
E1EVMHDR02 1 EVTTIM Event Time CFS Shipment Time TIME   This date will be the time goods are shipped to Destination from CFS. In current EDI 861 we believe this value appears in DTM03 field for DTM segment (in the header) where DTM01 field is '011'. The time format needs to be HHMMSS.
E1EVMHDR02 1 EVTZON Event Time Zone   CHAR 6 In current EDI 861 we believe this value appears in DTM04 field for DTM segment (in the header) where DTM01 field is '011'
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 When REF 01 = "AW" then REF02 = HAWB number; When REF01 = "OB" , REF02 = FCR
[Data Concept] Parameters              
Do the mapping for Parameters for every PO planned by Manu              
E1EVMPAR 1 PARTYP Parameter Type "I" CHAR 1  
E1EVMPAR 1 PARAM_NAME Parameter Name "SP_" + #PRF01_# + #BRA01# CHAR 32 This field is dynamic. The format is "SP_" followed by  the value in PRF01, a "_" and the value in BRA01.  PRF01 is the purchase order number. BRA01 is the unique number to identify each CFS shipment. 
E1EVMPAR 1 PARAM_VALUE Parameter Value   CHAR 20 We assume the quantity appears in TD102 segment under the PO mapped in the previous line. PARAM_VALUE =  TD102 when BRA03 = '00' or '05';  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 "Trailer_Number" CHAR 32 if TD301 = 'TL'
E1EVMPAR 2 PARAM_VALUE Parameter Value TD302+TD303 CHAR 20 This is a concatination of TD302 and TD303 where TD301 = 'TL'
E1EVMPAR 2 ACTION Action Parameter "A" CHAR 1  
E1EVMPAR 3 PARTYP Parameter Type "I" CHAR 1    
E1EVMPAR 3 PARAM_NAME Parameter Name "Carrier_Name" CHAR 32 When N101 = "CA"    
E1EVMPAR 3 PARAM_VALUE Parameter Value   CHAR 20 when N101 = "CA" populate with N102  
E1EVMPAR 3 ACTION Action Parameter "A" CHAR 1    
E1EVMPAR 3 PARTYP Parameter Type "I" CHAR 1    
E1EVMPAR 3 PARAM_NAME Parameter Name "CFS_Manifest_Number" CHAR 32    
E1EVMPAR 3 PARAM_VALUE Parameter Value REF02 CHAR 20 REF02 where REF01="MK"  
E1EVMPAR 3 ACTION Action Parameter "A" CHAR 1    
E1EVMPAR 3 PARTYP Parameter Type "I" CHAR 1    
E1EVMPAR 3 PARAM_NAME Parameter Name "CFS_Seal_Number" CHAR 32    
E1EVMPAR 3 PARAM_VALUE Parameter Value TD309 CHAR 20    
E1EVMPAR 3 ACTION Action Parameter "A" CHAR 1    
E1EVMPAR 3 PARTYP Parameter Type "I" CHAR 1    
E1EVMPAR 3 PARAM_NAME Parameter Name CFS_Shipto" CHAR 32 When TD507 = "DE"  
E1EVMPAR 3 PARAM_VALUE Parameter Value   CHAR 20 When TD507 = "DE", populate with TD508 as follows:  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 Conne  
E1EVMPAR 3 ACTION Action Parameter "A" 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.