I_MRPAvailability

DDL: I_MRPAVAILABILITY SQL: IMRPAVAILABILITY Type: view COMPOSITE
14 Fields 3 Data Sources 1 Associations

MRP Availability of a Material

I_MRPAvailability is a Composite CDS View that provides data about "MRP Availability of a Material" in SAP S/4HANA. It reads from 3 data sources (I_SupplyDemandItemTotals, I_CacheMaterial, I_MRPPlanningSegment) and exposes 14 fields with key fields MRPPlant, Material, MRPArea, MRPPlanningSegmentType, MRPPlanningSegment. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_SupplyDemandItemTotals _SupplyDemandItemTotals left_outer
I_CacheMaterial CacheMaterial inner
I_MRPPlanningSegment MRPPlanningSegment from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.MaterialBaseUnit = _UnitOfMeasure.UnitOfMeasure

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IMRPAVAILABILITY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MRP Availability of a Material view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MRPPlant I_MRPPlanningSegment MRPPlant Plant
KEY Material I_MRPPlanningSegment Material Vehicle Model
KEY MRPArea I_MRPPlanningSegment MRPArea MRP Area
KEY MRPPlanningSegmentType I_MRPPlanningSegment MRPPlanningSegmentType MRP segment
KEY MRPPlanningSegment I_MRPPlanningSegment MRPPlanningSegment Plng Segmnt No.
KEY MaterialShortageProfile I_MRPPlanningSegment MaterialShortageProfile Shortage Prf.
KEY MaterialShortageProfileCount I_SupplyDemandItemTotals MaterialShortageProfileCount Counter
KEY MRPElementAvailyOrRqmtDate I_SupplyDemandItemTotals MRPElementAvailyOrRqmtDate Time Stamp
MaterialBaseUnit I_CacheMaterial MaterialBaseUnit Valuation Unit
MRPAvailableQuantity I_SupplyDemandItemTotals MRPAvailableQuantity DEC 20 3
MRPAvailability I_SupplyDemandItemTotals MRPAvailability MRP Availability
PlanningSegmentDocument PlanningSegmentDocument
PlanningSegmentDocumentItem PlanningSegmentDocumentItem
UnitOfMeasureDspNmbrOfDcmls _UnitOfMeasure UnitOfMeasureDspNmbrOfDcmls

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_MRPAvailability.
-- 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: IMRPAVAILABILITY

CREATE VIEW I_MRPAvailability AS
SELECT
  MRPPlanningSegment.MRPPlant AS MRPPlant,
  MRPPlanningSegment.Material AS Material,
  MRPPlanningSegment.MRPArea AS MRPArea,
  MRPPlanningSegment.MRPPlanningSegmentType AS MRPPlanningSegmentType,
  MRPPlanningSegment.MRPPlanningSegment AS MRPPlanningSegment,
  MRPPlanningSegment.MaterialShortageProfile AS MaterialShortageProfile,
  _SupplyDemandItemTotals.MaterialShortageProfileCount AS MaterialShortageProfileCount,
  _SupplyDemandItemTotals.MRPElementAvailyOrRqmtDate AS MRPElementAvailyOrRqmtDate,
  CacheMaterial.MaterialBaseUnit AS MaterialBaseUnit,
  _SupplyDemandItemTotals.MRPAvailableQuantity AS MRPAvailableQuantity,
  _SupplyDemandItemTotals.MRPAvailability AS MRPAvailability,
  PlanningSegmentDocument,
  PlanningSegmentDocumentItem,
  _UnitOfMeasure.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls
FROM I_MRPPlanningSegment AS MRPPlanningSegment
INNER JOIN I_CacheMaterial AS CacheMaterial ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupplyDemandItemTotals AS _SupplyDemandItemTotals ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MaterialBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;

Learn More