C_SrvcPartsForecastWeekQ

DDL: C_SRVCPARTSFORECASTWEEKQ SQL: CSPFORECASTWEEKQ Type: view CONSUMPTION
25 Fields 1 Data Sources

Analytics - Weekly Forecast Query

C_SrvcPartsForecastWeekQ (Consumption)

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

Sourcing & Procurement

C_SrvcPartsForecastWeekQ is a Consumption CDS View that provides data about "Analytics - Weekly Forecast Query" in SAP S/4HANA. It reads from 1 data source (I_SrvcPartsForecastWeekC) and exposes 25 fields with key fields Product, Location, SrvcPartsKeyFigure, SrvcPartsLocationIsVrtlChildPt.

SAP Help Documentation

CategoryCDS Views for Forecasting
Data CategoryConsumption
StatusReleased
Corresponding DataSource2CCSPFORECASTWEEKQ
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
This query is built on top of the cube view Weekly Forecast Cube ( I_SrvcPartsForecastWeekC ). To access this query, the following authorizations are required: You need to have authorizations to access cube view Weekly Forecast Cube ( I_SrvcPartsForecastWeekC ). For more information, see Weekly Forecast Cube . The following prerequisites must be fulfilled as well: Key figures need to be maintained in transaction /SAPAPO/TDL_APO_SEM. A monthly time profile needs to be maintained in transaction /SCA/TSDMCFG.

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 Query
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SrvcPartsForecastWeekC forecast from

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Analytics - Weekly Forecast Query view
AbapCatalog.sqlViewName CSPFORECASTWEEKQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.supportedCapabilities #ANALYTICAL_QUERY view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Analytics.query true view

Fields (25)

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
_Product _Product
_Location _Location
ESPPPeriodFromDateTime ESPPPeriodFromDateTime eSPP Forecast: Period from
ESPPPeriodToDateTime ESPPPeriodToDateTime eSPP forecast: Period to
BaseUnit BaseUnit Unit of Measure
ProductGroupType ProductGroupType Product Group Type
ProductGroupValue ProductGroupValue Product Group
CalendarDate CalendarDate Calendar Date
CalendarYear CalendarYear Calendar Year
CalendarQuarter CalendarQuarter Calendar Quarter
CalendarMonth CalendarMonth Calendar Month
CalendarWeek CalendarWeek Calendar Week
CalendarDay CalendarDay Occur Day in a Month
YearMonth YearMonth Year Month
YearQuarter YearQuarter Year Quarter
YearWeek YearWeek Year and Calendar Week
WeekDay WeekDay Weekdays
FirstDayOfWeekDate FirstDayOfWeekDate First day of week date
FirstDayOfMonthDate FirstDayOfMonthDate First Day of Month Date
CalendarDayOfYear CalendarDayOfYear Calendar day of year
YearDay YearDay Day of the year

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 C_SrvcPartsForecastWeekQ.
-- 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: CSPFORECASTWEEKQ

CREATE VIEW C_SrvcPartsForecastWeekQ AS
SELECT
  Product,
  Location,
  SrvcPartsKeyFigure,
  SrvcPartsLocationIsVrtlChildPt,
  ESPPPeriodFromDateTime,
  ESPPPeriodToDateTime,
  BaseUnit,
  ProductGroupType,
  ProductGroupValue,
  CalendarDate,
  CalendarYear,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  CalendarDay,
  YearMonth,
  YearQuarter,
  YearWeek,
  WeekDay,
  FirstDayOfWeekDate,
  FirstDayOfMonthDate,
  CalendarDayOfYear,
  YearDay
FROM I_SrvcPartsForecastWeekC AS forecast
;

Learn More