SAP table OIRADTLT (Document transaction link table)
SAP table OIRADTLT has 8 primary key fields being MANDT,LINKNR,ITLINKNR,LINKYEAR,DOCTYPE,DOCYEAR,DOCNR,POSNR.
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 | * | MANDT | |
| LINKNR | Link number | NUMC | 10 | 0 | OIRA_LINKNR | ||
| ITLINKNR | Item link number | NUMC | 6 | 0 | * | OIRA_ITLINKNR | |
| LINKYEAR | Document link number year | NUMC | 4 | 0 | OIRA_JAHR | ||
| DOCTYPE | Subsequent document type | CHAR | 3 | 0 | * | OIRA_DOCTYPE | |
| DOCYEAR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| DOCNR | Sales and Distribution Document Number | CHAR | 10 | 0 | * | VBELN | |
| POSNR | Item number of the SD document | NUMC | 6 | 0 | * | POSNR | |
| SRCETAB | Source table | CHAR | 16 | 0 | OIRA_SCRETAB | ||
| DOCDATE | SSR - Document date | DATS | 8 | 0 | OIRA_DOCDATE | ||
| TARGETTAB | SSR - Target table | CHAR | 30 | 0 | * | OIRA_TARGETTAB | |
| COUNTER | Transaction counter | INT4 | 10 | 0 | OIRA_COUNTER | ||
| PROCDATE | Process execution date | DATS | 8 | 0 | OIRA_PCDATE |