Data Mapping Worksheet                    
One IDOC per unique PO HAWB/FCR combination
Database Description  
Item System[1] DB / File Name[2] DBMS Type
(Oracle, DB2, SQL Server, File, etc)[3]		 DBMS Version[4] OS Platform & Version Expected Volume[5] Volume Unit of Measure
(e.g. Day, Week, etc)[6]		 ILM Policy
(e.g. 4 weeks, 6 months, 2 years, etc)[7]		 SOR?
(Y / N)[8]		 Organizational Context
(LBI,  Regulatory, 3rd Party)[9]		 Comments / Remarks[10]
1 SAP IDoc File na HP-UX 11.0   Day n/a N LBI  
Table Definitions   (copy an existing row to record all tables and fields)              
Item Table Name[11] Field Name[12] Description[13] Field Data Type[14] Field Length[15] # of Decimal Places[16] Format Usage
(R / O / S)[17]		 SOR?
(Y / N)[18]		 Data Classification[19] Comments / Remarks[20]
1 EDIDC MESTYP FORCNF
2 EDIDC MESCOD UPD/DEL
3 ZIDOC_MM_EDI_CONF EBELN PO number CHAR 12     R N Transactional PO number
4 ZIDOC_MM_EDI_CONF XBLNR HAWB/FCR number CHAR 30     R N Transactional HAWB/FCR number
5 ZIDOC_MM_EDI_CONF ZCNFTP Confirmation type CHAR 1     R N Transactional Fixed value '1' for forwarders
6 ZIDOC_MM_EDI_CONF ZCNFD GAC date CHAR 8     O N Transactional Cargo receipt date
7 ZIDOC_MM_EDI_CONF ZCNFT GAC time CHAR 6 O N Transactional Time of processing
8 ZIDOC_MM_EDI_CONF ZQTCR Number of Cartons CHAR 6     R N Transactional Number of Cartons for PO + HAWB/FCR
9 ZIDOC_MM_EDI_CONF LIFNR Business partner CHAR 10     R N Transactional 'FOR' + SCAC code
Lookup GSO2 in SCAC table, this will return the 4 digit SCAC
10 ZIDOC_MM_EDI_CONF ZFWNR MAWB/OBOL number CHAR 30     R N Transactional MAWB/OBOL number
11 ZIDOC_MM_EDI_CONF ZFWVN Vessel name CHAR 30     R N Transactional Vessel name
12 ZIDOC_MM_EDI_CONF ZGRSW Gross weight CHAR 19     O N Transactional Gross weight
13 ZIDOC_MM_EDI_CONF ZVOLW Volume weight CHAR 19     O N Transactional Volumetric weight
14 ZIDOC_MM_EDI_CONF ZBILW Billed weight CHAR 19     O N Transactional Billable weight
15 ZIDOC_MM_EDI_CONF GEWEI Weight unit CHAR 3     O N Transactional Unit
15 ZIDOC_MM_EDI_CONF ZEVENT Event CHAR 2     R N Transactional Event received (E4)
16 ZIDOC_MM_EDI_CONF ZSHPD Shipped date CHAR 8     R N Transactional Actual departure date
17 ZIDOC_MM_EDI_CONF ZSHPT Shipped time CHAR 6     R N Transactional Actual departure time
                   
                       
               
Error Handling / Cleansing Logic (copy an existing row to record all fields)          
Item Field Name Field Value Exception Handling Logic  
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
                 
   
[1]
Aaron Rorstrom:
"Required"
[2]
Aaron Rorstrom:
"Required"
[3]
Aaron Rorstrom:
"Required"
Enter "File" if flat file
[4]
Aaron Rorstrom:
"Required"
[5]
Aaron Rorstrom:
"Required"
[6]
Aaron Rorstrom:
"Required"
[7]
Aaron Rorstrom:
"Required"
[8]
Aaron Rorstrom:
"Required"
"SOR" = system of record
[9]
Aaron Rorstrom:
"Required"
[10]
Aaron Rorstrom:
"Optional"
Record add'l information as required
[11]
Aaron Rorstrom:
"Required"
[12]
Aaron Rorstrom:
"Required"
[13]
Aaron Rorstrom:
"Required"
[14]
Aaron Rorstrom:
"Required"
[15]
Aaron Rorstrom:
"Required"
Value must be greater than 0.
[16]
Aaron Rorstrom:
"Required"
Enter 0 (zero) for no decimal places
[17]
Aaron Rorstrom:
Indicate
"R" for required,
"O" for optional,
"S" for suppressed
[18]
Aaron Rorstrom:
"Required"
"SOR" = system of record
[19]
Aaron Rorstrom:
"Master Ref" = Master data Referential; "Master Trans" = Master data Transactional; "Transactional" = transactional data that is not Master Data;  "Configuration" = data that is used to configure a process; "Metric" = Metric, KPI
[20]
Aaron Rorstrom:
"Optional"
Record add'l information as required