I_PMRPFactoryCalendar

DDL: I_PMRPFACTORYCALENDAR Type: view_entity BASIC Package: PMRP_ENGINE
5 Fields 1 Data Sources

A factory calendar in pMRP

I_PMRPFactoryCalendar is a Basic CDS View that provides data about "A factory calendar in pMRP" in SAP S/4HANA. It reads from 1 data source (pmrp_fcal) and exposes 5 fields with key fields PMRPReferencePlan, FactoryCalendar, CalendarDay. Part of development package PMRP_ENGINE.

Data Sources (1)

SourceAliasJoin Type
pmrp_fcal pmrp_fcal from

Annotations (6)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label A factory calendar in pMRP view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PMRPReferencePlan reference_id Reference No.
KEY FactoryCalendar fcal_id Factory Calend.
KEY CalendarDay day_date Date
BucketInternalID bucket_id Bucket ID
IsWorkingDay productive_day Indicator

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PMRPFactoryCalendar.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_PMRPFactoryCalendar AS
SELECT
  reference_id AS PMRPReferencePlan,
  fcal_id AS FactoryCalendar,
  day_date AS CalendarDay,
  bucket_id AS BucketInternalID,
  productive_day AS IsWorkingDay
FROM pmrp_fcal
;

Learn More