C_SrvcPartsDistrRqmtsPlngQ

DDL: C_SRVCPARTSDISTRRQMTSPLNGQ SQL: CSPDISTRQMTSPLNQ Type: view CONSUMPTION
26 Fields 1 Data Sources

Analytics Requirements Planning Query

C_SrvcPartsDistrRqmtsPlngQ (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_SrvcPartsDistrRqmtsPlngQ is a Consumption CDS View that provides data about "Analytics Requirements Planning Query" in SAP S/4HANA. It reads from 1 data source (I_SrvcPartsDistrRqmtsPlngC) and exposes 26 fields with key fields Product, Location, SrvcPartsKeyFigure, SrvcPartsLocationIsVrtlChildPt.

SAP Help Documentation

CategoryCDS Views for Requirements Planning
Data CategoryConsumption
StatusReleased
Corresponding DataSource2CCSPDISTRQMTSPLNQ
Purpose
This CDS view provides eSPP DRP matrix data as time series data for selected DRP key figures. It is provided dependent on period, product, location product and both warehouse location and virtual child location. This view only provides those DRP key figures which have been created in a PSM DRP run and were saved on the database beforehand.

Prerequisites
This query is built on top of the cube view Requirements Planning Cube ( I_SrvcPartsDistrRqmtsPlngC ). To access this query, the following authorizations are required: You need to have authorizations to access cube view Requirements Planning Cube ( I_SrvcPartsDistrRqmtsPlngC ). For more information, see Requirements Planning Cube . The following prerequisites must be fulfilled as well: Key figures need to be maintained in transaction /SAPAPO/TDL_APO_SEM. Switch on flag Save Intermediate Results in TSDM in the DRP service profile and run PSM DRP service. A time profile needs to be maintained in transaction /SCA/TSDMCFG.

Structure
Measures and attributes Some important measures are: Measure Description Representation Term ESPPDistrRqmtsPlngQuantity Distribution Requirements 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_SrvcPartsDistrRqmtsPlngC DRP from

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Analytics Requirements Planning Query view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName CSPDISTRQMTSPLNQ 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_QUERY view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Analytics.query true view

Fields (26)

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 Timestamp of Begin of Period
ESPPPeriodToDateTime ESPPPeriodToDateTime Timestamp of End of Period
BaseUnit BaseUnit Unit of Measure
ESPPDistrRqmtsPlngQuantity ESPPDistrRqmtsPlngQuantity TDL: Quantity
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_SrvcPartsDistrRqmtsPlngQ.
-- 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: CSPDISTRQMTSPLNQ

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

Learn More