TSTCT
Transaction Texts
TSTCT is an SAP database table in S/4HANA. Transaction Texts. It contains 3 fields. 16 CDS views read from this table.
CDS Views using this table (16)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| APS_IAM_BR_APPTCODE | view_entity | left_outer | TCode for apps | |
| APS_IAM_INFO_BU_SERVICE_BASIC | view_entity | left_outer | Business User - Service Usage Basic | |
| APS_IAM_INFO_BU_SERVICE_UN_BSC | view_entity | left_outer | Business User - Service Unused Basic | |
| CDS_SUI_TA_SELECT | view | left_outer | Multiselect for transactions | |
| CDS_SUI_TM_MM_TCODE | view | left_outer | CDS View for Transaction Codes (which are used in an LADI) | |
| CUX_NWS_I_TCODE_VH | view_entity | from | Transaction Code Value Help | |
| ESH_TRANSACTION_TSTCT | view | from | CDS View for Transaction Code Texts (TSTCT) | |
| FCCX_V_TRAN_VH_P | view_entity | left_outer | Join REPOSRC with REPOLOAD | |
| FCCXC_V_BTTYPE_DET_P | view_entity | left_outer | View with param on FCCXC_BTTYPE_DET | |
| I_BizConfignChkTransacTxt | view_entity | from | BASIC | Business Configuration Check Transaction - Text |
| i_tstct | view_entity | from | Transaction Text | |
| p_aps_iam_app_srvc_usob | view_entity | left_outer | IAM: IAM App assigned services | |
| P_APS_IAM_BC_FIORI_APP_t | view_entity | inner | IAM: Fiori App - Text | |
| P_SU2X_HEAD_TR | view | left_outer | Kopfdaten zu Vorschlagswerten für Transaktionen | |
| P_SU2X_HEAD_TR_EXT | view | left_outer | Kopfdaten zu Vorschlagsdaten für Transaktion (Erweitert) | |
| p_tstc | view_entity | left_outer | Transaction (Private) |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Transaction Texts
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TSTCT (
SPRSL, -- Language [spras]
TCODE, -- Transaction Code [tcode]
TTEXT, -- Text [ttext_stct]
PRIMARY KEY (SPRSL, TCODE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA