PMRP_REFERENCE

Transparent Table Application Table
16 Fields 1 CDS Views

pMRP Reference

PMRP_REFERENCE is an SAP database table in S/4HANA. pMRP Reference. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PMRPReferencePlan view_entity from BASIC A Reference Plan in predictive MRP

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reference_id pmrp_reference_id Reference Data
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
status pmrp_reference_status Reference Status
original_status pmrp_reference_org_status OrigReference Status
num_products int4 INT4
num_resources int4 INT4
num_sos int4 INT4
num_sos_input int4 INT4
num_sos_capreq int4 INT4
maximum_llc pmrp_low_level_code Low-Level Code
version_number pmrp_version_number Version Number
enable_costctr_planning boolean Boolean Variable (X = True, - = False, Space = Unknown)

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 Reference
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_REFERENCE (
    MANDT,                    -- Client [mandt]
    REFERENCE_ID,             -- Reference Data [pmrp_reference_id]
    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]
    STATUS,                   -- Reference Status [pmrp_reference_status]
    ORIGINAL_STATUS,          -- OrigReference Status [pmrp_reference_org_status]
    NUM_PRODUCTS,             -- INT4 [int4]
    NUM_RESOURCES,            -- INT4 [int4]
    NUM_SOS,                  -- INT4 [int4]
    NUM_SOS_INPUT,            -- INT4 [int4]
    NUM_SOS_CAPREQ,           -- INT4 [int4]
    MAXIMUM_LLC,              -- Low-Level Code [pmrp_low_level_code]
    VERSION_NUMBER,           -- Version Number [pmrp_version_number]
    ENABLE_COSTCTR_PLANNING,  -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PRIMARY KEY (MANDT, REFERENCE_ID)
);

Learn More