SAP VCH_SIMULATION Variant Configuration: Simulations Table
Overview
VCH_SIMULATION is a standard SAP S/4HANA table that stores Variant Configuration: Simulations data. There are total 23 fields in the VCH_SIMULATION table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VCH_SIMULATION belongs to Simulation environment of VC on HANA (LO-VCH-FIO-SIM) module and is located in the package OData Service - Simulation Environment (ODATA_LO_VCHCLF_SIMULATION).
In addition, following links provide an overview of foreign key relationships, if any, that link VCH_SIMULATION to other SAP tables and standard CDS views available based on VCH_SIMULATION table in S/4HANA 2020.
Techincal Settings of VCH_SIMULATION
Below are technical details of the table VCH_SIMULATION
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VCH_SIMULATION Fields
The following table gives you an overview of the fields available in VCH_SIMULATION
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| NAME | Simulation Environment: Simulation name | VCHCLF_SIM_NAME | CHAR | 80 | |
| CREATED_ON | Simulaiton: Created On | VCHCLF_SIM_CREATED_ON | DATS | 8 | |
| CHANGED_ON | Simulation: Changed On | VCHCLF_SIM_CHANGED_ON | DATS | 8 | |
| CREATED_BY | User Name | SYUNAME | CHAR | 12 | |
| CHANGED_BY | User Name | SYUNAME | CHAR | 12 | |
| CREATED_ON_TIME | Simulaiton: Created On Time | VCHCLF_SIM_CREATED_ON_TIME | TIMS | 6 | |
| CHANGED_ON_TIME | Simulation: Changed On Time | VCHCLF_SIM_CHANGED_ON_TIME | TIMS | 6 | |
| SIMULATION_EXTERNAL_ID | Simulation: External ID | VCHCLF_SIMULATION_EXTERNAL_ID | CHAR | 40 | |
| APPLICATION | Application | CAPID | * | CHAR | 4 |
| SIMULATION_DATE | Field of type DATS | DATS | DATS | 8 | |
| QUANTITY | Base quantity | BASMN | QUAN | 13 | |
| UOM | Base Unit of Measure | MEINS | * | UNIT | 3 |
| PRODUCT | Material Number | MATNR | CHAR | 40 | |
| PLANT | Plant | WERKS_D | CHAR | 4 | |
| CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | |
| STATUS | Simulation Environment: Status | VCHCLF_SIMULATION_STATUS | CHAR | 1 | |
| CONFIGURATIONPROFILECOUNTER | Internal counter | CUCOZHL | NUMC | 4 | |
| SIMULATION_CONTEXT | Variant Configuration: Simulation Context | VCH_HL_SIMULATION_CONTEXT | CHAR | 30 | |
| TEMPLATE_OBJ_CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | |
| TEMPLATE_OBJ_TYPE | Variant Configuration: Owner Type | VCHCLF_OWNER_TYPE | CHAR | 4 | |
| TEMPLATE_OBJ_ID | Simulation Environment: Simulation Configuration Object | VCHCLF_SIM_CONF_OBJECT | CHAR | 40 | |
| TEMPLATE_OBJ_ITEM_ID | Simulation Environment: Simulation Configuration Object Item | VCHCLF_SIM_CONF_OBJECT_ITEM | CHAR | 6 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VCH_SIMULATION