SAP table TKETRLG (Summarization Levels: Catalog entry, header (generated obj.))
SAP table TKETRLG has 5 primary key fields being MANDT,APPLCLASS,SUBCLASS,TABNAME,TRCATNR.
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 | Subclass of application class for totals records | CHAR | 2 | 0 | RKE_TRSUBA | ||
| TABNAME | Table Name | CHAR | 30 | 0 | TABNAME | ||
| TRCATNR | Summarization level | NUMC | 6 | 0 | RKE_TRLFD | ||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| AETIM | Last changed at | CHAR | 4 | 0 | AETIM | ||
| KTABNAME | Name of key table for summarization level | CHAR | 30 | 0 | * | RKE_KTABNA | |
| KTSUBNR | Subnumber in a summarization level | NUMC | 6 | 0 | RKE_KTSUB | ||
| TTABNAME | Name of totals table for summarization level | CHAR | 30 | 0 | * | RKE_TTABNA | |
| GENSTATUS | Status of summarization level | NUMC | 1 | 0 | RKE_STTREC | ||
| SAPRL | Version of generated programs | CHAR | 4 | 0 | RKE_TSAPRL | ||
| TIMESTMP | Seconds since 1.1.1990,0:00 GMT * 10000 | DEC | 16 | 0 | RKE_TSTMP | ||
| STATNKT | Number of records in key table | DEC | 15 | 0 | RKE_STNKT | ||
| STATNTR | Number of records in the totals table | DEC | 15 | 0 | RKE_STNTR | ||
| STATNOE | Number of summarized records created during build | DEC | 15 | 0 | RKE_STNOE | ||
| STATNEP | Number of summarized records from update | DEC | 15 | 0 | RKE_STNEP | ||
| STATTOE | Time needed to build summarization levels (in seconds) | DEC | 15 | 2 | RKE_STTOE | ||
| STATTEP | Time needed for update (in seconds) | DEC | 15 | 2 | RKE_STTEP | ||
| STATNREQ | Number of reads | DEC | 15 | 0 | RKE_STNREQ | ||
| STATTREQ | Total read response time in seconds | DEC | 15 | 2 | RKE_STTREQ | ||
| STATDREQ | Date this summarization level was last read | DATS | 8 | 0 | RKE_STDREQ |
TKETRLG foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TKETRLG | APPLCLASS | TAPPL | R/3-DDIC: Application classes | APPLCLASS |