What is I_ProdAllocQtyAssignmentDEX in SAP S/4HANA?

I_ProdAllocQtyAssignmentDEX is a basic CDS view in SAP S/4HANA. Product Allocation Quantity Assignment It contains 40 fields.

Which tables does I_ProdAllocQtyAssignmentDEX read from?

I_ProdAllocQtyAssignmentDEX reads data from: paqtyassgmt.

What VDM layer is I_ProdAllocQtyAssignmentDEX?

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

I_ProdAllocQtyAssignmentDEX

DDL: I_PRODALLOCQTYASSIGNMENTDEX Type: view_entity BASIC

40 Fields 1 Data Sources 9 Associations

Product Allocation Quantity Assignment

I_ProdAllocQtyAssignmentDEX is a Basic CDS View (Cube) that provides data about "Product Allocation Quantity Assignment" in SAP S/4HANA. It reads from 1 data source (paqtyassgmt) and exposes 40 fields with key fields ProdAllocAssignedOrder, ProdAllocAssignedOrderItem, ProdAllocAssignedOrderType, CharcValueCombinationUUID, ProdAllocPerdStartUTCDateTime. It has 9 associations to related views.

SAP Help Documentation

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

Purpose
This CDS view extracts product allocation consumption data like order items, allocation objects, characteristic value combinations, assigned quantities, and dates. This CDS view provides the data to answer the following business questions: What are the order items that consume allocations Which product allocation objects and characteristic value combinations are affected by consumption? Which quantities are consumed and at which date? 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 Measure or Attribute ProdAllocAssignedOrder Assigned order Attribute ProdAllocAssignedOrderItem Assigned order item Attribute ProdAllocAssignedOrderType Assigned order type Attribute ProdAllocPerdStartUTCDateTime Period start date time in UTC Measure ConfirmationUTCDateTime Confirmation date time in UTC Measure AssignmentSequenceNumberValue Assignment sequence number Measure ProductAllocationObject Product allocation object Attribute ProdAllocCharc01 - - ProdAllocCharc10 Characteristic values 1 - 10 Attribute ProdAllocationActivationStatus Activation status Attribute ProdAllocCharcConstraintStatus Constraint status Attribute ProdAllocPeriodStartTimeZone Time zone of period start Attribute ConfirmationTimeZone Confirmation time zone Attribute ProdAllocPeriodEndUTCDateTime Period end date time in UTC Measure ProdAllocPeriodEndTimeZone Time zone of period end Attribute ProdAllocAssignedQuantity Assigned quantity Measure ProdAllocAssignedQuantityUnit Assigned quantity unit Attribute ConfirmationDateTimeType Confirmation date time type Attribute

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
paqtyassgmt	qa	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..1]	I_ProdAllocObjTimeSeriesDEX	_ProdAllocObjTimeSeriesDEX	`$projection.CharcValueCombinationUUID = _ProdAllocObjTimeSeriesDEX.CharcValueCombinationUUID and $projection.ProdAllocPerdStartUTCDateTime = _ProdAllocObjTimeSeriesDEX.ProdAllocPerdStartUTCDateTime`
[0..1]	I_TimeZone	_ProdAllocPeriodStartTimeZone	`$projection.ProdAllocPeriodStartTimeZone = _ProdAllocPeriodStartTimeZone.TimeZoneID`
[0..1]	I_TimeZone	_ProdAllocPeriodEndTimeZone	`$projection.ProdAllocPeriodEndTimeZone = _ProdAllocPeriodEndTimeZone.TimeZoneID`
[0..1]	I_TimeZone	_ConfirmationTimeZone	`$projection.ConfirmationTimeZone = _ConfirmationTimeZone.TimeZoneID`
[0..1]	I_UnitOfMeasure	_ProdAllocAssignedQuantityUnit	`$projection.ProdAllocAssignedQuantityUnit = _ProdAllocAssignedQuantityUnit.UnitOfMeasure`
[0..1]	I_ConfirmationDateTimeType	_ConfirmationDateTimeType	`$projection.ConfirmationDateTimeType = _ConfirmationDateTimeType.ConfirmationDateTimeType`
[0..1]	I_ProdAllocActivationStatus	_ProdAllocActivationStatus	`$projection.ProdAllocationActivationStatus = _ProdAllocActivationStatus.ProdAllocationActivationStatus`
[0..1]	I_ProdAllocCharcCstrtStatus	_ProdAllocCharcCstrtStatus	`$projection.ProdAllocCharcConstraintStatus = _ProdAllocCharcCstrtStatus.ProdAllocCharcConstraintStatus`
[0..1]	I_ProdAllocAssignedOrderType	_ProdAllocAssignedOrderType	`$projection.ProdAllocAssignedOrderType = _ProdAllocAssignedOrderType.ProdAllocAssignedOrderType`

Annotations (16)

Name	Value	Level
EndUserText.label	Product Allocation Quantity Assignment	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.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.sapObjectNodeType.name	ProdAllocQuantityAssignment	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
Analytics.technicalName	IPAQTYASSGMTDEX	view
Analytics.internalName	#LOCAL	view
Analytics.dataCategory	#CUBE	view
Analytics.dataExtraction.enabled	true	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (40)

