I_MaterialBufferLevel

DDL: I_MATERIALBUFFERLEVEL SQL: IMATBUFLVL Type: view COMPOSITE Package: ODATA_PP_DD_STLM
10 Fields 1 Data Sources 1 Associations

Adopted buffer zones of Material

I_MaterialBufferLevel is a Composite CDS View that provides data about "Adopted buffer zones of Material" in SAP S/4HANA. It reads from 1 data source (I_MaterialActualStkOnHrzn) and exposes 10 fields with key fields Material, MRPArea, Plant, PostingDate. It has 1 association to related views. Part of development package ODATA_PP_DD_STLM.

Data Sources (1)

SourceAliasJoin Type
I_MaterialActualStkOnHrzn _MatActualStk from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Material _Material $projection.Material = _Material.Material

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMATBUFLVL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Adopted buffer zones of Material view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY MRPArea MRPArea MRP Area
KEY Plant Plant Valuation Area
KEY PostingDate I_MaterialActualStkOnHrzn PostingDate Posting Date for GR
MRPAvailableStockQty I_MaterialActualStkOnHrzn MRPAvailableStockQty
MaterialMaxStockLevelQuantity _TimeStkBuffer MaterialMaxStockLevelQuantity
BaseUnit _Material MaterialBaseUnit Valuation Unit
ReorderThresholdQuantity _TimeStkBuffer ReorderThresholdQuantity Reorder Point
MaterialSafetyStockQty _TimeStkBuffer MaterialSafetyStockQty Safety Stock
_Material _Material

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_MaterialBufferLevel.
-- 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: IMATBUFLVL

CREATE VIEW I_MaterialBufferLevel AS
SELECT
  Material,
  MRPArea,
  Plant,
  _MatActualStk.PostingDate AS PostingDate,
  _MatActualStk.MRPAvailableStockQty AS MRPAvailableStockQty,
  _TimeStkBuffer.MaterialMaxStockLevelQuantity AS MaterialMaxStockLevelQuantity,
  _Material.MaterialBaseUnit AS BaseUnit,
  _TimeStkBuffer.ReorderThresholdQuantity AS ReorderThresholdQuantity,
  _TimeStkBuffer.MaterialSafetyStockQty AS MaterialSafetyStockQty
FROM I_MaterialActualStkOnHrzn AS _MatActualStk
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
;

Learn More