I_SlsForecastKeyFigAggrgdMonth

DDL: I_SLSFORECASTKEYFIGAGGRGDMONTH SQL: IPIRAGM Type: view COMPOSITE
11 Fields 2 Data Sources

SalesAggregation Months

I_SlsForecastKeyFigAggrgdMonth is a Composite CDS View that provides data about "SalesAggregation Months" in SAP S/4HANA. It reads from 2 data sources (I_PlndIndepRqmtPlanIndTP, I_SalesForecastKeyFigure) and exposes 11 fields with key fields Product, Plant, MRPArea, PlndIndepRqmtType, PlndIndepRqmtVersion.

Data Sources (2)

SourceAliasJoin Type
I_PlndIndepRqmtPlanIndTP _item inner
I_SalesForecastKeyFigure sales from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IPIRAGM view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SalesAggregation Months view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Product I_SalesForecastKeyFigure Product Product Sold
KEY Plant I_SalesForecastKeyFigure Plant Valuation Area
KEY MRPArea I_SalesForecastKeyFigure MRPArea MRP Area
KEY PlndIndepRqmtType PlndIndepRqmtType
KEY PlndIndepRqmtVersion PlndIndepRqmtVersion
KEY RequirementPlan RequirementPlan Requirements Plan
KEY RequirementSegment RequirementSegment Req. Segment
KEY YearMonth YearMonth Year Month
SalesVolumeQuantity
FirstDayOfMonthDate FirstDayOfMonthDate First Day of Month
PeriodType I_PlndIndepRqmtPlanIndTP PeriodType PeriodIndicator

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_SlsForecastKeyFigAggrgdMonth.
-- 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: IPIRAGM

CREATE VIEW I_SlsForecastKeyFigAggrgdMonth AS
SELECT
  sales.Product AS Product,
  sales.Plant AS Plant,
  sales.MRPArea AS MRPArea,
  PlndIndepRqmtType,
  PlndIndepRqmtVersion,
  RequirementPlan,
  RequirementSegment,
  YearMonth,
  sum(SalesVolumeQuantity) AS SalesVolumeQuantity,
  FirstDayOfMonthDate,
  _item.PeriodType AS PeriodType
FROM I_SalesForecastKeyFigure AS sales
INNER JOIN I_PlndIndepRqmtPlanIndTP AS _item ON /* join condition not captured in parsed metadata */
;

Learn More