I_ProdAllocObjTimeSeriesDEX

DDL: I_PRODALLOCOBJTIMESERIESDEX Type: view_entity BASIC
31 Fields 1 Data Sources 6 Associations

Product Allocation Object Time Series

I_ProdAllocObjTimeSeriesDEX (Basic)

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

ProdAllocObjTimeSeries · Manufacturing

I_ProdAllocObjTimeSeriesDEX is a Basic CDS View (Dimension) that provides data about "Product Allocation Object Time Series" in SAP S/4HANA. It reads from 1 data source (paobj_tmesers) and exposes 31 fields with key field ProdAllocationTimeSeriesUUID. It has 6 associations to related views.

SAP Help Documentation

CategoryCDS Views for Product Allocation
Data CategoryDimension
StatusConstraint 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 →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentCA-ATP-PAL
CapabilitiesData Source for Data Extraction, Data Provider for Analytical Queries, Association Target for Defining CDS Entities, Analytical Dimension
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view extracts product allocation time series of characteristic value combinations of allocation objects, with planned quantities. </p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>Which time series exist for a product allocation object and a characteristic value combination?</p></li> </ul> <p>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.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
paobj_tmesers ts from

Associations (6)

CardinalityTargetAliasCondition
[0..*] I_ProdAllocQtyAssignmentDEX _ProdAllocQtyAssignmentDEX $projection.CharcValueCombinationUUID = _ProdAllocQtyAssignmentDEX.CharcValueCombinationUUID and $projection.ProdAllocPerdStartUTCDateTime = _ProdAllocQtyAssignmentDEX.ProdAllocPerdStartUTCDateTime
[0..1] I_TimeZone _ProdAllocPeriodStartTimeZone $projection.ProdAllocPeriodStartTimeZone = _ProdAllocPeriodStartTimeZone.TimeZoneID
[0..1] I_TimeZone _ProdAllocPeriodEndTimeZone $projection.ProdAllocPeriodEndTimeZone = _ProdAllocPeriodEndTimeZone.TimeZoneID
[0..1] I_UnitOfMeasure _ProductAllocationQuantityUnit $projection.ProductAllocationQuantityUnit = _ProductAllocationQuantityUnit.UnitOfMeasure
[0..1] I_ProdAllocActivationStatus _ProdAllocActivationStatus $projection.ProdAllocationActivationStatus = _ProdAllocActivationStatus.ProdAllocationActivationStatus
[0..1] I_ProdAllocCharcCstrtStatus _ProdAllocCharcCstrtStatus $projection.ProdAllocCharcConstraintStatus = _ProdAllocCharcCstrtStatus.ProdAllocCharcConstraintStatus

Annotations (17)

NameValueLevelField
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 #BLOCKED_DATA_INCLUDED view
ObjectModel.representativeKey ProdAllocationTimeSeriesUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name ProdAllocObjTimeSeries view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.technicalName IPAOBJTMESERSDEX view
Analytics.internalName #LOCAL view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (31)

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

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
LEFT OUTER JOIN I_ProdAllocQtyAssignmentDEX AS _ProdAllocQtyAssignmentDEX ON CharcValueCombinationUUID = _ProdAllocQtyAssignmentDEX.CharcValueCombinationUUID AND ProdAllocPerdStartUTCDateTime = _ProdAllocQtyAssignmentDEX.ProdAllocPerdStartUTCDateTime  -- association [0..*]
LEFT OUTER JOIN I_TimeZone AS _ProdAllocPeriodStartTimeZone ON ProdAllocPeriodStartTimeZone = _ProdAllocPeriodStartTimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _ProdAllocPeriodEndTimeZone ON ProdAllocPeriodEndTimeZone = _ProdAllocPeriodEndTimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductAllocationQuantityUnit ON ProductAllocationQuantityUnit = _ProductAllocationQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocActivationStatus AS _ProdAllocActivationStatus ON ProdAllocationActivationStatus = _ProdAllocActivationStatus.ProdAllocationActivationStatus  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCharcCstrtStatus AS _ProdAllocCharcCstrtStatus ON ProdAllocCharcConstraintStatus = _ProdAllocCharcCstrtStatus.ProdAllocCharcConstraintStatus  -- association [0..1]
;

Learn More