PMRP_PRODUCT

Transparent Table Application Table
7 Fields 3 CDS Views

pMRP Products

PMRP_PRODUCT is an SAP database table in S/4HANA. pMRP Products. It contains 7 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
DDL_PMRP_Prod_Rel view_entity inner Product Relations via SoS
DDL_PMRP_SoS_Flat view_entity inner SoS with output and all inputs and low level code
I_PMRPProduct view_entity from BASIC A product used in pMRP

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reference_id pmrp_reference_id Reference Data
KEY product matnr Material
KEY plant werks_d Plant
KEY mrparea berid MRP Area
low_level_code pmrp_low_level_code Low-Level Code
recursive rekri Recursive

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 Products
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_PRODUCT (
    MANDT,           -- Client [mandt]
    REFERENCE_ID,    -- Reference Data [pmrp_reference_id]
    PRODUCT,         -- Material [matnr]
    PLANT,           -- Plant [werks_d]
    MRPAREA,         -- MRP Area [berid]
    LOW_LEVEL_CODE,  -- Low-Level Code [pmrp_low_level_code]
    RECURSIVE,       -- Recursive [rekri]
    PRIMARY KEY (MANDT, REFERENCE_ID, PRODUCT, PLANT, MRPAREA)
);

Learn More