PMRP_FCAL

Transparent Table Application Table
8 Fields 1 CDS Views

pMRP Factory Calendar

PMRP_FCAL is an SAP database table in S/4HANA. pMRP Factory Calendar. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PMRPFactoryCalendar view from BASIC A factory calendar in pMRP

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY reference_id PMRP_REFERENCE_ID Reference Data
KEY fcal_id FABKL Factory Calend.
KEY day_date SYDATUM Current Date
productive_day FLAG Indicator
productive_days PMRP_PRODUCTIVE_DAYS pMRP: Number of Cumulated Productive Days
bucket_id PMRP_BUCKET_ID Bucket ID
bucket_first_pday FLAG Indicator

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 Factory Calendar
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PMRP_FCAL (
    MANDT,              -- Client [MANDT]
    REFERENCE_ID,       -- Reference Data [PMRP_REFERENCE_ID]
    FCAL_ID,            -- Factory Calend. [FABKL]
    DAY_DATE,           -- Current Date [SYDATUM]
    PRODUCTIVE_DAY,     -- Indicator [FLAG]
    PRODUCTIVE_DAYS,    -- pMRP: Number of Cumulated Productive Days [PMRP_PRODUCTIVE_DAYS]
    BUCKET_ID,          -- Bucket ID [PMRP_BUCKET_ID]
    BUCKET_FIRST_PDAY,  -- Indicator [FLAG]
    PRIMARY KEY (MANDT, REFERENCE_ID, FCAL_ID, DAY_DATE)
);

Learn More