What is I_ProdAllocObjTimeSeriesDEX in SAP S/4HANA?

I_ProdAllocObjTimeSeriesDEX is a basic CDS view in SAP S/4HANA. Product Allocation Object Time Series It contains 25 fields.

Which tables does I_ProdAllocObjTimeSeriesDEX read from?

I_ProdAllocObjTimeSeriesDEX reads data from: paobj_tmesers.

What VDM layer is I_ProdAllocObjTimeSeriesDEX?

I_ProdAllocObjTimeSeriesDEX is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_ProdAllocObjTimeSeriesDEX

DDL: I_PRODALLOCOBJTIMESERIESDEX Type: view_entity BASIC Package: PRODUCT_ALLOCATION_OBJECT

25 Fields 1 Data Sources

Product Allocation Object Time Series

I_ProdAllocObjTimeSeriesDEX is a Basic CDS View that provides data about "Product Allocation Object Time Series" in SAP S/4HANA. It reads from 1 data source (paobj_tmesers) and exposes 25 fields with key field ProdAllocationTimeSeriesUUID. Part of development package PRODUCT_ALLOCATION_OBJECT.

SAP Help Documentation

Category	CDS Views for Product Allocation
Data Category	Dimension
Status	Constraint status

Purpose
This CDS view extracts product allocation time series of characteristic value combinations of allocation objects, with planned quantities. This CDS view provides the data to answer the following business questions: Which time series exist for a product allocation object and a characteristic value combination? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: M_PAO_CVC (Characteristic Value Combination access) Configuration You have activated Product Allocation in Customizing of Cross-Application Components Advanced Available-to-Promise (aATP) Product Allocation (PAL) Activate Product Allocation .

Structure
Important Fields Important fields in this view include the following: Field Name Description ProdAllocationTimeSeriesUUID Product allocation time series UUID (technical key) ProductAllocationObject Product allocation object ProdAllocCharc01 - ProdAllocCharc10 Characteristic value fields 1 - 10 ProdAllocPerdStartUTCDateTime Period start date time (in UTC) ProdAllocationActivationStatus Activation status ProdAllocCharcConstraintStatus Constraint status ProdAllocPeriodStartTimeZone Period start time zone ProdAllocationPeriodStartDate Period start date ProdAllocPeriodEndUTCDateTime Period end date time (in UTC) ProdAllocPeriodEndTimeZone Period end time zone ProductAllocationQuantity Allocation quantity ProductAllocationQuantityUnit Quantity unit

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

Constraints
Note that if the activation status of a time series has status 03 Blocked , to be compliant to data protection and privacy regulations, the data of this time series must not be displayed in the target system.

View on SAP Help Portal →

Data Sources (1)

Source	Alias	Join Type
paobj_tmesers	ts	from

Annotations (12)

Name	Value	Level
EndUserText.label	Product Allocation Object Time Series	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.sapObjectNodeType.name	ProdAllocObjTimeSeries	view
Analytics.technicalName	IPAOBJTMESERSDEX	view
Analytics.dataExtraction.enabled	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (25)

