TRKB1U SAP (Table with 'Customizing settings' for drilldown reporting) Table details
Description: Table with 'Customizing settings' for drilldown reporting
Table field list including key, data, relationships and ABAP select examples
TRKB1U is a standard SAP Table which is used to store Table with 'Customizing settings' for drilldown reporting data and is available within R/3 SAP systems depending on the version and release level.
The TRKB1U table consists of various fields, each holding specific information or linking keys about Table with 'Customizing settings' for drilldown reporting data available in SAP. These include TABNAME (Table Name), CUANM (Name of control program for drill-down reporting), M_CUANM (Program RKCDUMON for data mining reports), RNAMEI (ABAP/4 report program for selection exits).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: S - System table, maint. only by SAP, change = modificationDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP TRKB1U table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
APPLCLASS | Application class for drilldown reporting | CFAPPLCLAS | CHAR | 4 | Assigned to domain | CFAPPLCLAS | CFA | RRI_APPL | |
TABNAME | Table Name | TABNAME | CHAR | 30 | Assigned to domain | AS4TAB | DTB | ||
CUANM | Name of control program for drill-down reporting | RKE_CUANM | CHAR | 40 | Assigned to domain | PROGRAMM | |||
M_CUANM | Program RKCDUMON for data mining reports | CFMCUANM | CHAR | 8 | CHAR8 | ||||
RNAMEI | ABAP/4 report program for selection exits | CFRNAMEI | CHAR | 40 | Assigned to domain | PROGRAMM | |||
APPL | Application | RDIR_APPL | CHAR | 1 | Assigned to domain | PAPPL | |||
CLAS | Program class | CFCLASS | CHAR | 6 | Assigned to domain | CLASS | |||
NACHLESEN | Application uses the function 'read' | CFNEWSELECT | CHAR | 1 | FLAG | ||||
SEL_VER | Selection screen version | RDIR_TYPE | CHAR | 3 | SYCHAR03 | ||||
LDBNAME | LDB name | LDBNAM | CHAR | 20 | LDBNAME | LDB | SH_LDBD | ||
NO_SCREEN | No selection screen, if no variables are available | CFNOSCREEN | CHAR | 1 | BOOLE | ||||
TABKZ | Several tables in an application? | CFTABKZ | CHAR | 1 | CFTABKZ | ||||
USER_EXIT | Number for user-exit in drilldown reporting | CFUEBEGIN | NUMC | 3 | NUM3 | ||||
PERIOKZ | Flag for creating PERIO from PERDE | CFPERIOKZ | CHAR | 1 | XFLAG | ||||
POPUP_EXEC | Dialog box when calling up a report | CFPOPUP | CHAR | 1 | XFELD | ||||
SEL_DF | Default for selection when executing a report | CFSEL_DF | CHAR | 1 | CHAR1 | ||||
FB_DATA | FM for data selection | CFFBDATA | CHAR | 30 | Assigned to domain | FUNCNAME | |||
EXPTIME | Selection FM contains export parameters for selection time | CFEXPTIME | CHAR | 1 | BOOLE | ||||
FB_WAERS | FM for determining currencies | CFFBWAERS | CHAR | 30 | Assigned to domain | FUNCNAME | |||
FB_H_INFO | FM for hierarchy information | CFFBHINFO | CHAR | 30 | Assigned to domain | FUNCNAME | |||
FB_GENER | Name of the generating module for data reading (Drill-Down) | CFFBGENER | CHAR | 30 | Assigned to domain | FUNCNAME | |||
FB_ADD_INSIGHT | Function module for transfer of ADD_SEL to inSight | CFFB_ADDSEL_TO_INSIGHT | CHAR | 30 | Assigned to domain | FUNCNAME | |||
REDUCE_SEL | SEL_TAB should be reduced by the drilldown reporting tool. | CFREDU_SEL | CHAR | 1 | XFELD | ||||
ADDSELKZ | Additional selections on report selection screen? | CFADDSEL | CHAR | 1 | XFLAG | ||||
WAERS_OK | Data has decimal places for currency | CFWAERS_OK | CHAR | 1 | XFELD | ||||
WAERS_DY | Currency does not have to be known until report execution? | CFWAERS_DY | CHAR | 1 | CFWAERS_DY | ||||
OK_CODE | Default OK code for report-report interface | CFBBSDEFAU | CHAR | 4 | CHAR4 | ||||
CONFIRMS | Confirm for data saving when leaving report | CFSAVE | CHAR | 1 | BOOLE | ||||
PERI_CHECK | Period validation for special ranges is active | CFPERICHK | CHAR | 1 | CHAR1 | ||||
CUALEVEL | Scope of functions when executing drilldown report | CFFUNCT | CHAR | 1 | CFFUNCT | ||||
EXTERN | RFC connection of PC tools | CFRFC | CHAR | 1 | BOOLE | ||||
RKB1UEXIT | Exit for 'complicated' RKB1U entries | CFRKB1UEX | CHAR | 30 | Assigned to domain | FUNCNAME | |||
ENQUEUE | Report execution locked? | CFENQUEUE | CHAR | 1 | BOOLE | ||||
SELECT_OPTION | Parameter or select option | CFVPARSEL | CHAR | 1 | CFVPARSEL | ||||
BBSVAR_ADDSEL | Is Callup with Variant via Report/Report Interface Allowed? | CFBBSVAR_ADDSEL | CHAR | 1 | BOOLEAN | ||||
FB_H_KNOTEN | FM for Determining Hierarchy Nodes when Postreading | CFFBHNACH | CHAR | 30 | Assigned to domain | FUNCNAME |
Key field | Non-key field |
How do I retrieve data from SAP table TRKB1U using ABAP code
The following ABAP code Example will allow you to do a basic selection on TRKB1U to SELECT all data from the tableDATA: WA_TRKB1U TYPE TRKB1U.
SELECT SINGLE *
FROM TRKB1U
INTO CORRESPONDING FIELDS OF WA_TRKB1U
WHERE...
How to access SAP table TRKB1U
Within an ECC or HANA version of SAP you can also view further information about TRKB1U and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects