P_PlannerOvwCalcFields

DDL: P_PLANNEROVWCALCFIELDS SQL: PPLNRCALC Type: view CONSUMPTION Package: ODATA_PP_PLANNER_OVP
8 Fields 1 Data Sources 1 Associations

Calculations for Planner Overview

P_PlannerOvwCalcFields is a Consumption CDS View that provides data about "Calculations for Planner Overview" in SAP S/4HANA. It reads from 1 data source (I_ProdBufLvlPrpsl) and exposes 8 fields with key fields Material, MRPArea, Plant, ProposalStartDate, ProposalVersion. It has 1 association to related views. Part of development package ODATA_PP_PLANNER_OVP.

Data Sources (1)

SourceAliasJoin Type
I_ProdBufLvlPrpsl _BufferProposal from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_TimeDependentStockBuffer _CurrentBuffer $projection.Material = _CurrentBuffer.Material and $projection.Plant = _CurrentBuffer.Plant and $projection.MRPArea = _CurrentBuffer.MRPArea and _CurrentBuffer.BufferLevelStartDate <= $session.system_date and _CurrentBuffer.BufferLevelEndDate >= $session.system_date

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPLNRCALC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Calculations for Planner Overview view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Material I_ProdBufLvlPrpsl Material Vehicle Model
KEY MRPArea I_ProdBufLvlPrpsl MRPArea MRP Area
KEY Plant I_ProdBufLvlPrpsl Plant Valuation Area
KEY ProposalStartDate I_ProdBufLvlPrpsl ProposalStartDate
KEY ProposalVersion I_ProdBufLvlPrpsl ProposalVersion
StockLevelProposalStatus StockLevelProposalStatus
MatlProposedMaxStock
MaterialMaxStockLevelQuantity _CurrentBuffer MaterialMaxStockLevelQuantity

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 P_PlannerOvwCalcFields.
-- 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: PPLNRCALC

CREATE VIEW P_PlannerOvwCalcFields AS
SELECT
  _BufferProposal.Material AS Material,
  _BufferProposal.MRPArea AS MRPArea,
  _BufferProposal.Plant AS Plant,
  _BufferProposal.ProposalStartDate AS ProposalStartDate,
  _BufferProposal.ProposalVersion AS ProposalVersion,
  StockLevelProposalStatus,
  _BufferProposal.ProposedGreenZone + _BufferProposal.ProposedYellowZone + _BufferProposal.ProposedRedZone AS MatlProposedMaxStock,
  _CurrentBuffer.MaterialMaxStockLevelQuantity AS MaterialMaxStockLevelQuantity
FROM I_ProdBufLvlPrpsl AS _BufferProposal
LEFT OUTER JOIN I_TimeDependentStockBuffer AS _CurrentBuffer ON Material = _CurrentBuffer.Material AND Plant = _CurrentBuffer.Plant AND MRPArea = _CurrentBuffer.MRPArea AND _CurrentBuffer.BufferLevelStartDate <= $session.system_date AND _CurrentBuffer.BufferLevelEndDate >= $session.system_date  -- association [1..1]
;

Learn More