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_entity 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