I_MRPMasterDataIssueMsgTypeCnt

DDL: I_MRPMASTERDATAISSUEMSGTYPECNT Type: view_entity COMPOSITE Package: ODATA_PP_MRP
11 Fields 5 Associations

MRP Master Data Issue Count by Msg Type

I_MRPMasterDataIssueMsgTypeCnt is a Composite CDS View that provides data about "MRP Master Data Issue Count by Msg Type" in SAP S/4HANA. It has 5 associations to related views. Part of development package ODATA_PP_MRP.

Associations (5)

CardinalityTargetAliasCondition
[0..1] P_MRPMasterDataIssueCntMsgType _IssueCntMsgTypeA $projection.Material = _IssueCntMsgTypeA.Material and $projection.Plant = _IssueCntMsgTypeA.Plant and $projection.MRPArea = _IssueCntMsgTypeA.MRPArea and _IssueCntMsgTypeA.SystemMessageType = 'A'
[0..1] P_MRPMasterDataIssueCntMsgType _IssueCntMsgTypeE $projection.Material = _IssueCntMsgTypeE.Material and $projection.Plant = _IssueCntMsgTypeE.Plant and $projection.MRPArea = _IssueCntMsgTypeE.MRPArea and _IssueCntMsgTypeE.SystemMessageType = 'E'
[0..1] P_MRPMasterDataIssueCntMsgType _IssueCntMsgTypeW $projection.Material = _IssueCntMsgTypeW.Material and $projection.Plant = _IssueCntMsgTypeW.Plant and $projection.MRPArea = _IssueCntMsgTypeW.MRPArea and _IssueCntMsgTypeW.SystemMessageType = 'W'
[0..1] P_MRPMasterDataIssueCntMsgType _IssueCntMsgTypeI $projection.Material = _IssueCntMsgTypeI.Material and $projection.Plant = _IssueCntMsgTypeI.Plant and $projection.MRPArea = _IssueCntMsgTypeI.MRPArea and _IssueCntMsgTypeI.SystemMessageType = 'I'
[0..1] P_MRPMasterDataIssueCntMsgType _IssueCntMsgTypeS $projection.Material = _IssueCntMsgTypeS.Material and $projection.Plant = _IssueCntMsgTypeS.Plant and $projection.MRPArea = _IssueCntMsgTypeS.MRPArea and _IssueCntMsgTypeS.SystemMessageType = 'S'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label MRP Master Data Issue Count by Msg Type view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY MRPArea MRPArea MRP Area
NumberOfIssuesWithAbort _IssueCntMsgTypeA IssueCount
NmbrOfIssuesWithError _IssueCntMsgTypeE IssueCount
NumberOfIssuesWithWarning _IssueCntMsgTypeW IssueCount
NumberOfIssuesWithInformation _IssueCntMsgTypeI IssueCount
NumberOfIssuesWithSuccess _IssueCntMsgTypeS IssueCount
_Material _Material
_Plant _Plant
_MRPArea _MRPArea

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_MRPMasterDataIssueMsgTypeCnt.
-- 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_MRPMasterDataIssueMsgTypeCnt AS
SELECT
  Material,
  Plant,
  MRPArea,
  _IssueCntMsgTypeA.IssueCount AS NumberOfIssuesWithAbort,
  _IssueCntMsgTypeE.IssueCount AS NmbrOfIssuesWithError,
  _IssueCntMsgTypeW.IssueCount AS NumberOfIssuesWithWarning,
  _IssueCntMsgTypeI.IssueCount AS NumberOfIssuesWithInformation,
  _IssueCntMsgTypeS.IssueCount AS NumberOfIssuesWithSuccess
LEFT OUTER JOIN P_MRPMasterDataIssueCntMsgType AS _IssueCntMsgTypeA ON Material = _IssueCntMsgTypeA.Material AND Plant = _IssueCntMsgTypeA.Plant AND MRPArea = _IssueCntMsgTypeA.MRPArea AND _IssueCntMsgTypeA.SystemMessageType = 'A'  -- association [0..1]
LEFT OUTER JOIN P_MRPMasterDataIssueCntMsgType AS _IssueCntMsgTypeE ON Material = _IssueCntMsgTypeE.Material AND Plant = _IssueCntMsgTypeE.Plant AND MRPArea = _IssueCntMsgTypeE.MRPArea AND _IssueCntMsgTypeE.SystemMessageType = 'E'  -- association [0..1]
LEFT OUTER JOIN P_MRPMasterDataIssueCntMsgType AS _IssueCntMsgTypeW ON Material = _IssueCntMsgTypeW.Material AND Plant = _IssueCntMsgTypeW.Plant AND MRPArea = _IssueCntMsgTypeW.MRPArea AND _IssueCntMsgTypeW.SystemMessageType = 'W'  -- association [0..1]
LEFT OUTER JOIN P_MRPMasterDataIssueCntMsgType AS _IssueCntMsgTypeI ON Material = _IssueCntMsgTypeI.Material AND Plant = _IssueCntMsgTypeI.Plant AND MRPArea = _IssueCntMsgTypeI.MRPArea AND _IssueCntMsgTypeI.SystemMessageType = 'I'  -- association [0..1]
LEFT OUTER JOIN P_MRPMasterDataIssueCntMsgType AS _IssueCntMsgTypeS ON Material = _IssueCntMsgTypeS.Material AND Plant = _IssueCntMsgTypeS.Plant AND MRPArea = _IssueCntMsgTypeS.MRPArea AND _IssueCntMsgTypeS.SystemMessageType = 'S'  -- association [0..1]
;

Learn More