SAP table TCGL3 (Report Applications)
SAP table TCGL3 has 2 primary key fields being MANDT,REPAPPL.
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 | |
| REPAPPL | Report Application | CHAR | 10 | 0 | ESEREPAPPL | ||
| OBJTABLE | Table Name | CHAR | 30 | 0 | DD02L | TABNAME | |
| OBJFIELD | Field Name | CHAR | 30 | 0 | DD03L | FIELDNAME | |
| OBJINFO_MODULE | Function Module that Reads Addit. Info. for an Applic. Obj. | CHAR | 30 | 0 | ESEOBJINFO_MODULE | ||
| OBJJOIN_MODULE | Function Module that Determines Assigned Application Objects | CHAR | 30 | 0 | ESEOBJJOIN_MODULE | ||
| OBJVALH_MODULE | Function Module that Calls Input Help for Objects | CHAR | 30 | 0 | ESEOBJVALH_MODULE | ||
| SELSCR_PROG | Screen program for an application object selection screen | CHAR | 40 | 0 | * | ESESELSCRPROG | |
| SELSCR_DYNNR | Screen Number for Application Object Selection Screen | CHAR | 4 | 0 | ESESELSCRDYNNR | ||
| SELSCR_OKCODE | Function for processing OK code in selection screen | CHAR | 30 | 0 | * | ESESELSCROKMODULE | |
| SELSCR_CLOSE | Function module to determine selected application objects | CHAR | 30 | 0 | * | ESESELSCRCLOSE | |
| SELSCR_OPEN | Function to initialize select. screen for application object | CHAR | 30 | 0 | * | ESESELSCROPEN | |
| APPL_TREELEVEL1 | Report Application | CHAR | 10 | 0 | * | ESEREPAPPL | |
| APPL_TREELEVEL2 | Report Application | CHAR | 10 | 0 | * | ESEREPAPPL | |
| APPL_TREELEVEL3 | Report Application | CHAR | 10 | 0 | * | ESEREPAPPL | |
| APPL_TREELEVEL4 | Report Application | CHAR | 10 | 0 | * | ESEREPAPPL | |
| APPL_TREELEVEL5 | Report Application | CHAR | 10 | 0 | * | ESEREPAPPL | |
| COLOR | Color display of a hierarchy node | NUMC | 1 | 0 | SEU_COLOR | ||
| ORD | Sort Order | NUMC | 4 | 0 | ESEORD | ||
| WB_ICON | Icon in Text Fields | CHAR | 4 | 0 | ICON | HRPDV_ICON |
TCGL3 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TCGL3 | OBJFIELD | DD03L | Table Fields | TABNAME |
| 0 TCGL3 | OBJFIELD | DD03L | Table Fields | FIELDNAME |
| 0 TCGL3 | OBJFIELD | DD03L | Table Fields | AS4LOCAL |
| 0 TCGL3 | OBJFIELD | DD03L | Table Fields | AS4VERS |
| 1 TCGL3 | OBJTABLE | DD02L | SAP Tables | TABNAME |
| 1 TCGL3 | OBJTABLE | DD02L | SAP Tables | AS4LOCAL |
| 1 TCGL3 | OBJTABLE | DD02L | SAP Tables | AS4VERS |
| 0 TCGL3 | WB_ICON | ICON | Icons table | ID |