VARID

Transparent Table Control Table (SAP+Cust)

Variant directory

VARID is an SAP database table in S/4HANA. Variant directory. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FCCX_V_VARHD view_entity from Report Variants (SM37)
FCCX_V_VARHD_P view_entity from Report Variants (SM37)

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY report VARI_REPRT Report Name
KEY variant VARIANT Variant
KEY flag1 SYCHAR01 CHAR01 data element for SYST
KEY flag2 SYCHAR01 CHAR01 data element for SYST
transport VARI_TRANS Transport
environmnt VARID_ENV Environment
protected RSSCR_CFLG Indicator
secu SECU Authorization Group
version VARID_VERS Version number
ename UNAME User Name
edat SYDATS (8-character) Date for SYST
etime SYTIME TIME Data Element for SYST
aename UNAME User Name
aedat SYDATS (8-character) Date for SYST
aetime SYTIME TIME Data Element for SYST
mlangu LANGU Language
xflag1 VARID_XFLG Indicator
xflag2 VARID_XFLG Indicator

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.

-- Variant directory
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VARID (
    MANDT,       -- Client [MANDT]
    REPORT,      -- Report Name [VARI_REPRT]
    VARIANT,     -- Variant [VARIANT]
    FLAG1,       -- CHAR01 data element for SYST [SYCHAR01]
    FLAG2,       -- CHAR01 data element for SYST [SYCHAR01]
    TRANSPORT,   -- Transport [VARI_TRANS]
    ENVIRONMNT,  -- Environment [VARID_ENV]
    PROTECTED,   -- Indicator [RSSCR_CFLG]
    SECU,        -- Authorization Group [SECU]
    VERSION,     -- Version number [VARID_VERS]
    ENAME,       -- User Name [UNAME]
    EDAT,        -- (8-character) Date for SYST [SYDATS]
    ETIME,       -- TIME Data Element for SYST [SYTIME]
    AENAME,      -- User Name [UNAME]
    AEDAT,       -- (8-character) Date for SYST [SYDATS]
    AETIME,      -- TIME Data Element for SYST [SYTIME]
    MLANGU,      -- Language [LANGU]
    XFLAG1,      -- Indicator [VARID_XFLG]
    XFLAG2,      -- Indicator [VARID_XFLG]
    PRIMARY KEY (MANDT, REPORT, VARIANT, FLAG1, FLAG2)
);