Key	Field	Source Table	Source Field	Description
KEY	ProdAllocAssignedOrder	paqtyassgmt	prodallocassignedorder	Assigned Order
KEY	ProdAllocAssignedOrderItem	paqtyassgmt	prodallocassignedorderitem	Assigned Order Item
KEY	ProdAllocAssignedOrderType	paqtyassgmt	prodallocassignedordertype	Order Type
KEY	CharcValueCombinationUUID	paqtyassgmt	charcvaluecombinationuuid	Characteristic Value Combination UUID
KEY	ProdAllocPerdStartUTCDateTime	paqtyassgmt	prodallocperdstartutcdatetime	Period Start Date Time
KEY	ConfirmationUTCDateTime	paqtyassgmt	confirmationutcdatetime	Confirmation Date Time
KEY	AssignmentSequenceNumberValue	paqtyassgmt	assignmentsequencenumbervalue	Assignment Sequence Number
	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
	CharcValAuthznGroup	cvc	charcvalauthzngroup	Authorization Group
	ProdAllocationActivationStatus	cvc	prodallocationactivationstatus	Activation Status
	ProdAllocCharcConstraintStatus	cvc	prodalloccharcconstraintstatus	Constraint Status
	ProdAllocCharcValueCombnCmnt	cvc	prodalloccharcvaluecombncmnt	Comment
	ProdAllocPeriodStartTimeZone	paqtyassgmt	prodallocperiodstarttimezone	Period Start Time Zone
	ConfirmationTimeZone	paqtyassgmt	confirmationtimezone	Confirmation Time Zone
	ProdAllocPeriodEndUTCDateTime	paqtyassgmt	prodallocperiodendutcdatetime	Period End Date Time
	ProdAllocPeriodEndTimeZone	paqtyassgmt	prodallocperiodendtimezone	Period End Time Zone
	ProdAllocAssignedQuantity	paqtyassgmt	prodallocassignedquantity	Assigned Quantity
	ProdAllocAssignedQuantityUnit	paqtyassgmt	prodallocassignedquantityunit	Assigned Quantity Unit
	ConfirmationDateTimeType	paqtyassgmt	confirmationdatetimetype	Confirmation Date Type
	CreationDateTime	paqtyassgmt	creationdatetime	Timestamp
	LastChangeDateTime	paqtyassgmt	lastchangedatetime	Timestamp
	_ProdAllocObjTimeSeriesDEX		_ProdAllocObjTimeSeriesDEX
	_ProdAllocActivationStatus		_ProdAllocActivationStatus
	_ProdAllocCharcCstrtStatus		_ProdAllocCharcCstrtStatus
	_ConfirmationDateTimeType		_ConfirmationDateTimeType
	_ProdAllocPeriodStartTimeZone		_ProdAllocPeriodStartTimeZone
	_ProdAllocPeriodEndTimeZone		_ProdAllocPeriodEndTimeZone
	_ConfirmationTimeZone		_ConfirmationTimeZone
	_ProdAllocAssignedQuantityUnit		_ProdAllocAssignedQuantityUnit
	_ProdAllocAssignedOrderType		_ProdAllocAssignedOrderType

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_ProdAllocQtyAssignmentDEX.
-- 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_ProdAllocQtyAssignmentDEX AS
SELECT
  qa.prodallocassignedorder AS ProdAllocAssignedOrder,
  qa.prodallocassignedorderitem AS ProdAllocAssignedOrderItem,
  qa.prodallocassignedordertype AS ProdAllocAssignedOrderType,
  qa.charcvaluecombinationuuid AS CharcValueCombinationUUID,
  qa.prodallocperdstartutcdatetime AS ProdAllocPerdStartUTCDateTime,
  qa.confirmationutcdatetime AS ConfirmationUTCDateTime,
  qa.assignmentsequencenumbervalue AS AssignmentSequenceNumberValue,
  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,
  cvc.charcvalauthzngroup AS CharcValAuthznGroup,
  cvc.prodallocationactivationstatus AS ProdAllocationActivationStatus,
  cvc.prodalloccharcconstraintstatus AS ProdAllocCharcConstraintStatus,
  cvc.prodalloccharcvaluecombncmnt AS ProdAllocCharcValueCombnCmnt,
  qa.prodallocperiodstarttimezone AS ProdAllocPeriodStartTimeZone,
  qa.confirmationtimezone AS ConfirmationTimeZone,
  qa.prodallocperiodendutcdatetime AS ProdAllocPeriodEndUTCDateTime,
  qa.prodallocperiodendtimezone AS ProdAllocPeriodEndTimeZone,
  qa.prodallocassignedquantity AS ProdAllocAssignedQuantity,
  qa.prodallocassignedquantityunit AS ProdAllocAssignedQuantityUnit,
  qa.confirmationdatetimetype AS ConfirmationDateTimeType,
  qa.creationdatetime AS CreationDateTime,
  qa.lastchangedatetime AS LastChangeDateTime
FROM paqtyassgmt AS qa
LEFT OUTER JOIN I_ProdAllocObjTimeSeriesDEX AS _ProdAllocObjTimeSeriesDEX ON CharcValueCombinationUUID = _ProdAllocObjTimeSeriesDEX.CharcValueCombinationUUID AND ProdAllocPerdStartUTCDateTime = _ProdAllocObjTimeSeriesDEX.ProdAllocPerdStartUTCDateTime  -- association [0..1]
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_TimeZone AS _ConfirmationTimeZone ON ConfirmationTimeZone = _ConfirmationTimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProdAllocAssignedQuantityUnit ON ProdAllocAssignedQuantityUnit = _ProdAllocAssignedQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ConfirmationDateTimeType AS _ConfirmationDateTimeType ON ConfirmationDateTimeType = _ConfirmationDateTimeType.ConfirmationDateTimeType  -- 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]
LEFT OUTER JOIN I_ProdAllocAssignedOrderType AS _ProdAllocAssignedOrderType ON ProdAllocAssignedOrderType = _ProdAllocAssignedOrderType.ProdAllocAssignedOrderType  -- association [0..1]
;

Depth:

I_ProdAllocQtyAssignmentDEX view_entity

paqtyassgmt