SAP table T8JDT (JV EDI Inbound: 810 Mapping Table)
SAP table T8JDT has 4 primary key fields being MANDT,BUKRS,SJIBE,PROPNO.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| SJIBE | Sender's JIBE/PASC Number | CHAR | 12 | 0 | T8JDC | JV_SJIBE | |
| PROPNO | Property Number | CHAR | 30 | 0 | T8JDD | JV_PROPNO | |
| QUALIFIER | Mapping Qualifier | CHAR | 3 | 0 | T8JDH | JV_QUALIF | |
| WITHHOLD | Withhold Code | CHAR | 3 | 0 | T8JDF | JV_WITHHLD | |
| PROID | Work Breakdown Structure Element (WBS Element) | NUMC | 8 | 0 | JV_PROJEDI | ||
| AUFNR | Order Number | CHAR | 12 | 0 | AUFK | AUFNR | |
| KOSTL | Cost Center | CHAR | 10 | 0 | CSKS | KOSTL | |
| ANLN1 | Main Asset Number | CHAR | 12 | 0 | ANLH | ANLN1 | |
| ANLN2 | Asset Subnumber | CHAR | 4 | 0 | ANLA | ANLN2 | |
| NEWBW | Asset transaction type | CHAR | 3 | 0 | TABW | JV_BWASL |
T8JDT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T8JDT | ANLN1 | ANLH | Main asset number | BUKRS |
| 0 T8JDT | ANLN1 | ANLH | Main asset number | ANLN1 |
| 1 T8JDT | ANLN2 | ANLA | Asset Master Record Segment | BUKRS |
| 1 T8JDT | ANLN2 | ANLA | Asset Master Record Segment | ANLN1 |
| 1 T8JDT | ANLN2 | ANLA | Asset Master Record Segment | ANLN2 |
| 0 T8JDT | AUFNR | AUFK | Order master data | AUFNR |
| 1 T8JDT | BUKRS | T001 | Company Codes | BUKRS |
| 0 T8JDT | KOSTL | CSKS | Cost Center Master Record | MANDT |
| 0 T8JDT | KOSTL | CSKS | Cost Center Master Record | KOKRS |
| 0 T8JDT | KOSTL | CSKS | Cost Center Master Record | KOSTL |
| 0 T8JDT | KOSTL | CSKS | Cost Center Master Record | DATBI |
| 1 T8JDT | NEWBW | TABW | Asset transaction types | MANDT |
| 0 T8JDT | PROPNO | T8JDD | JV EDI Inbound: Property Table | MANDT |
| 0 T8JDT | PROPNO | T8JDD | JV EDI Inbound: Property Table | BUKRS |
| 1 T8JDT | QUALIFIER | T8JDH | JV EDI Inbound: Mapping Qualifier Tables | MANDT |
| 1 T8JDT | QUALIFIER | T8JDH | JV EDI Inbound: Mapping Qualifier Tables | BUKRS |
| 0 T8JDT | SJIBE | T8JDC | JV EDI Inbound: Sender's JIBE/PASC Number Table | MANDT |
| 0 T8JDT | SJIBE | T8JDC | JV EDI Inbound: Sender's JIBE/PASC Number Table | BUKRS |
| 0 T8JDT | SJIBE | T8JDC | JV EDI Inbound: Sender's JIBE/PASC Number Table | SJIBE |
| 1 T8JDT | WITHHOLD | T8JDF | JV EDI Inbound: Withhold Code Table | MANDT |
| 1 T8JDT | WITHHOLD | T8JDF | JV EDI Inbound: Withhold Code Table | BUKRS |