TJ30T

Transparent Table Customizing Table
7 Fields 4 CDS Views

Texts for User Status

TJ30T is an SAP database table in S/4HANA. Texts for User Status. It contains 7 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_GHOUserStatusProfile view_entity from BASIC Status Profile of User status
I_UserStatusText view from BASIC User Status - Text
ISU_C4C_NTFST_V view inner Notification status
P_SDDocControllingObjectStsT1 view from BASIC

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY stsma J_STSMA Status Profile
KEY estat J_ESTAT User status
KEY spras SPRAS Language
txt04 J_TXT04 Status
txt30 J_TXT30 Status
ltext J_LANGTEXT Long tx. exists

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.

-- Texts for User Status
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TJ30T (
    MANDT,  -- Client [MANDT]
    STSMA,  -- Status Profile [J_STSMA]
    ESTAT,  -- User status [J_ESTAT]
    SPRAS,  -- Language [SPRAS]
    TXT04,  -- Status [J_TXT04]
    TXT30,  -- Status [J_TXT30]
    LTEXT,  -- Long tx. exists [J_LANGTEXT]
    PRIMARY KEY (MANDT, STSMA, ESTAT, SPRAS)
);

Learn More