TDC_A_VAR

Transparent Table Application Table

TDC Table for Variant name & description

TDC_A_VAR is an SAP database table in S/4HANA. TDC Table for Variant name & description. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_TDAContainerNumberOfVariant view_entity union_all COMPOSITE Count of standard and custom variants
I_TDAContainerNumberOfVariants view_entity from COMPOSITE Basic count for container variant
I_TDAContainerVariant view_entity from BASIC Interface for Container Variant

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
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 & description
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TDC_A_VAR (
    MANDT,             -- Client [mandt]
    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 (MANDT, VAR_ID)
);