P_ForecastDemandSum

DDL: P_FORECASTDEMANDSUM SQL: PPPFCSTDMNDSUM Type: view COMPOSITE
7 Fields 1 Data Sources

P_ForecastDemandSum is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ForecastDemand) and exposes 7 fields with key fields Material, ProductionPlant.

Data Sources (1)

SourceAliasJoin Type
P_ForecastDemand P_ForecastDemand from

Parameters (1)

NameTypeDefault
P_TodayDate sydate

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPPFCSTDMNDSUM view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY ProductionPlant ProductionPlant Prod plnt
ProductBaseUnit ProductBaseUnit
CalendarMonth CalendarMonth Calendar Month
_CalendarMonth _CalendarMonth
_YearMonth _YearMonth
_ProductBaseUnit _ProductBaseUnit

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_ForecastDemandSum.
-- 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: PPPFCSTDMNDSUM
-- Parameters: P_TodayDate : sydate

CREATE VIEW P_ForecastDemandSum AS
SELECT
  Material,
  ProductionPlant,
  ProductBaseUnit,
  CalendarMonth
FROM P_ForecastDemand
;

Learn More