Key	Field	Source Table	Source Field	Description
KEY	ProdAllocationTimeSeriesUUID	paobj_tmesers	prodallocationtimeseriesuuid	Product Allocation Time SeriesUUID
	ProductAllocationObject	cvc	productallocationobject	Allocation Object
	ProdAllocCharc01	cvc	prodalloccharc01	Characteristic Value 1
	ProdAllocCharc02	cvc	prodalloccharc02	Characteristic Value 2
	ProdAllocCharc03	cvc	prodalloccharc03	Characteristic Value 3
	ProdAllocCharc04	cvc	prodalloccharc04	Characteristic Value 4
	ProdAllocCharc05	cvc	prodalloccharc05	Characteristic Value 5
	ProdAllocCharc06	cvc	prodalloccharc06	Characteristic Value 6
	ProdAllocCharc07	cvc	prodalloccharc07	Characteristic Value 7
	ProdAllocCharc08	cvc	prodalloccharc08	Characteristic Value 8
	ProdAllocCharc09	cvc	prodalloccharc09	Characteristic Value 9
	ProdAllocCharc10	cvc	prodalloccharc10	Characteristic Value 10
	ProdAllocPerdStartUTCDateTime	paobj_tmesers	prodallocperdstartutcdatetime	Period Start Date Time
	ProductAllocationObjectUUID	paobj_tmesers	productallocationobjectuuid	Product Allocation Object UUID
	CharcValueCombinationUUID	paobj_tmesers	charcvaluecombinationuuid	Characteristic Value Combination UUID
	CharcValAuthznGroup	cvc	charcvalauthzngroup	Authorization Group
	ProdAllocationActivationStatus	cvc	prodallocationactivationstatus	Activation Status
	ProdAllocCharcConstraintStatus	cvc	prodalloccharcconstraintstatus	Constraint Status
	ProdAllocCharcValueCombnCmnt	cvc	prodalloccharcvaluecombncmnt	Comment
	ProdAllocPeriodStartTimeZone	paobj_tmesers	prodallocperiodstarttimezone	Period Start Time Zone
	ProdAllocationPeriodStartDate	paobj_tmesers	prodallocationperiodstartdate	Period Start Date
	ProdAllocPeriodEndUTCDateTime	paobj_tmesers	prodallocperiodendutcdatetime	Period End Date Time
	ProdAllocPeriodEndTimeZone	paobj_tmesers	prodallocperiodendtimezone	Period End Time Zone
	ProductAllocationQuantity	paobj_tmesers	productallocationquantity	Allocation Quantity
	ProductAllocationQuantityUnit	paobj_tmesers	productallocationquantityunit	Quantity Unit

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_ProdAllocObjTimeSeriesDEX.
-- 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.

CREATE VIEW I_ProdAllocObjTimeSeriesDEX AS
SELECT
  ts.prodallocationtimeseriesuuid AS ProdAllocationTimeSeriesUUID,
  cvc.productallocationobject AS ProductAllocationObject,
  cvc.prodalloccharc01 AS ProdAllocCharc01,
  cvc.prodalloccharc02 AS ProdAllocCharc02,
  cvc.prodalloccharc03 AS ProdAllocCharc03,
  cvc.prodalloccharc04 AS ProdAllocCharc04,
  cvc.prodalloccharc05 AS ProdAllocCharc05,
  cvc.prodalloccharc06 AS ProdAllocCharc06,
  cvc.prodalloccharc07 AS ProdAllocCharc07,
  cvc.prodalloccharc08 AS ProdAllocCharc08,
  cvc.prodalloccharc09 AS ProdAllocCharc09,
  cvc.prodalloccharc10 AS ProdAllocCharc10,
  ts.prodallocperdstartutcdatetime AS ProdAllocPerdStartUTCDateTime,
  ts.productallocationobjectuuid AS ProductAllocationObjectUUID,
  ts.charcvaluecombinationuuid AS CharcValueCombinationUUID,
  cvc.charcvalauthzngroup AS CharcValAuthznGroup,
  cvc.prodallocationactivationstatus AS ProdAllocationActivationStatus,
  cvc.prodalloccharcconstraintstatus AS ProdAllocCharcConstraintStatus,
  cvc.prodalloccharcvaluecombncmnt AS ProdAllocCharcValueCombnCmnt,
  ts.prodallocperiodstarttimezone AS ProdAllocPeriodStartTimeZone,
  ts.prodallocationperiodstartdate AS ProdAllocationPeriodStartDate,
  ts.prodallocperiodendutcdatetime AS ProdAllocPeriodEndUTCDateTime,
  ts.prodallocperiodendtimezone AS ProdAllocPeriodEndTimeZone,
  ts.productallocationquantity AS ProductAllocationQuantity,
  ts.productallocationquantityunit AS ProductAllocationQuantityUnit
FROM paobj_tmesers AS ts
;

Depth:

I_ProdAllocObjTimeSeriesDEX view_entity

paobj_tmesers