What is P_MntrProdAllocOrderItemPerds in SAP S/4HANA?

P_MntrProdAllocOrderItemPerds is a consumption CDS view in SAP S/4HANA. Monitor Product Allocation Order Item Periods It contains 32 fields.

Which tables does P_MntrProdAllocOrderItemPerds read from?

P_MntrProdAllocOrderItemPerds reads data from: P_ProdAllocQuantityAssignment.

What VDM layer is P_MntrProdAllocOrderItemPerds?

P_MntrProdAllocOrderItemPerds is classified as a Consumption view optimized for specific business scenarios and reporting.

P_MntrProdAllocOrderItemPerds

DDL: P_MNTRPRODALLOCORDERITEMPERDS SQL: PMPAORDITMPERDS Type: view CONSUMPTION Package: PRODUCT_ALLOCATION_OBJECT

32 Fields 1 Data Sources

Monitor Product Allocation Order Item Periods

P_MntrProdAllocOrderItemPerds is a Consumption CDS View that provides data about "Monitor Product Allocation Order Item Periods" in SAP S/4HANA. It reads from 1 data source (P_ProdAllocQuantityAssignment) and exposes 32 fields with key fields ProdAllocAssignedOrder, ProdAllocAssignedOrderItem, ProdAllocAssignedOrderType, ProdAllocPerdStartUTCDateTime, ConfirmationUTCDateTime. Part of development package PRODUCT_ALLOCATION_OBJECT.

Data Sources (1)

Source	Alias	Join Type
P_ProdAllocQuantityAssignment	P_ProdAllocQuantityAssignment	from

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	PMPAORDITMPERDS	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Monitor Product Allocation Order Item Periods	view
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (32)

Key	Field	Source Table	Source Field	Description
KEY	ProdAllocAssignedOrder		ProdAllocAssignedOrder	Assigned Order
KEY	ProdAllocAssignedOrderItem		ProdAllocAssignedOrderItem	Assigned Order Item
KEY	ProdAllocAssignedOrderType		ProdAllocAssignedOrderType	Order Type
KEY	ProdAllocPerdStartUTCDateTime		ProdAllocPerdStartUTCDateTime	Period Start Date Time
KEY	ConfirmationUTCDateTime		ConfirmationUTCDateTime	Confirmation Date Time
KEY	AssignmentSequenceNumberValue			Assignment Sequence Number
	ProdAllocationPeriodStartDate
	ProdAllocationConfirmationDate
	ProductAllocationPeriodEndDate
	ProdAllocCharc01	I_ProdAllocObjCharcValCombn	ProdAllocCharc01	Characteristic Value 1
	ProdAllocCharc02	I_ProdAllocObjCharcValCombn	ProdAllocCharc02	Characteristic Value 2
	ProdAllocCharc03	I_ProdAllocObjCharcValCombn	ProdAllocCharc03	Characteristic Value 3
	ProdAllocCharc04	I_ProdAllocObjCharcValCombn	ProdAllocCharc04	Characteristic Value 4
	ProdAllocCharc05	I_ProdAllocObjCharcValCombn	ProdAllocCharc05	Characteristic Value 5
	ProdAllocCharc06	I_ProdAllocObjCharcValCombn	ProdAllocCharc06	Characteristic Value 6
	ProdAllocCharc07	I_ProdAllocObjCharcValCombn	ProdAllocCharc07	Characteristic Value 7
	ProdAllocCharc08	I_ProdAllocObjCharcValCombn	ProdAllocCharc08	Characteristic Value 8
	ProdAllocCharc09	I_ProdAllocObjCharcValCombn	ProdAllocCharc09	Characteristic Value 9
	ProdAllocCharc10	I_ProdAllocObjCharcValCombn	ProdAllocCharc10	Characteristic Value 10
	CharcValAuthznGroup	I_ProdAllocObjCharcValCombn	CharcValAuthznGroup	Authorization Group
	CharcValueCombinationUUID	P_ProdAllocQuantityAssignment	CharcValueCombinationUUID	Characteristic Value Combination UUID
	ConfirmationDateTimeType		ConfirmationDateTimeType	Confirmation Date Type
	ProductAllocationObject	I_ProdAllocObjCharcValCombn	ProductAllocationObject	Allocation Object
	ProductAllocationObjectUUID	I_ProdAllocObjCharcValCombn	ProductAllocationObjectUUID	Product Allocation Object UUID
	ProdAllocSqncConstraintUUID	P_ProdAllocQuantityAssignment	ProdAllocSqncConstraintUUID	Product Allocation Sequence Constraint UUID
	ProductAllocationSequenceUUID
	ProdAllocSqncGrpPriorityValue
	ProdAllocAssignedQuantityUnit		ProdAllocAssignedQuantityUnit	Assigned Quantity Unit
	ProdAllocAssignedQuantity			Assigned Quantity
	ProdAllocSqncCstrtCnsmpnUnit	P_ProdAllocQuantityAssignment	ProdAllocSqncCstrtCnsmpnUnit	Constraint Consumption Unit
	_ConfirmationDateTimeType		_ConfirmationDateTimeType
	_ProdAllocSequenceConstraint	P_ProdAllocQuantityAssignment	_ProdAllocSequenceConstraint

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 P_MntrProdAllocOrderItemPerds.
-- 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: PMPAORDITMPERDS

