T501T

Transparent Table Customizing Table
4 Fields 2 CDS Views

Employee Group Names

T501T is an SAP database table in S/4HANA. Employee Group Names. It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_DFS_PositionEmployeeGrpText view from BASIC DFS Position Employee Group Text
I_HCMEmployeeGroupText view_entity from BASIC HCM Employee Group - Text

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sprsl SPRAS Language
KEY persg PERSG EE group
ptext PGTXT Name of EE grp

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.

-- Employee Group Names
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T501T (
    MANDT,  -- Client [MANDT]
    SPRSL,  -- Language [SPRAS]
    PERSG,  -- EE group [PERSG]
    PTEXT,  -- Name of EE grp [PGTXT]
    PRIMARY KEY (MANDT, SPRSL, PERSG)
);

Learn More