TDC_S_VAR

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

Variant

TDC_S_VAR is an SAP database table in S/4HANA. Variant. 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.

-- Variant
-- 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