I_SrvcPartsDistrRqmtsPlngC

DDL: I_SRVCPARTSDISTRRQMTSPLNGC SQL: ISPDISTRQMTSPLNC Type: view COMPOSITE
38 Fields 1 Data Sources 5 Associations

Analytics Requirements Planning - Cube

I_SrvcPartsDistrRqmtsPlngC (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_SrvcPartsDistrRqmtsPlngC is a Composite CDS View (Cube) that provides data about "Analytics Requirements Planning - Cube" in SAP S/4HANA. It reads from 1 data source (I_SrvcPartsDistrRqmtsPlng) and exposes 38 fields with key fields Product, Location, SrvcPartsKeyFigure, SrvcPartsLocationIsVrtlChildPt, ESPPPeriodFromDateTime. It has 5 associations to related views.

SAP Help Documentation

CategoryCDS Views for Requirements Planning
Data CategoryComposite Cube
StatusReleased
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
The following prerequisites must be fulfilled: A time profile needs to be maintained in transaction /SCA/TSDMCFG. Switch on flag Save Intermediate Results in TSDM in the DRP service profile and run PSM DRP service. Key figures need to be maintained in transaction /SAPAPO/TDL_APO_SEM. 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 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 Cube
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SrvcPartsDistrRqmtsPlng DRP from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _CalendarDate $projection.ESPPPeriodFromDateTime = _CalendarDate.CalendarDate
[0..1] 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 Requirements Planning - Cube view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISPDISTRQMTSPLNC 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 (38)

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 Timestamp of Begin of Period
KEY ESPPPeriodToDateTime ESPPPeriodToDateTime Timestamp of End of Period
ESPPPeriodCluster ESPPPeriodCluster Cluster identifier: sequence number
_Product _Product
_Location _Location
BaseUnit BaseUnit Unit of Measure
ESPPDistrRqmtsPlngQuantity ESPPDistrRqmtsPlngQuantity TDL: Quantity
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_SrvcPartsDistrRqmtsPlngC.
-- 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: ISPDISTRQMTSPLNC

CREATE VIEW I_SrvcPartsDistrRqmtsPlngC AS
SELECT
  Product,
  Location,
  SrvcPartsKeyFigure,
  SrvcPartsLocationIsVrtlChildPt,
  ESPPPeriodFromDateTime,
  ESPPPeriodToDateTime,
  ESPPPeriodCluster,
  BaseUnit,
  ESPPDistrRqmtsPlngQuantity,
  _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_SrvcPartsDistrRqmtsPlng AS DRP
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..1]
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