I_MRPAreaPlanningFileEntry

DDL: I_MRPAREAPLANNINGFILEENTRY SQL: IMRPAREAPFE Type: view BASIC
21 Fields 1 Data Sources 5 Associations

MRP Area Planning File Entry

I_MRPAreaPlanningFileEntry (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_MRPAreaPlanningFileEntry is a Basic CDS View (Fact) that provides data about "MRP Area Planning File Entry" in SAP S/4HANA. It reads from 1 data source (pph_dbvm) and exposes 21 fields with key fields Material, Plant, MRPArea, MRPPlanningScenario. It has 5 associations to related views.

SAP Help Documentation

CategoryCDS Views for Material Requirements Planning
Data CategoryFACT
StatusReleased
Purpose
This CDS view selects planning file entries of an MRP area (table pph_dbvm ). This CDS view provides the data to answer the following business questions: Which planning file entries exist for an MRP area of a material? When was the last MRP run for a material in an MRP area carried out? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization object assigned: M_MTDI_ORG (Organizational Levels for Material Requirements Planning, authorization for activity categories A: “Stock/requirements list” or B: “Total planning” or E: “Single-item planning”)

Structure
Further important fields Important fields in this view include the following: Field Name Description Material Material Plant MRP Area Plant MRPArea MRP Area MRPPlanningScenario Planning Scenario MatlIsConsideredInNetChgPlng Indicator: Net Change Planning MatlNextTimePhasedPlanningDate Next Time-Phased Planning Date MaterialLastMRPDateTime MRP Timestamp MatlLastMRPRelevantChgDateTime Update Time Stamp PlanningFileEntryMessageClass Message identification PlanningFileEntryMessageType Message Type PlanningFileEntryMessageNumber System Message Number PlanningFileEntryMsgVarbl1Text Message variable 01 PlanningFileEntryMsgVarbl2Text Message variable 02 PlanningFileEntryMsgVarbl3Text Message variable 03 PlanningFileEntryMsgVarbl4Text Message variable 04 Depending on your configuration, some of the fields included in this CDS view may not expose any data.

Constraints
This CDS view selects only planning file entries that are relevant for automatic MRP and are not assigned to a subcontracting MRP area without MRP elements.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view selects planning file entries of an MRP area (table pph_dbvm). </p> This CDS view provides the data to answer the following business questions:<ul> <li><p>Which planning file entries exist for an MRP area of a material?</p></li> <li><p>When was the last MRP run for a material in an MRP area carried out?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
pph_dbvm d from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_Product _Material $projection.Material = _Material.Product
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_ProductPlantBasic _MaterialPlant $projection.Material = _MaterialPlant.Product and $projection.Plant = _MaterialPlant.Plant
[1..1] I_MRPArea _MRPArea $projection.MRPArea = _MRPArea.MRPArea
[0..1] I_MRPPlanningScenario _PlanningScenario $projection.MRPPlanningScenario = _PlanningScenario.MRPPlanningScenario

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IMRPAREAPFE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #FACT view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label MRP Area Planning File Entry view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Material pph_dbvm matnr Material Number
KEY Plant pph_dbvm werks Receiving Plant
KEY MRPArea pph_dbvm berid Single-Character Flag
KEY MRPPlanningScenario pph_dbvm plscn Planning Scenario in Long-Term Planning
MatlIsConsideredInNetChgPlng pph_dbvm gsaen Net Change Planning Indicator
PlanningFileEntryCreationDate
MatlNextTimePhasedPlanningDate Date for Time-Phased Planning
MaterialLastMRPDateTime pph_dbvm dstmp Timestamp of last MRP for Planning File Entry
MatlLastMRPRelevantChgDateTime pph_dbvm lstmp Time Stamp of First MRP-Relevant Change
PlanningFileEntryMessageClass msgid Message identification
PlanningFileEntryMessageType msgty Msg.Type (E,I,W..)
PlanningFileEntryMessageNumber msgno System Message Number
PlanningFileEntryMsgVarbl1Text msgv1 Message variable 01
PlanningFileEntryMsgVarbl2Text msgv2 Message variable 02
PlanningFileEntryMsgVarbl3Text msgv3 Message variable 03
PlanningFileEntryMsgVarbl4Text msgv4 Message variable 04
_Plant _Plant
_Material _Material
_MaterialPlant _MaterialPlant
_MRPArea _MRPArea
_PlanningScenario _PlanningScenario

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_MRPAreaPlanningFileEntry.
-- 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.
-- SQL view name: IMRPAREAPFE

CREATE VIEW I_MRPAreaPlanningFileEntry AS
SELECT
  d.matnr AS Material,
  d.werks AS Plant,
  d.berid AS MRPArea,
  d.plscn AS MRPPlanningScenario,
  d.gsaen AS MatlIsConsideredInNetChgPlng,
  cast(d.rhytd as vdm_rhytd preserving type) AS MatlNextTimePhasedPlanningDate,
  d.dstmp AS MaterialLastMRPDateTime,
  d.lstmp AS MatlLastMRPRelevantChgDateTime,
  msgid AS PlanningFileEntryMessageClass,
  msgty AS PlanningFileEntryMessageType,
  msgno AS PlanningFileEntryMessageNumber,
  msgv1 AS PlanningFileEntryMsgVarbl1Text,
  msgv2 AS PlanningFileEntryMsgVarbl2Text,
  msgv3 AS PlanningFileEntryMsgVarbl3Text,
  msgv4 AS PlanningFileEntryMsgVarbl4Text
FROM pph_dbvm AS d
LEFT OUTER JOIN I_Product AS _Material ON Material = _Material.Product  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _MaterialPlant ON Material = _MaterialPlant.Product AND Plant = _MaterialPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_MRPPlanningScenario AS _PlanningScenario ON MRPPlanningScenario = _PlanningScenario.MRPPlanningScenario  -- association [0..1]
;

Learn More