VCH_SIM_SCH_SUPP

Transparent Table Application Table

Support table for searching in Simulation Environment

VCH_SIM_SCH_SUPP is an SAP database table in S/4HANA. Support table for searching in Simulation Environment. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SimulationSearchSupport view from BASIC Simulation - Simulation Search Support

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY salesdocument vbeln_va Sales Document
KEY salesdocumentitem posnr_va Item
KEY productionorder aufnr Order
KEY productionorderitem co_posnr Item Number
KEY productvariant matnr Material
variantconfigurationsimlnname vchclf_sim_name Simulation Name
variantconfigurationsimulation vchclf_sim_context_id Simulation Environment Context ID
purchasingdocument ebeln Purchasing Doc.
purchasingdocumentitem ebelp Item
purchaserequisition banfn Purchase Req.
purchaserequisitionitem bnfpo Requisn. item
varconfignsimlnexternalid vchclf_simulation_external_id Sim External Id

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.

-- Support table for searching in Simulation Environment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VCH_SIM_SCH_SUPP (
    MANDT,                           -- Client [mandt]
    SALESDOCUMENT,                   -- Sales Document [vbeln_va]
    SALESDOCUMENTITEM,               -- Item [posnr_va]
    PRODUCTIONORDER,                 -- Order [aufnr]
    PRODUCTIONORDERITEM,             -- Item Number [co_posnr]
    PRODUCTVARIANT,                  -- Material [matnr]
    VARIANTCONFIGURATIONSIMLNNAME,   -- Simulation Name [vchclf_sim_name]
    VARIANTCONFIGURATIONSIMULATION,  -- Simulation Environment Context ID [vchclf_sim_context_id]
    PURCHASINGDOCUMENT,              -- Purchasing Doc. [ebeln]
    PURCHASINGDOCUMENTITEM,          -- Item [ebelp]
    PURCHASEREQUISITION,             -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [bnfpo]
    VARCONFIGNSIMLNEXTERNALID,       -- Sim External Id [vchclf_simulation_external_id]
    PRIMARY KEY (MANDT, SALESDOCUMENT, SALESDOCUMENTITEM, PRODUCTIONORDER, PRODUCTIONORDERITEM, PRODUCTVARIANT)
);