TDC_S_VAR

Transparent Table System Table (SAP only)
13 Fields 2 CDS Views

TDC Table for Variant name & desc

TDC_S_VAR is an SAP database table in S/4HANA. TDC Table for Variant name & desc. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TDAContainerNumberOfVariant view_entity from COMPOSITE Count of standard and custom variants
I_TDAContainerVariant view_entity union_all BASIC Interface for Container Variant

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY var_id TDC_VARIANT_GUID TDC Variant GUID
tdc_id TDC_CONTAINER_GUID TDC container GUID
variant_name TDC_VARIANT_NAME TDC variant name
variant_type TDC_VARIANT_TYPE Variant Type
variant_desc TDC_VARIANT_DESC TDC variant desc.
country START_DTE_COUNTRY Country/Region
language START_DTE_LANGUAGE Language
company_code BUKRS Company Code
created_on TDC_VARIANT_CREATE_ON Variant created on
created_by ERNAME Created by
changed_on TDC_VARIANT_CHANGE_ON Variant Changed on
changed_by ERNAME Created by
default_var_flag DEFAULT_VAR_FLAG Default TDC Var Flag

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.

-- TDC Table for Variant name & desc
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TDC_S_VAR (
    VAR_ID,            -- TDC Variant GUID [TDC_VARIANT_GUID]
    TDC_ID,            -- TDC container GUID [TDC_CONTAINER_GUID]
    VARIANT_NAME,      -- TDC variant name [TDC_VARIANT_NAME]
    VARIANT_TYPE,      -- Variant Type [TDC_VARIANT_TYPE]
    VARIANT_DESC,      -- TDC variant desc. [TDC_VARIANT_DESC]
    COUNTRY,           -- Country/Region [START_DTE_COUNTRY]
    LANGUAGE,          -- Language [START_DTE_LANGUAGE]
    COMPANY_CODE,      -- Company Code [BUKRS]
    CREATED_ON,        -- Variant created on [TDC_VARIANT_CREATE_ON]
    CREATED_BY,        -- Created by [ERNAME]
    CHANGED_ON,        -- Variant Changed on [TDC_VARIANT_CHANGE_ON]
    CHANGED_BY,        -- Created by [ERNAME]
    DEFAULT_VAR_FLAG,  -- Default TDC Var Flag [DEFAULT_VAR_FLAG]
    PRIMARY KEY (VAR_ID)
);

Learn More