P_AllProdAllocQtyAssignment

DDL: P_ALLPRODALLOCQTYASSIGNMENT Type: view_entity COMPOSITE Package: PRODUCT_ALLOCATION_OBJECT
24 Fields 2 Data Sources

All Product Allocation Quantity Assignment

P_AllProdAllocQtyAssignment is a Composite CDS View that provides data about "All Product Allocation Quantity Assignment" in SAP S/4HANA. It reads from 2 data sources (P_ProdAllocQuantityAssignment, P_VrtlProdAllocQtyAssignment) and exposes 24 fields with key fields ProdAllocAssignedOrder, ProdAllocAssignedOrderItem, ProdAllocAssignedOrderType, CharcValueCombinationUUID, ProdAllocPerdStartUTCDateTime. Part of development package PRODUCT_ALLOCATION_OBJECT.

Data Sources (2)

SourceAliasJoin Type
P_ProdAllocQuantityAssignment P_ProdAllocQuantityAssignment union_all
P_VrtlProdAllocQtyAssignment P_VrtlProdAllocQtyAssignment from

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocAssignedOrder ProdAllocAssignedOrder Assigned Order
KEY ProdAllocAssignedOrderItem ProdAllocAssignedOrderItem Assigned Order Item
KEY ProdAllocAssignedOrderType ProdAllocAssignedOrderType Order Type
KEY CharcValueCombinationUUID CharcValueCombinationUUID Characteristic Value Combination UUID
KEY ProdAllocPerdStartUTCDateTime ProdAllocPerdStartUTCDateTime Period Start Date Time
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
ProdAllocPeriodStartTimeZone ProdAllocPeriodStartTimeZone Period Start Time Zone
ProdAllocPeriodEndUTCDateTime ProdAllocPeriodEndUTCDateTime Period End Date Time
ProdAllocPeriodEndTimeZone ProdAllocPeriodEndTimeZone Period End Time Zone
ProdAllocAssignedQuantity
ProdAllocAssignedQuantityUnit ProdAllocAssignedQuantityUnit Assigned Quantity Unit
ProdAllocSqncConstraintUUID ProdAllocSqncConstraintUUID Product Allocation Sequence Constraint UUID
KEY ProdAllocAssignedOrderItem ProdAllocAssignedOrderItem Assigned Order Item
KEY ProdAllocAssignedOrderType ProdAllocAssignedOrderType Order Type
KEY CharcValueCombinationUUID CharcValueCombinationUUID Characteristic Value Combination UUID
KEY ProdAllocPerdStartUTCDateTime ProdAllocPerdStartUTCDateTime Period Start Date Time
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
ProdAllocPeriodStartTimeZone ProdAllocPeriodStartTimeZone Period Start Time Zone
ProdAllocPeriodEndUTCDateTime ProdAllocPeriodEndUTCDateTime Period End Date Time
ProdAllocPeriodEndTimeZone ProdAllocPeriodEndTimeZone Period End Time Zone
ProdAllocAssignedQuantity
ProdAllocAssignedQuantityUnit ProdAllocAssignedQuantityUnit Assigned Quantity Unit
ProdAllocSqncConstraintUUID ProdAllocSqncConstraintUUID Product Allocation Sequence Constraint UUID
ProdAllocSqncCstrtCnsmpnUnit ProdAllocSqncCstrtCnsmpnUnit Constraint Consumption 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 P_AllProdAllocQtyAssignment.
-- 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 P_AllProdAllocQtyAssignment AS
SELECT
  ProdAllocAssignedOrder,
  ProdAllocAssignedOrderItem,
  ProdAllocAssignedOrderType,
  CharcValueCombinationUUID,
  ProdAllocPerdStartUTCDateTime,
  PurchaseOrderItem,
  ProdAllocPeriodStartTimeZone,
  ProdAllocPeriodEndUTCDateTime,
  ProdAllocPeriodEndTimeZone,
  sum(ProdAllocAssignedQuantity) AS ProdAllocAssignedQuantity,
  ProdAllocAssignedQuantityUnit,
  ProdAllocSqncConstraintUUID,
  ProdAllocSqncCstrtCnsmpnUnit
FROM P_VrtlProdAllocQtyAssignment
-- UNION ALL with additional select branch(es): P_ProdAllocQuantityAssignment
;

Learn More