| Data Mapping Worksheet | ||||||||||||
| One IDOC message for every unique PO and HAWB/FCR number | ||||||||||||
| 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 | CUSCNF | |||||||||
| 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 '2' for Customs | |||
| 9 | ZIDOC_MM_EDI_CONF | LIFNR | Business partner | CHAR | 10 | R | N | Transactional | Customs agent 'CUS' + first 3 characters of entry number N902 6B qualifier | |||
| 12 | ZIDOC_MM_EDI_CONF | ZCSBR | Broker reference | CHAR | 30 | S | N | Transactional | Broker reference | |||
| Error Handling / Cleansing Logic | (copy an existing row to record all fields) | |||||||||||
| Item | Field Name | Field Value | Exception Handling Logic | |||||||||