I_MRPAreaPlanningFileEntry

DDL: I_MRPAREAPLANNINGFILEENTRY SQL: IMRPAREAPFE Type: view BASIC

MRP Area Planning File Entry

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.

1 data source(s) 21 fields

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
KEY Plant pph_dbvm werks
KEY MRPArea pph_dbvm berid
KEY MRPPlanningScenario pph_dbvm plscn
MatlIsConsideredInNetChgPlng pph_dbvm gsaen
PlanningFileEntryCreationDate
MatlNextTimePhasedPlanningDate
MaterialLastMRPDateTime pph_dbvm dstmp
MatlLastMRPRelevantChgDateTime pph_dbvm lstmp
PlanningFileEntryMessageClass msgid
PlanningFileEntryMessageType msgty
PlanningFileEntryMessageNumber msgno
PlanningFileEntryMsgVarbl1Text msgv1
PlanningFileEntryMsgVarbl2Text msgv2
PlanningFileEntryMsgVarbl3Text msgv3
PlanningFileEntryMsgVarbl4Text msgv4
_Plant _Plant
_Material _Material
_MaterialPlant _MaterialPlant
_MRPArea _MRPArea
_PlanningScenario _PlanningScenario 
@AbapCatalog.sqlViewName: 'IMRPAREAPFE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Analytics.dataCategory: #FACT
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'MRP Area Planning File Entry'

define view I_MRPAreaPlanningFileEntry
  as select from pph_dbvm as d

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

{
      // Key elements

      @ObjectModel.foreignKey.association: '_Material'
  key d.matnr                                    as Material,
      @ObjectModel.foreignKey.association: '_Plant'
  key d.werks                                    as Plant,
      @ObjectModel.foreignKey.association: '_MRPArea'
  key d.berid                                    as MRPArea,
      @ObjectModel.foreignKey.association: '_PlanningScenario'
  key d.plscn                                    as MRPPlanningScenario,

      d.gsaen                                    as MatlIsConsideredInNetChgPlng,
      --    d.erdat                                    as PlanningFileEntryCreationDate,
      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,

      // Associations

      _Plant,
      _Material,
      _MaterialPlant, // for DCLS

      _MRPArea,
      _PlanningScenario
}
where
      d.sc_empty = ''
  and d.nodisp   = '';

Learn More