VCH_SIMULATION

Transparent Table Application Table
24 Fields 2 CDS Views

Variant Configuration: Simulations

VCH_SIMULATION is an SAP database table in S/4HANA. Variant Configuration: Simulations. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_VariantConfigurationSimln view from BASIC Simulation Database Interface View
P_SavedSimulation view from BASIC

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY id VCHCLF_SAVED_SIM_UUID UUID
name VCHCLF_SIM_NAME Simulation Name
created_on VCHCLF_SIM_CREATED_ON Created On
changed_on VCHCLF_SIM_CHANGED_ON Changed On
created_by SYUNAME User Name
changed_by SYUNAME User Name
created_on_time VCHCLF_SIM_CREATED_ON_TIME Created On Time
changed_on_time VCHCLF_SIM_CHANGED_ON_TIME Changed On Time
simulation_external_id VCHCLF_SIMULATION_EXTERNAL_ID Sim External Id
application CAPID BOM Application
simulation_date DATS Date
quantity BASMN Base quantity
uom MEINS Base Unit
product MATNR Material
plant WERKS_D Plant
cuobj CUOBJ Int. object no.
status VCHCLF_SIMULATION_STATUS Status
configurationprofilecounter CUCOZHL Int. counter
simulation_context VCH_HL_SIMULATION_CONTEXT Sim Context
template_obj_cuobj CUOBJ Int. object no.
template_obj_type VCHCLF_OWNER_TYPE Owner Type
template_obj_id VCHCLF_SIM_CONF_OBJECT Simulation Environment: Simulation Configuration Object
template_obj_item_id VCHCLF_SIM_CONF_OBJECT_ITEM Object Item

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: Simulations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VCH_SIMULATION (
    MANDT,                        -- Client [MANDT]
    ID,                           -- UUID [VCHCLF_SAVED_SIM_UUID]
    NAME,                         -- Simulation Name [VCHCLF_SIM_NAME]
    CREATED_ON,                   -- Created On [VCHCLF_SIM_CREATED_ON]
    CHANGED_ON,                   -- Changed On [VCHCLF_SIM_CHANGED_ON]
    CREATED_BY,                   -- User Name [SYUNAME]
    CHANGED_BY,                   -- User Name [SYUNAME]
    CREATED_ON_TIME,              -- Created On Time [VCHCLF_SIM_CREATED_ON_TIME]
    CHANGED_ON_TIME,              -- Changed On Time [VCHCLF_SIM_CHANGED_ON_TIME]
    SIMULATION_EXTERNAL_ID,       -- Sim External Id [VCHCLF_SIMULATION_EXTERNAL_ID]
    APPLICATION,                  -- BOM Application [CAPID]
    SIMULATION_DATE,              -- Date [DATS]
    QUANTITY,                     -- Base quantity [BASMN]
    UOM,                          -- Base Unit [MEINS]
    PRODUCT,                      -- Material [MATNR]
    PLANT,                        -- Plant [WERKS_D]
    CUOBJ,                        -- Int. object no. [CUOBJ]
    STATUS,                       -- Status [VCHCLF_SIMULATION_STATUS]
    CONFIGURATIONPROFILECOUNTER,  -- Int. counter [CUCOZHL]
    SIMULATION_CONTEXT,           -- Sim Context [VCH_HL_SIMULATION_CONTEXT]
    TEMPLATE_OBJ_CUOBJ,           -- Int. object no. [CUOBJ]
    TEMPLATE_OBJ_TYPE,            -- Owner Type [VCHCLF_OWNER_TYPE]
    TEMPLATE_OBJ_ID,              -- Simulation Environment: Simulation Configuration Object [VCHCLF_SIM_CONF_OBJECT]
    TEMPLATE_OBJ_ITEM_ID,         -- Object Item [VCHCLF_SIM_CONF_OBJECT_ITEM]
    PRIMARY KEY (MANDT, ID)
);

Learn More