_SIMULATION

_SIMULATION is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
CapacityCriticality CapacityCriticality 1
CapacityIssueTrend CapacityIssueTrend 1
ConstraintIssuesCriticality ConstraintIssuesCriticality 1
ConstraintIssuesTrend ConstraintIssuesTrend 1
DeliveryPerformanceCriticality DeliveryPerformanceCriticality 1
DeliveryPerformanceTrend DeliveryPerformanceTrend 1
DeliveryPerformanceUnit DeliveryPerformanceUnit 1
InvalidSourceOfSupplyTrend InvalidSourceOfSupplyTrend 1
InvalidSrceOfSupCriticality InvalidSrceOfSupCriticality 1
NumberOfCapacityIssues NumberOfCapacityIssues 1
NumberOfProductsWithMissingSOS NumberOfProductsWithMissingSOS 1
PMRPNumberOfBuckets PMRPNumberOfBuckets 1
PMRPNumberOfConstraintIssues PMRPNumberOfConstraintIssues 1
PMRPPrevNmbrOfConstraintIssues PMRPPrevNmbrOfConstraintIssues 1
PMRPReferencePlan PMRPReferencePlan 8
PMRPReferencePlanDescription PMRPReferencePlanDescription 1
PMRPSimulationDescription PMRPSimulationDescription 1
PMRPSimulationStatus PMRPSimulationStatus 2
PMRPSimulationStatusName PMRPSimulationStatusName 1
PreviousNumberOfCapacityIssues PreviousNumberOfCapacityIssues 1
PreviousUndrdelivRatioInPct PreviousUndrdelivRatioInPct 1
PrevNmbrOfProdsWithMissingSOS PrevNmbrOfProdsWithMissingSOS 1
SimulationStatusCriticality SimulationStatusCriticality 1
TopLvlDmndUndrdelivRatioInPct TopLvlDmndUndrdelivRatioInPct 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _SIMULATION (
    CAPACITYCRITICALITY,
    CAPACITYISSUETREND,
    CONSTRAINTISSUESCRITICALITY,
    CONSTRAINTISSUESTREND,
    DELIVERYPERFORMANCECRITICALITY,
    DELIVERYPERFORMANCETREND,
    DELIVERYPERFORMANCEUNIT,
    INVALIDSOURCEOFSUPPLYTREND,
    INVALIDSRCEOFSUPCRITICALITY,
    NUMBEROFCAPACITYISSUES,
    NUMBEROFPRODUCTSWITHMISSINGSOS,
    PMRPNUMBEROFBUCKETS,
    PMRPNUMBEROFCONSTRAINTISSUES,
    PMRPPREVNMBROFCONSTRAINTISSUES,
    PMRPREFERENCEPLAN,
    PMRPREFERENCEPLANDESCRIPTION,
    PMRPSIMULATIONDESCRIPTION,
    PMRPSIMULATIONSTATUS,
    PMRPSIMULATIONSTATUSNAME,
    PREVIOUSNUMBEROFCAPACITYISSUES,
    PREVIOUSUNDRDELIVRATIOINPCT,
    PREVNMBROFPRODSWITHMISSINGSOS,
    SIMULATIONSTATUSCRITICALITY,
    TOPLVLDMNDUNDRDELIVRATIOINPCT
);