I_SrvcPartsForecastWeekC

DDL: I_SRVCPARTSFORECASTWEEKC SQL: ISPFORECASTWEEKC Type: view COMPOSITE
37 Fields 1 Data Sources 5 Associations

Analytics Weekly Forecast - Cube

I_SrvcPartsForecastWeekC (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_SrvcPartsForecastWeekC is a Composite CDS View (Cube) that provides data about "Analytics Weekly Forecast - Cube" in SAP S/4HANA. It reads from 1 data source (I_SrvcPartsForecastWeek) and exposes 37 fields with key fields Product, Location, SrvcPartsKeyFigure, SrvcPartsLocationIsVrtlChildPt, ESPPPeriodFromDateTime. It has 5 associations to related views.

SAP Help Documentation

CategoryCDS Views for Forecasting
Data CategoryComposite Cube
StatusReleased
Purpose
This CDS view provides the time series data of all eSPP forecast key figures dependent on period, product, location product and both warehouse location and virtual child location. The view only provides the time series data which has been created in the eSPP forecast transactions beforehand. This view can only be used for time series which have been created on a weekly period basis.

Prerequisites
The following prerequisites must be fulfilled: Key figures need to be maintained in transaction /SAPAPO/TDL_APO_SEM. A monthly time profile needs to be maintained in transaction /SCA/TSDMCFG. Users who want to run reports using this CDS view must also have the authorization to acess the following data: Products Locations

Structure
Measures and attributes Some important measures are: Measure Description Representation Term ESPPForecastQuantity Forecast quantity in Extended Service Parts Planning. Quantity Some important attributes are: Product Location ESPPPeriodFromDateTime ESPPPeriodToDateTime BaseUnit ProductGroupType ProductGroupValue

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentSCM-APO-SPP
CapabilitiesAnalytical Cube
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SrvcPartsForecastWeek forecast from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _CalendarDate $projection.ESPPPeriodFromDateTime = _CalendarDate.CalendarDate
[0..*] I_SCMProductGroup _ProductGroup $projection.Product = _ProductGroup.Product
[0..*] I_CalendarMonthText _CalendarMonthText $projection.CalendarMonth = _CalendarMonthText.CalendarMonth
[0..*] I_CalendarQuarterText _CalendarQuarterText $projection.CalendarQuarter = _CalendarQuarterText.CalendarQuarter
[0..*] I_WeekDayText _WeekDayText $projection.WeekDay = _WeekDayText.WeekDay

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Analytics Weekly Forecast - Cube view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISPFORECASTWEEKC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.supportedCapabilities #ANALYTICAL_CUBE view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
Metadata.ignorePropagatedAnnotations true view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Number
KEY Location Location Location
KEY SrvcPartsKeyFigure SrvcPartsKeyFigure TSDM Key Figure Parameter
KEY SrvcPartsLocationIsVrtlChildPt SrvcPartsLocationIsVrtlChildPt TSDM: Characteristic object
KEY ESPPPeriodFromDateTime ESPPPeriodFromDateTime eSPP Forecast: Period from
KEY ESPPPeriodToDateTime ESPPPeriodToDateTime eSPP forecast: Period to
ESPPPeriodCluster ESPPPeriodCluster Cluster identifier: sequence number
_Product _Product
_Location _Location
BaseUnit BaseUnit Unit of Measure
ProductGroupType _ProductGroup ProductGroupType Product Group Type
ProductGroupValue _ProductGroup ProductGroupValue Product Group
_ProductGroup _ProductGroup
CalendarDate _CalendarDate CalendarDate Calendar Date
CalendarYear _CalendarDate CalendarYear Calendar Year
CalendarQuarter _CalendarDate CalendarQuarter Calendar Quarter
CalendarMonth _CalendarDate CalendarMonth Calendar Month
CalendarWeek _CalendarDate CalendarWeek Calendar Week
CalendarDay _CalendarDate CalendarDay Occur Day in a Month
YearMonth _CalendarDate YearMonth Year Month
YearQuarter _CalendarDate YearQuarter Year Quarter
YearWeek _CalendarDate YearWeek Year and Calendar Week
WeekDay _CalendarDate WeekDay Weekdays
FirstDayOfWeekDate _CalendarDate FirstDayOfWeekDate First day of week date
FirstDayOfMonthDate _CalendarDate FirstDayOfMonthDate First Day of Month Date
CalendarDayOfYear _CalendarDate CalendarDayOfYear Calendar day of year
YearDay _CalendarDate YearDay Day of the year
_CalendarMonth _CalendarDate _CalendarMonth
_CalendarQuarter _CalendarDate _CalendarQuarter
_CalendarYear _CalendarDate _CalendarYear
_WeekDay _CalendarDate _WeekDay
_YearMonth _CalendarDate _YearMonth
_CalendarDate _CalendarDate
_SrvcPartsSemantics _SrvcPartsSemantics
_CalendarMonthText _CalendarMonthText
_CalendarQuarterText _CalendarQuarterText
_WeekDayText _WeekDayText

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_SrvcPartsForecastWeekC.
-- 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: ISPFORECASTWEEKC

CREATE VIEW I_SrvcPartsForecastWeekC AS
SELECT
  Product,
  Location,
  SrvcPartsKeyFigure,
  SrvcPartsLocationIsVrtlChildPt,
  ESPPPeriodFromDateTime,
  ESPPPeriodToDateTime,
  ESPPPeriodCluster,
  BaseUnit,
  _ProductGroup.ProductGroupType AS ProductGroupType,
  _ProductGroup.ProductGroupValue AS ProductGroupValue,
  _CalendarDate.CalendarDate AS CalendarDate,
  _CalendarDate.CalendarYear AS CalendarYear,
  _CalendarDate.CalendarQuarter AS CalendarQuarter,
  _CalendarDate.CalendarMonth AS CalendarMonth,
  _CalendarDate.CalendarWeek AS CalendarWeek,
  _CalendarDate.CalendarDay AS CalendarDay,
  _CalendarDate.YearMonth AS YearMonth,
  _CalendarDate.YearQuarter AS YearQuarter,
  _CalendarDate.YearWeek AS YearWeek,
  _CalendarDate.WeekDay AS WeekDay,
  _CalendarDate.FirstDayOfWeekDate AS FirstDayOfWeekDate,
  _CalendarDate.FirstDayOfMonthDate AS FirstDayOfMonthDate,
  _CalendarDate.CalendarDayOfYear AS CalendarDayOfYear,
  _CalendarDate.YearDay AS YearDay,
  _CalendarDate._CalendarMonth AS _CalendarMonth,
  _CalendarDate._CalendarQuarter AS _CalendarQuarter,
  _CalendarDate._CalendarYear AS _CalendarYear,
  _CalendarDate._WeekDay AS _WeekDay,
  _CalendarDate._YearMonth AS _YearMonth
FROM I_SrvcPartsForecastWeek AS forecast
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON ESPPPeriodFromDateTime = _CalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_SCMProductGroup AS _ProductGroup ON Product = _ProductGroup.Product  -- association [0..*]
LEFT OUTER JOIN I_CalendarMonthText AS _CalendarMonthText ON CalendarMonth = _CalendarMonthText.CalendarMonth  -- association [0..*]
LEFT OUTER JOIN I_CalendarQuarterText AS _CalendarQuarterText ON CalendarQuarter = _CalendarQuarterText.CalendarQuarter  -- association [0..*]
LEFT OUTER JOIN I_WeekDayText AS _WeekDayText ON WeekDay = _WeekDayText.WeekDay  -- association [0..*]
;

Learn More