I_MRPMasterDataIssue

DDL: I_MRPMASTERDATAISSUE Type: view_entity COMPOSITE Package: PPH_MRP
22 Fields 1 Data Sources 1 Associations

Master data related issue that occurred during an MRP run

I_MRPMasterDataIssue is a Composite CDS View that provides data about "Master data related issue that occurred during an MRP run" in SAP S/4HANA. It reads from 1 data source (I_MRPMasterDataIssueBasic) and exposes 22 fields with key fields Material, Plant, MRPArea, MRPMasterDataIssueSource, MRPMasterDataIssueItemCount. It has 1 association to related views. Part of development package PPH_MRP.

Data Sources (1)

SourceAliasJoin Type
I_MRPMasterDataIssueBasic Issue from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MRPMasterDataIssueCat _MRPMasterDataIssueCat $projection.MRPMasterDataIssueCategory = _MRPMasterDataIssueCat.MRPMasterDataIssueCategory

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Master data related issue that occurred during an MRP run view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Material I_MRPMasterDataIssueBasic Material Vehicle Model
KEY Plant I_MRPMasterDataIssueBasic Plant Valuation Area
KEY MRPArea I_MRPMasterDataIssueBasic MRPArea MRP Area
KEY MRPMasterDataIssueSource I_MRPMasterDataIssueBasic MRPMasterDataIssueSource
KEY MRPMasterDataIssueItemCount I_MRPMasterDataIssueBasic MRPMasterDataIssueItemCount
SystemMessageIdentification I_MRPMasterDataIssueBasic SystemMessageIdentification Message ID
SystemMessageType I_MRPMasterDataIssueBasic SystemMessageType Message type
SystemMessageNumber I_MRPMasterDataIssueBasic SystemMessageNumber Message Number
SystemMessageVariable1 I_MRPMasterDataIssueBasic SystemMessageVariable1 Variable 1
SystemMessageVariable2 I_MRPMasterDataIssueBasic SystemMessageVariable2 Variable 2
SystemMessageVariable3 I_MRPMasterDataIssueBasic SystemMessageVariable3 Variable 3
SystemMessageVariable4 I_MRPMasterDataIssueBasic SystemMessageVariable4 Variable 4
MRPMasterDataIssueText cat MRPMasterDataIssueText
MRPLogUUID I_MRPMasterDataIssueBasic MRPMessageLogUUID
CreationDateTime I_MRPMasterDataIssueBasic CreationDateTime Timestamp
MRPMasterDataIssueCategory
MRPResponsible
IsAccepted I_MRPMasterDataIssueBasic MRPIssueIsAccepted
IsAcceptedByUser I_MRPMasterDataIssueBasic MRPIssueAcceptedByUser
IsAcceptedDateTime I_MRPMasterDataIssueBasic MRPIssueAcceptanceDateTime
_MRPMasterDataIssueCat _MRPMasterDataIssueCat
_MRPMasterDataIssueSource I_MRPMasterDataIssueBasic _MRPMasterDataIssueSource

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_MRPMasterDataIssue.
-- 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_MRPMasterDataIssue AS
SELECT
  Issue.Material AS Material,
  Issue.Plant AS Plant,
  Issue.MRPArea AS MRPArea,
  Issue.MRPMasterDataIssueSource AS MRPMasterDataIssueSource,
  Issue.MRPMasterDataIssueItemCount AS MRPMasterDataIssueItemCount,
  Issue.SystemMessageIdentification AS SystemMessageIdentification,
  Issue.SystemMessageType AS SystemMessageType,
  Issue.SystemMessageNumber AS SystemMessageNumber,
  Issue.SystemMessageVariable1 AS SystemMessageVariable1,
  Issue.SystemMessageVariable2 AS SystemMessageVariable2,
  Issue.SystemMessageVariable3 AS SystemMessageVariable3,
  Issue.SystemMessageVariable4 AS SystemMessageVariable4,
  cat.MRPMasterDataIssueText AS MRPMasterDataIssueText,
  Issue.MRPMessageLogUUID AS MRPLogUUID,
  Issue.CreationDateTime AS CreationDateTime,
  cast(coalesce(cat.MRPMasterDataIssueCategory, ' ') as pph_issue_category preserving type ) AS MRPMasterDataIssueCategory,
  cast(coalesce(ProductPlantMRPArea.MRPResponsible,ProductPlant.MRPResponsible) as pph_dispo preserving type ) AS MRPResponsible,
  Issue.MRPIssueIsAccepted AS IsAccepted,
  Issue.MRPIssueAcceptedByUser AS IsAcceptedByUser,
  Issue.MRPIssueAcceptanceDateTime AS IsAcceptedDateTime,
  Issue._MRPMasterDataIssueSource AS _MRPMasterDataIssueSource
FROM I_MRPMasterDataIssueBasic AS Issue
LEFT OUTER JOIN I_MRPMasterDataIssueCat AS _MRPMasterDataIssueCat ON MRPMasterDataIssueCategory = _MRPMasterDataIssueCat.MRPMasterDataIssueCategory  -- association [0..1]
;

Learn More