CREATE VIEW P_MntrProdAllocOrderItemPerds AS
SELECT
  ProdAllocAssignedOrder,
  ProdAllocAssignedOrderItem,
  ProdAllocAssignedOrderType,
  ProdAllocPerdStartUTCDateTime,
  ConfirmationUTCDateTime,
  cast(AssignmentSequenceNumberValue as prodalloccnsmpnordervalue) AS AssignmentSequenceNumberValue,
  tstmp_to_dats(ProdAllocPerdStartUTCDateTime, ProdAllocPeriodStartTimeZone, $session.client , 'INITIAL') AS ProdAllocationPeriodStartDate,
  tstmp_to_dats(ConfirmationUTCDateTime, ConfirmationTimeZone, $session.client , 'INITIAL') AS ProdAllocationConfirmationDate,
  tstmp_to_dats(ProdAllocPeriodEndUTCDateTime, ProdAllocPeriodEndTimeZone, $session.client , 'INITIAL') AS ProductAllocationPeriodEndDate,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc01 AS ProdAllocCharc01,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc02 AS ProdAllocCharc02,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc03 AS ProdAllocCharc03,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc04 AS ProdAllocCharc04,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc05 AS ProdAllocCharc05,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc06 AS ProdAllocCharc06,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc07 AS ProdAllocCharc07,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc08 AS ProdAllocCharc08,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc09 AS ProdAllocCharc09,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc10 AS ProdAllocCharc10,
  I_ProdAllocObjCharcValCombn.CharcValAuthznGroup AS CharcValAuthznGroup,
  P_ProdAllocQuantityAssignment.CharcValueCombinationUUID AS CharcValueCombinationUUID,
  ConfirmationDateTimeType,
  I_ProdAllocObjCharcValCombn.ProductAllocationObject AS ProductAllocationObject,
  I_ProdAllocObjCharcValCombn.ProductAllocationObjectUUID AS ProductAllocationObjectUUID,
  P_ProdAllocQuantityAssignment.ProdAllocSqncConstraintUUID AS ProdAllocSqncConstraintUUID,
  P_ProdAllocQuantityAssignment._ProdAllocSequenceConstraint.ProductAllocationSequenceUUID AS ProductAllocationSequenceUUID,
  P_ProdAllocQuantityAssignment._ProdAllocSequenceConstraint._ProdAllocationSequenceGroup.ProdAllocSqncGrpPriorityValue AS ProdAllocSqncGrpPriorityValue,
  ProdAllocAssignedQuantityUnit,
  cast(ProdAllocAssignedQuantity as prodalloccnsmdqtyinallocunit) AS ProdAllocAssignedQuantity,
  P_ProdAllocQuantityAssignment.ProdAllocSqncCstrtCnsmpnUnit AS ProdAllocSqncCstrtCnsmpnUnit,
  P_ProdAllocQuantityAssignment._ProdAllocSequenceConstraint AS _ProdAllocSequenceConstraint
FROM P_ProdAllocQuantityAssignment
;

Depth:

P_MntrProdAllocOrderItemPerds view

P_ProdAllocQuantityAssignment view_entity

C_MntrProdAllocOrderItemPerds view