SAP table T801K (Report Writer: Libraries)
SAP table T801K has 2 primary key fields being MANDT,LIB.
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 | |
| LIB | Library | CHAR | 3 | 0 | LIB | ||
| TAB | Report Writer table | CHAR | 30 | 0 | T804A | SUPERTAB | |
| CNAM | Created By | CHAR | 12 | 0 | CRNAM | ||
| CDAT | Creation date | DATS | 8 | 0 | CRDAT | ||
| UNAM | Last Changed By | CHAR | 12 | 0 | UPNAM | ||
| UDAT | Date on which object was last changed | DATS | 8 | 0 | UPDAT | ||
| QJOBS | Prefix for query jobs | CHAR | 2 | 0 | QJOBS | ||
| LAST_JOB | Last query job already assigned | CHAR | 4 | 0 | T803J | LAST_JOB | |
| SREPORT | Standard report for queries | CHAR | 8 | 0 | T800 | SREPORT | |
| CL_SET | Set with receiver reports | CHAR | 12 | 0 | CL_SET | ||
| QPREFIX | Prefix for Report Writer objects in evaluations | CHAR | 4 | 0 | QPREFIX | ||
| CRTIME | Creation Time | TIMS | 6 | 0 | CR_TIME | ||
| UPTIME | Time of last change | TIMS | 6 | 0 | UP_TIME | ||
| CUA_REPORT | Program with reference GUI | CHAR | 40 | 0 | CUA_REPORT | ||
| AUTHGR | Authorization group | CHAR | 4 | 0 | TBRG | AUTHGR | |
| GUI_STATUS | GUI status for report output | CHAR | 20 | 0 | RW_GUI | ||
| RW_APPL | Application component ID | CHAR | 24 | 0 | UFPS_POSID | ||
| MASTERLANG | Original Language for Sets (SAP Internal Only) | LANG | 1 | 0 | T804I | SET_OLANGU |
T801K foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T801K | AUTHGR | TBRG | Authorization groups | MANDT |
| 0 T801K | AUTHGR | TBRG | Authorization groups | BRGRU |
| 1 T801K | LAST_JOB | T803J | Report Writer: Report Groups | MANDT |
| 1 T801K | LAST_JOB | T803J | Report Writer: Report Groups | RGJNR |
| 0 T801K | MASTERLANG | T804I | Report Writer: Supported Languages | LANGU |
| 1 T801K | SREPORT | T800 | Report Writer: Reports | MANDT |
| 1 T801K | SREPORT | T800 | Report Writer: Reports | LIB |
| 0 T801K | TAB | T804A | Report Writer: File Description | TAB |