Data Mapping Worksheet                    
One IDOC for every unique PO HAWB/FCR combination
GIS to create IDOC only if TD508 equals CDC for EVENT 9
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 Segment 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 CFSCNF
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 ZSHPD Shipped date CHAR 8     R N Transactional CFS Ship date
7 ZIDOC_MM_EDI_CONF ZSHPT Shipped time CHAR 6 R N Transactional Time of processing
8 ZIDOC_MM_EDI_CONF ZQTCR Number of Cartons CHAR 6     R N Transactional Number of Cartons
9 ZIDOC_MM_EDI_CONF LIFNR Business partner CHAR 10     R N Transactional CFS' +3 digit code. Look-up 3 digit CFS EDI in new CFS table
10 ZIDOC_MM_EDI_CONF ZCFTN Trailer number CHAR 15     S N Transactional Trailer number
 
                 
                 
                 
                 
                   
                       
               
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