PMRP_SIMULATION

Transparent Table Application Table
26 Fields 4 CDS Views

pMRP Simulation

PMRP_SIMULATION is an SAP database table in S/4HANA. pMRP Simulation. It contains 26 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_PMRPSimulation view_entity from BASIC A Simulation in predictive MRP
I_PMRPSimulationResource view_entity from BASIC Resource in pMRP Simulation
P_PMRPSIMLNRSCEGROUP1 view from BASIC
P_PMRPSIMLNRSCEGROUP1 view union_all BASIC

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY simulation_id PMRP_SIMULATION_ID Simulation ID
reference_id PMRP_REFERENCE_ID Reference Data
status PMRP_SIMULATION_STATUS Simulation Status
original_status PMRP_SIMULATION_ORG_STATUS OrgSimulation Status
created_by PMRP_CREATED_BY Created By
created_on PMRP_CREATED_ON Created On
changed_by PMRP_CHANGED_BY Changed By
changed_on PMRP_CHANGED_ON Changed On
num_elements INT4 INT4
num_constraints INT4 INT4
num_capa_overloads PMRP_NUM_CAPA_OVERLOADS Capacity Overloads
prev_num_capa_overloads PMRP_PREV_NUM_CAPA_OVERLOADS Prv Cap Overloads
delivery_performance PMRP_DELVRY_PERF Delivery Performance
prev_delivery_performance PMRP_PREV_DELVRY_PERF Prv Delivery Perf
runtime_simu_create TZNTSTMPL Time Stamp
runtime_last_plng_action TZNTSTMPL Time Stamp
num_orders_changed_last INT4 INT4
resource_overload_tolerance PMRP_RES_OVERLOAD_TOLERANCE Overload Tolerance
num_product_no_sos PMRP_NUM_PRODUCT_NO_SOS NumProductsNoSoS
prev_num_product_no_sos PMRP_PREV_NUM_PRODUCT_NO_SOS PrevNumProductsNoSoS
num_product_out_of_bounds PMRP_NUM_PRODUCT_OUT_OF_BOUNDS NumProductsOutofBoun
prev_num_product_out_of_bounds PMRP_PRENUM_PROD_OUT_OF_BOUNDS PNumProductsOutofBou
num_constraint_violations PMRP_NUMBER_OF_CONSTR_ISS Violations
prev_num_constraint_violations PMRP_PREV_NUMBER_OF_CONSTR_ISS Violations
version_number PMRP_VERSION_NUMBER Version Number

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.

-- pMRP Simulation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_SIMULATION (
    MANDT,                           -- Client [MANDT]
    SIMULATION_ID,                   -- Simulation ID [PMRP_SIMULATION_ID]
    REFERENCE_ID,                    -- Reference Data [PMRP_REFERENCE_ID]
    STATUS,                          -- Simulation Status [PMRP_SIMULATION_STATUS]
    ORIGINAL_STATUS,                 -- OrgSimulation Status [PMRP_SIMULATION_ORG_STATUS]
    CREATED_BY,                      -- Created By [PMRP_CREATED_BY]
    CREATED_ON,                      -- Created On [PMRP_CREATED_ON]
    CHANGED_BY,                      -- Changed By [PMRP_CHANGED_BY]
    CHANGED_ON,                      -- Changed On [PMRP_CHANGED_ON]
    NUM_ELEMENTS,                    -- INT4 [INT4]
    NUM_CONSTRAINTS,                 -- INT4 [INT4]
    NUM_CAPA_OVERLOADS,              -- Capacity Overloads [PMRP_NUM_CAPA_OVERLOADS]
    PREV_NUM_CAPA_OVERLOADS,         -- Prv Cap Overloads [PMRP_PREV_NUM_CAPA_OVERLOADS]
    DELIVERY_PERFORMANCE,            -- Delivery Performance [PMRP_DELVRY_PERF]
    PREV_DELIVERY_PERFORMANCE,       -- Prv Delivery Perf [PMRP_PREV_DELVRY_PERF]
    RUNTIME_SIMU_CREATE,             -- Time Stamp [TZNTSTMPL]
    RUNTIME_LAST_PLNG_ACTION,        -- Time Stamp [TZNTSTMPL]
    NUM_ORDERS_CHANGED_LAST,         -- INT4 [INT4]
    RESOURCE_OVERLOAD_TOLERANCE,     -- Overload Tolerance [PMRP_RES_OVERLOAD_TOLERANCE]
    NUM_PRODUCT_NO_SOS,              -- NumProductsNoSoS [PMRP_NUM_PRODUCT_NO_SOS]
    PREV_NUM_PRODUCT_NO_SOS,         -- PrevNumProductsNoSoS [PMRP_PREV_NUM_PRODUCT_NO_SOS]
    NUM_PRODUCT_OUT_OF_BOUNDS,       -- NumProductsOutofBoun [PMRP_NUM_PRODUCT_OUT_OF_BOUNDS]
    PREV_NUM_PRODUCT_OUT_OF_BOUNDS,  -- PNumProductsOutofBou [PMRP_PRENUM_PROD_OUT_OF_BOUNDS]
    NUM_CONSTRAINT_VIOLATIONS,       -- Violations [PMRP_NUMBER_OF_CONSTR_ISS]
    PREV_NUM_CONSTRAINT_VIOLATIONS,  -- Violations [PMRP_PREV_NUMBER_OF_CONSTR_ISS]
    VERSION_NUMBER,                  -- Version Number [PMRP_VERSION_NUMBER]
    PRIMARY KEY (MANDT, SIMULATION_ID)
);

Learn More