I_DDHistlBufProdStkZn

DDL: I_DDHISTLBUFPRODSTKZN Type: view_entity COMPOSITE Package: ODATA_PP_DD_HISTL_BUF_ANALYSIS
15 Fields 1 Data Sources 2 Associations

Buffer Product Time Zone Stock Data

I_DDHistlBufProdStkZn is a Composite CDS View that provides data about "Buffer Product Time Zone Stock Data" in SAP S/4HANA. It reads from 1 data source (I_DDHistlBufProdStkZn1) and exposes 15 fields with key fields Product, Plant, MRPArea, ProposalStartDate. It has 2 associations to related views. Part of development package ODATA_PP_DD_HISTL_BUF_ANALYSIS.

Data Sources (1)

SourceAliasJoin Type
I_DDHistlBufProdStkZn1 I_DDHistlBufProdStkZn1 from

Parameters (2)

NameTypeDefault
P_StartDate begda
P_EndDate endda

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProfileAssgmtToPlant _PlantThreshold _BufferLevels.Plant = _PlantThreshold.Plant
[1..1] I_ProfileAssgmtToPlant _PlantDefaultThreshold _PlantDefaultThreshold.Plant = ''

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Buffer Product Time Zone Stock Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Product _BufferLevels Product Product Sold
KEY Plant _BufferLevels Plant Valuation Area
KEY MRPArea _BufferLevels MRPArea MRP Area
KEY ProposalStartDate _BufferLevels PostingDate Date
MRPController MRPController MRP Controller
MRPControllerName MRPControllerName Controller name
MRPAvailableStockQty MRPAvailableStockQty
ProductMaxStockLevelQuantity ProductMaxStockLevelQuantity Max. Stock
ReorderThresholdQuantity ReorderThresholdQuantity Reorder Point
ProductSafetyStockLvlQuantity ProductSafetyStockLvlQuantity Safety Stock
HighRedBufferLevelQuantity Performance High Level Boundary
MRPType _BufferLevels MRPType MRP Type
MRPTypeName _BufferLevels MRPTypeName
BaseUnit BaseUnit Unit of Measure
_Product _Product

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_DDHistlBufProdStkZn.
-- 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_StartDate : begda, P_EndDate : endda

CREATE VIEW I_DDHistlBufProdStkZn AS
SELECT
  _BufferLevels.Product AS Product,
  _BufferLevels.Plant AS Plant,
  _BufferLevels.MRPArea AS MRPArea,
  _BufferLevels.PostingDate AS ProposalStartDate,
  MRPController,
  MRPControllerName,
  MRPAvailableStockQty,
  ProductMaxStockLevelQuantity,
  ReorderThresholdQuantity,
  ProductSafetyStockLvlQuantity,
  ProductMaxStockLevelQuantity - ReorderThresholdQuantity AS HighRedBufferLevelQuantity,
  _BufferLevels.MRPType AS MRPType,
  _BufferLevels.MRPTypeName AS MRPTypeName,
  BaseUnit
FROM I_DDHistlBufProdStkZn1
LEFT OUTER JOIN I_ProfileAssgmtToPlant AS _PlantThreshold ON _BufferLevels.Plant = _PlantThreshold.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProfileAssgmtToPlant AS _PlantDefaultThreshold ON _PlantDefaultThreshold.Plant = ''  -- association [1..1]
;

Learn More