PMRP_RECEIPT

Transparent Table Application Table
26 Fields 1 CDS Views

pMRP Receipt

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PMRPReceiptBasic view from BASIC Receipt used in pMRP

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY receipt_id pmrp_receipt_id Receipt ID
KEY simulation_id pmrp_simulation_id Simulation ID
product matnr Material
plant werks_d Plant
mrparea berid MRP Area
receipt_category pmrp_order_category Order Category
rec_start_date pmrp_receipt_start_date Receipt Start Date
rec_end_date pmrp_receipt_end_date Receipt End Date
rec_supply_end_date pmrp_receipt_supply_end_date Supply End Date
req_quantity pmrp_req_quantity Required Quantity
receipt_quantity pmrp_receipt_quantity Receipt Quantity
preprod_quan pmrp_preproduction_quan Pull-In Quantity
uom meins Base Unit
bucket_workdays pmrp_receipt_valid_days Prod Days Receipt
total_workdays pmrp_requirement_prod_days ProdDays Requirement
quot_factor pmrp_quot_factor Quota Percent
quot_factor_nom pmrp_quot_factor_nom Quota Nominator
quot_factor_denom pmrp_quot_factor_denom Quota Denom
sos_id pmrp_sos_id Source of Supply ID
aggr_quot_factor_nom pmrp_agg_quot_factor_nom Quota Nominator
aggr_quot_factor_denom pmrp_agg_quot_factor_denom Quota Denominator
pegged_rqmt_id pmrp_rqmt_id Requirement ID
tld_id pmrp_sim_tld_id Top-Level Demand ID
creation_type pmrp_order_creation_type Creation Type
scale_factor_tld pmrp_scale_factor_tld Scale from Top Level Domain to Element

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 Receipt
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_RECEIPT (
    MANDT,                   -- Client [mandt]
    RECEIPT_ID,              -- Receipt ID [pmrp_receipt_id]
    SIMULATION_ID,           -- Simulation ID [pmrp_simulation_id]
    PRODUCT,                 -- Material [matnr]
    PLANT,                   -- Plant [werks_d]
    MRPAREA,                 -- MRP Area [berid]
    RECEIPT_CATEGORY,        -- Order Category [pmrp_order_category]
    REC_START_DATE,          -- Receipt Start Date [pmrp_receipt_start_date]
    REC_END_DATE,            -- Receipt End Date [pmrp_receipt_end_date]
    REC_SUPPLY_END_DATE,     -- Supply End Date [pmrp_receipt_supply_end_date]
    REQ_QUANTITY,            -- Required Quantity [pmrp_req_quantity]
    RECEIPT_QUANTITY,        -- Receipt Quantity [pmrp_receipt_quantity]
    PREPROD_QUAN,            -- Pull-In Quantity [pmrp_preproduction_quan]
    UOM,                     -- Base Unit [meins]
    BUCKET_WORKDAYS,         -- Prod Days Receipt [pmrp_receipt_valid_days]
    TOTAL_WORKDAYS,          -- ProdDays Requirement [pmrp_requirement_prod_days]
    QUOT_FACTOR,             -- Quota Percent [pmrp_quot_factor]
    QUOT_FACTOR_NOM,         -- Quota Nominator [pmrp_quot_factor_nom]
    QUOT_FACTOR_DENOM,       -- Quota Denom [pmrp_quot_factor_denom]
    SOS_ID,                  -- Source of Supply ID [pmrp_sos_id]
    AGGR_QUOT_FACTOR_NOM,    -- Quota Nominator [pmrp_agg_quot_factor_nom]
    AGGR_QUOT_FACTOR_DENOM,  -- Quota Denominator [pmrp_agg_quot_factor_denom]
    PEGGED_RQMT_ID,          -- Requirement ID [pmrp_rqmt_id]
    TLD_ID,                  -- Top-Level Demand ID [pmrp_sim_tld_id]
    CREATION_TYPE,           -- Creation Type [pmrp_order_creation_type]
    SCALE_FACTOR_TLD,        -- Scale from Top Level Domain to Element [pmrp_scale_factor_tld]
    PRIMARY KEY (MANDT, RECEIPT_ID, SIMULATION_ID)
);

Learn More