I_SrvcPartsDmndHistRawC

DDL: I_SRVCPARTSDMNDHISTRAWC SQL: ISPDMNDHRAWDMNDC Type: view COMPOSITE
56 Fields 1 Data Sources 5 Associations

Analytics Raw Demand for Demand History - Cube

I_SrvcPartsDmndHistRawC (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_SrvcPartsDmndHistRawC is a Composite CDS View (Cube) that provides data about "Analytics Raw Demand for Demand History - Cube" in SAP S/4HANA. It reads from 1 data source (I_SrvcPartsDmndHistRaw) and exposes 56 fields with key fields SrvcPartsDmndOrder, SrvcPartsDmndItemNumber, SrvcPartsDmndScheduleLineNmbr, SrvcPartsDmndOrderDate, SrvcPartsDmndType. It has 5 associations to related views.

SAP Help Documentation

CategoryCDS Views for Demand History
Data CategoryComposite Cube
StatusReleased
Purpose
This CDS view provides raw data that serves as the basis for generating the demand history. The raw data consist of historical data (single records) like sales order data from the Sales and Distribution component (SD) and stock transfer data from the Materials Management component (MM).

Prerequisites
Users who want to run reports using this CDS view must have the authorization to acess the following data: eSPP Demand History Products Locations

Structure
This CDS view is built on a single database table. Measures and attributes Some important measures are: Measure Description Representation Term SrvcPartsDmndQuantity Demand quantity of a demand order. Quantity NumberOfSrvcPartsDmndEntry Number of positions (lines which refer to a specific product) of a demand. Value Some important attributes are: SrvcPartsDmndOrderDate SrvcPartsDmndType Product SrvcPartsFacingLocation SrvcPartsStockingLocation SrvcPartsDmndCategory Customer SrvcPartsRawDmndIsAbnormal OrderIsThirdParty OrderIsEmergency

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_SrvcPartsDmndHistRaw I_SrvcPartsDmndHistRaw from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _CalendarDate $projection.ShippingDate = _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 Raw Demand for Demand History - Cube view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.supportedCapabilities #ANALYTICAL_CUBE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ISPDMNDHRAWDMNDC view
VDM.viewType #COMPOSITE view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY SrvcPartsDmndOrder SrvcPartsDmndOrder Order Number Raw Demand
KEY SrvcPartsDmndItemNumber SrvcPartsDmndItemNumber Item Number Raw Demand
KEY SrvcPartsDmndScheduleLineNmbr SrvcPartsDmndScheduleLineNmbr Schedule Line Number Raw Demand
KEY SrvcPartsDmndOrderDate SrvcPartsDmndOrderDate Order Date Raw Demand
KEY SrvcPartsDmndType SrvcPartsDmndType Demand type Raw Demand
Product Product Product Raw Demand
SrvcPartsFacingLocation SrvcPartsFacingLocation Facing Location Raw Demand
SrvcPartsStockingLocation SrvcPartsStockingLocation Stocking Location Raw Demand
SrvcPartsDmndCategory SrvcPartsDmndCategory Demand Category Raw Demand
Customer Customer Customer Raw Demand
SrvcPartsDmndQuantity SrvcPartsDmndQuantity Demand Quantity Raw Demand
SrvcPartsDmndUnit SrvcPartsDmndUnit Base Unit of Measure Raw Demand
ShippingDate ShippingDate Shipping Date Raw Demand
NumberOfSrvcPartsDmndEntry NumberOfSrvcPartsDmndEntry Demand Entry Raw Demand
SrvcPartsDmndOrderType SrvcPartsDmndOrderType Order Type Raw Demand
SrvcPartsDmndItemType SrvcPartsDmndItemType Item Type Raw Demand
OrderIsThirdParty OrderIsThirdParty Third-Party Order Processing Raw Demand
SrvcPartsRawDmndIsAbnormal SrvcPartsRawDmndIsAbnormal Abnormal Indicator Raw Demand
SrvcPartsFcngLocIsVrtlChildPt SrvcPartsFcngLocIsVrtlChildPt Virtual Child Location Indicator Raw Demand
SrvcPartsStkLocIsVrtlChildPt SrvcPartsStkLocIsVrtlChildPt Virtual Child Location Indicator Raw Demand
OrderIsEmergency OrderIsEmergency Emergency Order Raw Demand
StockingLocationUUID StockingLocationUUID Internal Location Number for Stocking Location
FacingLocationUUID FacingLocationUUID Internal Location Number for Facing Location
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
ProductGroupType _ProductGroup ProductGroupType Product Group Type
ProductGroupValue _ProductGroup ProductGroupValue Product Group
_ProductGroup _ProductGroup
_Product _Product
_Customer _Customer
_SrvcPartsDemandType _SrvcPartsDemandType
_ItemCategory _ItemCategory
_FacingLocationAnalytics _FacingLocationAnalytics
_StockingLocationAnalytics _StockingLocationAnalytics
_SrvcPartsDemandCategory _SrvcPartsDemandCategory
_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_SrvcPartsDmndHistRawC.
-- 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: ISPDMNDHRAWDMNDC

CREATE VIEW I_SrvcPartsDmndHistRawC AS
SELECT
  SrvcPartsDmndOrder,
  SrvcPartsDmndItemNumber,
  SrvcPartsDmndScheduleLineNmbr,
  SrvcPartsDmndOrderDate,
  SrvcPartsDmndType,
  Product,
  SrvcPartsFacingLocation,
  SrvcPartsStockingLocation,
  SrvcPartsDmndCategory,
  Customer,
  SrvcPartsDmndQuantity,
  SrvcPartsDmndUnit,
  ShippingDate,
  NumberOfSrvcPartsDmndEntry,
  SrvcPartsDmndOrderType,
  SrvcPartsDmndItemType,
  OrderIsThirdParty,
  SrvcPartsRawDmndIsAbnormal,
  SrvcPartsFcngLocIsVrtlChildPt,
  SrvcPartsStkLocIsVrtlChildPt,
  OrderIsEmergency,
  StockingLocationUUID,
  FacingLocationUUID,
  _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,
  _ProductGroup.ProductGroupType AS ProductGroupType,
  _ProductGroup.ProductGroupValue AS ProductGroupValue
FROM I_SrvcPartsDmndHistRaw
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON ShippingDate = _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