Demo Sandbox ModeBase configuration only. Changes not persisted and cleared every 24h. For production use, contact us via the main page.
Validation Results
Validation ID: validation-003
Total Records
3
Processed
Passed
2
Valid transformations
Failed
1
Invalid transformations
Pass Rate
66.7%
Validation Results
| Record ID | Status | Issues | Actions |
|---|---|---|---|
| 10001 | pass | No issues | |
| 10002 | pass | No issues | |
| 20001 | fail | MTART: Lookup table missing mapping for line type 'S' MAKTX: Description 2 field (IMDSC2) was null/empty |
Field-Level Analysis
Record 20001
Failed
Source (JDE)
{
"IMITM": "20001",
"IMDSC1": "Service Item",
"IMDSC2": "Installation",
"IMSRP1": "SERVICE",
"IMSRP2": "INSTALL",
"IMSTKT": "SR",
"IMUOM1": "HR",
"IMUOM2": "HR",
"IMCONV": 1,
"IMGLPT": "0003",
"IMLNTY": "S",
"IMPRGR": "SERVICE",
"IMSTKT_DESC": "Service",
"IMAITM": "20001",
"IMKCO": "00001"
}Target (SAP)
{
"MATNR": "000000000000020001",
"MAKTX": "Service Item Installation",
"MTART": "DIEN",
"MEINS": "HR",
"MATKL": "003",
"BISMT": "20001",
"LABOR": "SERV",
"LVORM": "",
"NTGEW": "0.000",
"GEWEI": "KG",
"VOLUM": "0.000",
"VOLEH": "M3",
"BRGEW": "0.000",
"WERKS": "1000",
"LGORT": ""
}Issues Found
MTART
Lookup table missing mapping for line type 'S'
Expected: DIEN
Actual: FERT
Actual: FERT
MAKTX
Description 2 field (IMDSC2) was null/empty
Expected: Service Item Installation
Actual: Service Item
Actual: Service Item