VCH_SIM_DRAFT

Transparent Table Application Table
37 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 37 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_SavedSimulation view left_outer BASIC
P_SavedSimulation_Draft view from BASIC
P_VCH_SIM_DRAFTADMINDATA view from BASIC

Fields (37)

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
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More