TJ02T
System status texts
TJ02T is an SAP database table in S/4HANA. System status texts. It contains 4 fields. 19 CDS views read from this table.
CDS Views using this table (19)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| AMITRSTAT_CDS | view | left_outer | ||
| I_ACMApplDocStatusVH | view_entity | from | BASIC | Application Document Status |
| I_ACMApplSettlementStatusVH | view_entity | inner | BASIC | App Doc Settlement Status |
| I_ApplicationStatusValueHelp | view | inner | BASIC | Application Status Details |
| I_CmmdtyHdgSpecStatusText | view_entity | from | BASIC | Commodity Hedge Specification Status - Text |
| I_CmmdtyHdgTgtQuotaStatusText | view_entity | from | BASIC | CMM Hedge Target Quota Status - Text |
| I_CmmdtyTargetQuotaStatusText | view_entity | from | BASIC | Commodity Hedge Specification Status - Text |
| I_GrantStatusText | view | from | BASIC | Grant Status - Text |
| I_InternalOrderSystemStatusT | view | from | BASIC | Internal Order System Status Text |
| I_MeterReadingTransferStsText | view | from | BASIC | Meter Reading Transfer Status - Text |
| I_SettlementStatusVH | view | inner | BASIC | Basic layer for Settlement Status |
| I_SystemStatusText | view | from | BASIC | System Status - Text |
| ISU_C4C_NTFST_SY_V | view | inner | Notification system status | |
| P_Bcmitem | view | left_outer | BASIC | Analyze Payment Detail BCM Item |
| P_EWM_DELIVERYSTATUSTEXT | view | from | BASIC | |
| P_EWM_SystemStatusText | view | from | BASIC | |
| P_SDDocControllingObjectStsT2 | view | from | BASIC | |
| VFCP_DDL_BCM | view | left_outer | ||
| VFCP_DDL_BCM | view | inner |
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.
-- System status texts
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TJ02T (
ISTAT, -- System status [J_ISTAT]
SPRAS, -- Language [SPRAS]
TXT04, -- Status [J_TXT04]
TXT30, -- Status [J_TXT30]
PRIMARY KEY (ISTAT, SPRAS)
);
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