T502T

Transparent Table Customizing Table
4 Fields 2 CDS Views

Marital Status Designators

T502T is an SAP database table in S/4HANA. Marital Status Designators. It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_HCMMaritalStatusVH view_entity from BASIC Marital Status
PiqCds_StudentData view left_outer Student Data CDS VIew

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sprsl SPRAS Language
KEY famst FAMST Marital stat.
ftext FATXT Marital status

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.

-- Marital Status Designators
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T502T (
    MANDT,  -- Client [MANDT]
    SPRSL,  -- Language [SPRAS]
    FAMST,  -- Marital stat. [FAMST]
    FTEXT,  -- Marital status [FATXT]
    PRIMARY KEY (MANDT, SPRSL, FAMST)
);

Learn More