PMRP_RCPT_BCKT

Transparent Table Application Table
21 Fields 1 CDS Views

Bucket values of Receipts

PMRP_RCPT_BCKT is an SAP database table in S/4HANA. Bucket values of Receipts. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PMRPSimlnReceiptBucketBasic view_entity from BASIC

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pmrpsimulation PMRP_SIMULATION_ID Simulation ID
KEY pmrpnodeid PMRP_RECEIPT_ID Receipt ID
bucketinternalid PMRP_BUCKET_ID Bucket ID
product MATNR Material
product_group_id PMRP_FLEXCON_ID Constraints ID
plant WERKS_D Plant
mrparea BERID MRP Area
pmrpsourceofsupplyinternalid PMRP_SOS_ID Source of Supply ID
receiptinternalid PMRP_RECEIPT_ID Receipt ID
pmrpsupplygroup PMRP_SUPPLY_GRP Supply Group
pmrpsupplygroupcategory PMRP_SUPPLY_GRP_CATEGORY Supply Group Cat
pmrpflexibleconstraint PMRP_FLEXCON_ID Constraints ID
quantity PMRP_REQ_QUANTITY Required Quantity
unitofmeasure PMRP_DISPLAY_UOM Displayed UoM
topleveldemandinternalid PMRP_SIM_TLD_ID Top-Level Demand ID
working_days_in_bucket PMRP_RCPT_BUCKET_DAYS Duration in Bucket
working_days_of_receipt PMRP_REQUIREMENT_PROD_DAYS ProdDays Requirement
umrez UMREZ Numerator
umren UMREN Denominator
constraint_scope PMRP_CONSTRAINT_SCOPE Constraint Scope

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.

-- Bucket values of Receipts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_RCPT_BCKT (
    MANDT,                         -- Client [MANDT]
    PMRPSIMULATION,                -- Simulation ID [PMRP_SIMULATION_ID]
    PMRPNODEID,                    -- Receipt ID [PMRP_RECEIPT_ID]
    BUCKETINTERNALID,              -- Bucket ID [PMRP_BUCKET_ID]
    PRODUCT,                       -- Material [MATNR]
    PRODUCT_GROUP_ID,              -- Constraints ID [PMRP_FLEXCON_ID]
    PLANT,                         -- Plant [WERKS_D]
    MRPAREA,                       -- MRP Area [BERID]
    PMRPSOURCEOFSUPPLYINTERNALID,  -- Source of Supply ID [PMRP_SOS_ID]
    RECEIPTINTERNALID,             -- Receipt ID [PMRP_RECEIPT_ID]
    PMRPSUPPLYGROUP,               -- Supply Group [PMRP_SUPPLY_GRP]
    PMRPSUPPLYGROUPCATEGORY,       -- Supply Group Cat [PMRP_SUPPLY_GRP_CATEGORY]
    PMRPFLEXIBLECONSTRAINT,        -- Constraints ID [PMRP_FLEXCON_ID]
    QUANTITY,                      -- Required Quantity [PMRP_REQ_QUANTITY]
    UNITOFMEASURE,                 -- Displayed UoM [PMRP_DISPLAY_UOM]
    TOPLEVELDEMANDINTERNALID,      -- Top-Level Demand ID [PMRP_SIM_TLD_ID]
    WORKING_DAYS_IN_BUCKET,        -- Duration in Bucket [PMRP_RCPT_BUCKET_DAYS]
    WORKING_DAYS_OF_RECEIPT,       -- ProdDays Requirement [PMRP_REQUIREMENT_PROD_DAYS]
    UMREZ,                         -- Numerator [UMREZ]
    UMREN,                         -- Denominator [UMREN]
    CONSTRAINT_SCOPE,              -- Constraint Scope [PMRP_CONSTRAINT_SCOPE]
    PRIMARY KEY (MANDT, PMRPSIMULATION, PMRPNODEID)
);

Learn More