SAP table TKES1 (Row/column structures)
SAP table TKES1 has 5 primary key fields being MANDT,APPLCLASS,SUBCLASS,TABNAME,FORM.
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 | |
| APPLCLASS | Application class for DD objects (not used) | CHAR | 4 | 0 | TAPPL | APPLCLASS | |
| SUBCLASS | Subgroup by application class | CHAR | 2 | 0 | SUBCLASS | ||
| TABNAME | Table Name | CHAR | 30 | 0 | TABNAME | ||
| FORM | Form | CHAR | 12 | 0 | RKE_CFORM | ||
| FART | Type of Form | CHAR | 1 | 0 | RKE_FART | ||
| FTYP | Type of structure | CHAR | 1 | 0 | RKE_FTYP | ||
| TFLAG | Indicator: Field is required for text routine | CHAR | 1 | 0 | TFLAG | ||
| ZEDIM | CO-PA dimension of an element | CHAR | 1 | 0 | RKE_EDIM | ||
| ZSUBNR | Subnumber | NUMC | 2 | 0 | RKE_SUBNR | ||
| GDATE | Date created | DATS | 8 | 0 | CESGDATE | ||
| MODCN | Version | NUMC | 8 | 0 | CESMODCN | ||
| MODNA | Last Changed By | CHAR | 12 | 0 | CESMODNA | ||
| MODDA | Date of last change | DATS | 8 | 0 | CESMODDA | ||
| MODTI | Time changed | TIMS | 6 | 0 | CESMODTI | ||
| DVERS | RPT: ABAP/4 Dict. version of form (conversion counter) | NUMC | 8 | 0 | CESDVERS | ||
| INACT | RPT: Report Painter object is inactive | CHAR | 1 | 0 | CESINACT | ||
| TEXTA | Indicator for which text will be displayed | CHAR | 1 | 0 | RKE_TEXTA | ||
| REP_GRP | Grouping forms | CHAR | 12 | 0 | TKAB_GRP | KCDD_FRMGRP |
TKES1 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TKES1 | APPLCLASS | TAPPL | R/3-DDIC: Application classes | APPLCLASS |
| 1 TKES1 | REP_GRP | TKAB_GRP | Drilldown reporting - Report grouping | MANDT |
| 1 TKES1 | REP_GRP | TKAB_GRP | Drilldown reporting - Report grouping | APPLCLASS |
| 1 TKES1 | REP_GRP | TKAB_GRP | Drilldown reporting - Report grouping | TABNAME |
| 1 TKES1 | REP_GRP | TKAB_GRP | Drilldown reporting - Report grouping | REP_GRP |