I_MRPMaterialStockCard

DDL: I_MRPMATERIALSTOCKCARD Type: view_entity COMPOSITE Package: ODATA_PP_MRP
14 Fields 1 Data Sources

MRP Material Stock

I_MRPMaterialStockCard is a Composite CDS View (Cube) that provides data about "MRP Material Stock" in SAP S/4HANA. It reads from 1 data source (P_MRPMaterialStock_TF) and exposes 14 fields with key fields Material, MRPPlant, MRPArea, MRPPlanningSegmentType, MRPPlanningSegment. Part of development package ODATA_PP_MRP.

Data Sources (1)

SourceAliasJoin Type
P_MRPMaterialStock_TF P_MRPMaterialStock_TF from

Parameters (5)

NameTypeDefault
P_Material matnr
P_MRPPlant werks_d
P_MRPArea berid
P_MRPPlanningSegmentType plaab
P_MRPPlanningSegment planr

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label MRP Material Stock view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Metadata.allowExtensions true view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY MRPPlant MRPPlant Plant
KEY MRPArea MRPArea MRP Area
KEY MRPPlanningSegmentType MRPPlanningSegmentType MRP segment
KEY MRPPlanningSegment MRPPlanningSegment Plng Segmnt No.
MRPAvailableStockQty MRPAvailableStockQty
MaterialSafetyStockQty MaterialSafetyStockQty Safety Stock
MaterialReorderPointQty MaterialReorderPointQty Reorder Point
MaterialMaxStockLevelQuantity MaterialMaxStockLevelQuantity
SafetyTimeInWorkDays SafetyTimeInWorkDays
UnrestrictedStkInStkUnit UnrestrictedStkInStkUnit
BlockedStockQuantity BlockedStockQuantity
QualityInspectionStockQuantity QualityInspectionStockQuantity
MaterialBaseUnit MaterialBaseUnit Valuation Unit

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_MRPMaterialStockCard.
-- 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.
-- Parameters: P_Material : matnr, P_MRPPlant : werks_d, P_MRPArea : berid, P_MRPPlanningSegmentType : plaab, P_MRPPlanningSegment : planr

CREATE VIEW I_MRPMaterialStockCard AS
SELECT
  Material,
  MRPPlant,
  MRPArea,
  MRPPlanningSegmentType,
  MRPPlanningSegment,
  MRPAvailableStockQty,
  MaterialSafetyStockQty,
  MaterialReorderPointQty,
  MaterialMaxStockLevelQuantity,
  SafetyTimeInWorkDays,
  UnrestrictedStkInStkUnit,
  BlockedStockQuantity,
  QualityInspectionStockQuantity,
  MaterialBaseUnit
FROM P_MRPMaterialStock_TF
;

Learn More