VCH_SIM_DRAFT

Transparent Table Application Table
32 Fields 3 CDS Views

I_VARIANTCONFIGURATIONSIMLNTP I_VARIANTCONFIGURATIONSIMLNTP

VCH_SIM_DRAFT is an SAP database table in S/4HANA. I_VARIANTCONFIGURATIONSIMLNTP I_VARIANTCONFIGURATIONSIMLNTP. It contains 32 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_SavedSimulation view left_outer BASIC Simulation: Saved Simulaitons
P_SavedSimulation_Draft view from BASIC Simulation - Saved Simulations Draft
P_VCH_SIM_DRAFTADMINDATA view from BASIC Union of vch_simulation_d and i_draftadmindata

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
simulationuuid vchclf_saved_sim_uuid UUID
bomexplosionapplication capid BOM Application
lastchangedbyuser syuname User Name
lastchangedate vchclf_sim_changed_on Changed On
lastchangetime vchclf_sim_changed_on_time Changed On Time
configurationprofilecounter cucozhl Int. counter
createdbyuser syuname User Name
creationdate vchclf_sim_created_on Created On
creationtime vchclf_sim_created_on_time Created On Time
configurationnumber cuobj Int. object no.
name vchclf_sim_name Simulation Name
plant werks_d Plant
product matnr Material
quantity basmn Base quantity
configurationsimulationdate dats Date
templateconfigurationnumber cuobj Int. object no.
templateconfiguredobject vchclf_sim_conf_object Simulation Environment: Simulation Configuration Object
templateconfiguredobjectitem vchclf_sim_conf_object_item Object Item
templateconfiguredobjecttype vchclf_owner_type Owner Type
baseunit meins Base Unit
configurationtraceisactive flag Indicator
configurationtraceownerhandle vch_hl_trace_handle Trace Handle
configurationstatus vchclf_simulation_status Status
confignsimulationcontext vch_hl_simulation_context Sim Context
varconfignsimlnexternalid vchclf_simulation_external_id Sim External Id
productname productdescription Description
plantname werks_name Plant Name
createdbyuserdescription vdm_userdescription Description
lastchangedbyuserdescription vdm_userdescription Description
hasactiveentity sdraft_has_active Has active

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.

-- I_VARIANTCONFIGURATIONSIMLNTP I_VARIANTCONFIGURATIONSIMLNTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VCH_SIM_DRAFT (
    MANDT,                          -- Client [mandt]
    DRAFTUUID,                      -- Key [/bobf/uuid]
    SIMULATIONUUID,                 -- UUID [vchclf_saved_sim_uuid]
    BOMEXPLOSIONAPPLICATION,        -- BOM Application [capid]
    LASTCHANGEDBYUSER,              -- User Name [syuname]
    LASTCHANGEDATE,                 -- Changed On [vchclf_sim_changed_on]
    LASTCHANGETIME,                 -- Changed On Time [vchclf_sim_changed_on_time]
    CONFIGURATIONPROFILECOUNTER,    -- Int. counter [cucozhl]
    CREATEDBYUSER,                  -- User Name [syuname]
    CREATIONDATE,                   -- Created On [vchclf_sim_created_on]
    CREATIONTIME,                   -- Created On Time [vchclf_sim_created_on_time]
    CONFIGURATIONNUMBER,            -- Int. object no. [cuobj]
    NAME,                           -- Simulation Name [vchclf_sim_name]
    PLANT,                          -- Plant [werks_d]
    PRODUCT,                        -- Material [matnr]
    QUANTITY,                       -- Base quantity [basmn]
    CONFIGURATIONSIMULATIONDATE,    -- Date [dats]
    TEMPLATECONFIGURATIONNUMBER,    -- Int. object no. [cuobj]
    TEMPLATECONFIGUREDOBJECT,       -- Simulation Environment: Simulation Configuration Object [vchclf_sim_conf_object]
    TEMPLATECONFIGUREDOBJECTITEM,   -- Object Item [vchclf_sim_conf_object_item]
    TEMPLATECONFIGUREDOBJECTTYPE,   -- Owner Type [vchclf_owner_type]
    BASEUNIT,                       -- Base Unit [meins]
    CONFIGURATIONTRACEISACTIVE,     -- Indicator [flag]
    CONFIGURATIONTRACEOWNERHANDLE,  -- Trace Handle [vch_hl_trace_handle]
    CONFIGURATIONSTATUS,            -- Status [vchclf_simulation_status]
    CONFIGNSIMULATIONCONTEXT,       -- Sim Context [vch_hl_simulation_context]
    VARCONFIGNSIMLNEXTERNALID,      -- Sim External Id [vchclf_simulation_external_id]
    PRODUCTNAME,                    -- Description [productdescription]
    PLANTNAME,                      -- Plant Name [werks_name]
    CREATEDBYUSERDESCRIPTION,       -- Description [vdm_userdescription]
    LASTCHANGEDBYUSERDESCRIPTION,   -- Description [vdm_userdescription]
    HASACTIVEENTITY,                -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More