TDC_A_VAR

Transparent Table Application Table
14 Fields 3 CDS Views

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)
);

Learn More