I_ForecastDemandVersusSales

DDL: I_FORECASTDEMANDVERSUSSALES Type: view_entity COMPOSITE Package: VDM_PP_MP
12 Fields 1 Data Sources 2 Associations

Forecast Demand versus Sales of Material

I_ForecastDemandVersusSales is a Composite CDS View (Cube) that provides data about "Forecast Demand versus Sales of Material" in SAP S/4HANA. It reads from 1 data source (P_FcstDmndSaleWtdrSum) and exposes 12 fields with key fields Material, ProductionPlant. It has 2 associations to related views. Part of development package VDM_PP_MP.

Data Sources (1)

SourceAliasJoin Type
P_FcstDmndSaleWtdrSum P_FcstDmndSaleWtdrSum from

Parameters (1)

NameTypeDefault
P_TodayDate sydate

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_UnitOfMeasure _ProductBaseUnit $projection.ProductBaseUnit = _ProductBaseUnit.UnitOfMeasure
[0..1] I_MaterialPlant _MaterialPlant $projection.ProductionPlant = _MaterialPlant.Plant and $projection.Material = _MaterialPlant.Material

Annotations (11)

NameValueLevelField
EndUserText.label Forecast Demand versus Sales of Material view
VDM.viewType #COMPOSITE view
VDM.private false view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #CUBE view
Analytics.technicalName IPPFCSTVERSUSSLS view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Material DForecastInPrevPerMadeSalesAny Material Vehicle Model
KEY ProductionPlant DForecastInPrevPerMadeSalesAny ProductionPlant Prod plnt
SoldQuantity DForecastInPrevPerMadeSalesAny SoldQty
RequiredQuantity
ProductBaseUnit DForecastInPrevPerMadeSalesAny ProductBaseUnit
MRPController
MRPControllerName
CalendarMonth DForecastInPrevPerMadeSalesAny CalendarMonth Calendar Month
_ProductBaseUnit _ProductBaseUnit
_CalendarMonth DForecastInPrevPerMadeSalesAny _CalendarMonth
_YearMonth DForecastInPrevPerMadeSalesAny _YearMonth
_MaterialPlant _MaterialPlant

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_ForecastDemandVersusSales.
-- 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_TodayDate : sydate

CREATE VIEW I_ForecastDemandVersusSales AS
SELECT
  DForecastInPrevPerMadeSalesAny.Material AS Material,
  DForecastInPrevPerMadeSalesAny.ProductionPlant AS ProductionPlant,
  DForecastInPrevPerMadeSalesAny.SoldQty AS SoldQuantity,
  coalesce (DForecastInPrevPerMadeSalesAny.RequiredQuantity, cast(0.0 as abap.fltp)) AS RequiredQuantity,
  DForecastInPrevPerMadeSalesAny.ProductBaseUnit AS ProductBaseUnit,
  _MaterialPlant._MRPController.MRPController AS MRPController,
  _MaterialPlant._MRPController.MRPControllerName AS MRPControllerName,
  DForecastInPrevPerMadeSalesAny.CalendarMonth AS CalendarMonth,
  DForecastInPrevPerMadeSalesAny._CalendarMonth AS _CalendarMonth,
  DForecastInPrevPerMadeSalesAny._YearMonth AS _YearMonth
FROM P_FcstDmndSaleWtdrSum
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductBaseUnit ON ProductBaseUnit = _ProductBaseUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON ProductionPlant = _MaterialPlant.Plant AND Material = _MaterialPlant.Material  -- association [0..1]
;

Learn More