VCH_TEMPLATE

Transparent Table Application Table
16 Fields 1 CDS Views

Variant Configuration Templates

VCH_TEMPLATE is an SAP database table in S/4HANA. Variant Configuration Templates. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_VarCnfTemplateBasic view_entity from BASIC Variant Configuration Template Basic

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY id vch_tmplt_uuid
name vch_tmplt_name
description vch_tmplt_description
product matnr Material
plant werks_d Plant
explosion_date datum Date
quantity_amount vch_tmplt_quantity_amount
quantity_unit vch_tmplt_quantity_unit
quantity_unit_iso isocd_unit ISO Code
cuobj cuobj Int. object no.
created_by vch_tmplt_created_by
created_on vch_tmplt_created_on
last_changed_by vch_tmplt_changed_by
last_changed_on vch_tmplt_changed_on
last_change_date_time timestampl Time Stamp

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 Configuration Templates
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VCH_TEMPLATE (
    MANDT,                  -- Client [mandt]
    ID,                     -- vch_tmplt_uuid
    NAME,                   -- vch_tmplt_name
    DESCRIPTION,            -- vch_tmplt_description
    PRODUCT,                -- Material [matnr]
    PLANT,                  -- Plant [werks_d]
    EXPLOSION_DATE,         -- Date [datum]
    QUANTITY_AMOUNT,        -- vch_tmplt_quantity_amount
    QUANTITY_UNIT,          -- vch_tmplt_quantity_unit
    QUANTITY_UNIT_ISO,      -- ISO Code [isocd_unit]
    CUOBJ,                  -- Int. object no. [cuobj]
    CREATED_BY,             -- vch_tmplt_created_by
    CREATED_ON,             -- vch_tmplt_created_on
    LAST_CHANGED_BY,        -- vch_tmplt_changed_by
    LAST_CHANGED_ON,        -- vch_tmplt_changed_on
    LAST_CHANGE_DATE_TIME,  -- Time Stamp [timestampl]
    PRIMARY KEY (MANDT, ID)
);

Learn More