| Data Mapping Worksheet | ||||||||||||
| E1 if FCR/HAWB exists, create IDOC otherwise | ||||||||||||
| 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 | Custom IDOC = Z_ASN_IDOC |
File | na | HP-UX 11.0 | Day | n/a | N | LBI | Minimum (mandatory) occurrence of 1 to allowable maximum. | ||
| 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 | Confirmation date | CHAR | 8 | R | N | Transactional | Cargo receipt date | |||
| 7 | ZIDOC_MM_EDI_CONF | ZCNFT | Confirmation 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 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 |
|||
| 15 | ZIDOC_MM_EDI_CONF | ZEVENT | Event | CHAR | 2 | R | N | Transactional | Event received (E1) | |||
| Error Handling / Cleansing Logic | (copy an existing row to record all fields) | |||||||||||
| Item | Field Name | Field Value | Exception Handling Logic | |||||||||