PMRP_BUCKET_DEF

Transparent Table Application Table
8 Fields 2 CDS Views

pMRP Buckets

PMRP_BUCKET_DEF is an SAP database table in S/4HANA. pMRP Buckets. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PMRPBucket view_entity from BASIC A bucket in pMRP
P_pMRPSimlnRsceGroupBucket view_entity inner BASIC pMRP resource group buckets

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reference_id pmrp_reference_id Reference Data
KEY bucket_id pmrp_bucket_id Bucket ID
first_day_date pmrp_bucket_start Start Date of Bucket
last_day_date pmrp_bucket_end End Date of Bucket
bucket_category pmrp_bucket_category Bucket Category
bucket_year pmrp_bucket_year Year of a Bucket
bucket_period pmrp_bucket_period Period of a Bucket

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 Buckets
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_BUCKET_DEF (
    MANDT,            -- Client [mandt]
    REFERENCE_ID,     -- Reference Data [pmrp_reference_id]
    BUCKET_ID,        -- Bucket ID [pmrp_bucket_id]
    FIRST_DAY_DATE,   -- Start Date of Bucket [pmrp_bucket_start]
    LAST_DAY_DATE,    -- End Date of Bucket [pmrp_bucket_end]
    BUCKET_CATEGORY,  -- Bucket Category [pmrp_bucket_category]
    BUCKET_YEAR,      -- Year of a Bucket [pmrp_bucket_year]
    BUCKET_PERIOD,    -- Period of a Bucket [pmrp_bucket_period]
    PRIMARY KEY (MANDT, REFERENCE_ID, BUCKET_ID)
);

Learn More