C_MRPMaterialSitnAlert

DDL: C_MRPMATERIALSITNALERT Type: view_entity CONSUMPTION Package: ODATA_PP_MRP
18 Fields 1 Data Sources

MRP Situations Alert

C_MRPMaterialSitnAlert is a Consumption CDS View that provides data about "MRP Situations Alert" in SAP S/4HANA. It reads from 1 data source (I_MRPMaterialSituation) and exposes 18 fields with key field MatlExcptnSituationHandlingID. Part of development package ODATA_PP_MRP.

Data Sources (1)

SourceAliasJoin Type
I_MRPMaterialSituation I_MRPMaterialSituation from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label MRP Situations Alert view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MatlExcptnSituationHandlingID MatlExcptnSituationHandlingID
MatlExcptnSituationType MatlExcptnSituationType Material Situation Type
ExceptionMessageNumber ExceptionMessageNumber Key
Material Material Vehicle Model
MRPArea MRPArea MRP Area
Plant Plant Valuation Area
MRPController MRPController MRP Controller
MRPElement MRPElement MRP Element
SourceMRPElementCategory SourceMRPElementCategory MRP Element Category
MRPElementScheduleLine MRPElementScheduleLine Scheduling
MRPElementItem MRPElementItem MRP Element Item
ExceptionMessageText ExceptionMessageText Exception Message
MRPPlanningSegment MRPPlanningSegment Planning Segment Number
MRPPlanningSegmentType MRPPlanningSegmentType Planning Segment
MRPElementCategoryName MRPElementCategoryName Category Name
BusinessPartner BusinessPartner Issuing Authority
MaterialShortageDefinitionName
PMRPResourceName

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 C_MRPMaterialSitnAlert.
-- 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 C_MRPMaterialSitnAlert AS
SELECT
  MatlExcptnSituationHandlingID,
  MatlExcptnSituationType,
  ExceptionMessageNumber,
  Material,
  MRPArea,
  Plant,
  MRPController,
  MRPElement,
  SourceMRPElementCategory,
  MRPElementScheduleLine,
  MRPElementItem,
  ExceptionMessageText,
  MRPPlanningSegment,
  MRPPlanningSegmentType,
  MRPElementCategoryName,
  BusinessPartner,
  cast( '' as abap.char(40)) AS MaterialShortageDefinitionName,
  cast('' as abap.char(40)) AS PMRPResourceName
FROM I_MRPMaterialSituation
;

Learn More