P_VrtlProdAllocQtyAssignment

DDL: P_VRTLPRODALLOCQTYASSIGNMENT Type: view_entity COMPOSITE
13 Fields 1 Data Sources

P_VrtlProdAllocQtyAssignment is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ProdAllocPerdsValCombnOrdItm) and exposes 13 fields with key fields ProdAllocAssignedOrder, ProdAllocAssignedOrderItem, ProdAllocAssignedOrderType, CharcValueCombinationUUID, ProdAllocPerdStartUTCDateTime.

Data Sources (1)

SourceAliasJoin Type
P_ProdAllocPerdsValCombnOrdItm TS from

Annotations (6)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocAssignedOrder P_ProdAllocPerdsValCombnOrdItm ProdAllocAssignedOrder Assigned Order
KEY ProdAllocAssignedOrderItem P_ProdAllocPerdsValCombnOrdItm ProdAllocAssignedOrderItem Assigned Order Item
KEY ProdAllocAssignedOrderType P_ProdAllocPerdsValCombnOrdItm ProdAllocAssignedOrderType Order Type
KEY CharcValueCombinationUUID P_ProdAllocPerdsValCombnOrdItm CharcValueCombinationUUID Characteristic Value Combination UUID
KEY ProdAllocPerdStartUTCDateTime P_ProdAllocPerdsValCombnOrdItm ProdAllocPerdStartUTCDateTime Period Start Date Time
PurchaseOrderItem P_ProdAllocPerdsValCombnOrdItm PurchaseOrderItem Purchasing Document Item
ProdAllocPeriodStartTimeZone P_ProdAllocPerdsValCombnOrdItm ProdAllocPeriodStartTimeZone Period Start Time Zone
ProdAllocPeriodEndUTCDateTime P_ProdAllocPerdsValCombnOrdItm ProdAllocPeriodEndUTCDateTime Period End Date Time
ProdAllocPeriodEndTimeZone P_ProdAllocPerdsValCombnOrdItm ProdAllocPeriodEndTimeZone Period End Time Zone
ProdAllocAssignedQuantity P_ProdAllocPerdsValCombnOrdItm ProdAllocAssignedQuantity Assigned Quantity
ProdAllocAssignedQuantityUnit P_ProdAllocPerdsValCombnOrdItm ProdAllocAssignedQuantityUnit Assigned Quantity Unit
ProdAllocSqncConstraintUUID P_ProdAllocPerdsValCombnOrdItm ProdAllocSqncConstraintUUID Product Allocation Sequence Constraint UUID
ProdAllocSqncCstrtCnsmpnUnit P_ProdAllocPerdsValCombnOrdItm 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_VrtlProdAllocQtyAssignment.
-- 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_VrtlProdAllocQtyAssignment AS
SELECT
  TS.ProdAllocAssignedOrder AS ProdAllocAssignedOrder,
  TS.ProdAllocAssignedOrderItem AS ProdAllocAssignedOrderItem,
  TS.ProdAllocAssignedOrderType AS ProdAllocAssignedOrderType,
  TS.CharcValueCombinationUUID AS CharcValueCombinationUUID,
  TS.ProdAllocPerdStartUTCDateTime AS ProdAllocPerdStartUTCDateTime,
  TS.PurchaseOrderItem AS PurchaseOrderItem,
  TS.ProdAllocPeriodStartTimeZone AS ProdAllocPeriodStartTimeZone,
  TS.ProdAllocPeriodEndUTCDateTime AS ProdAllocPeriodEndUTCDateTime,
  TS.ProdAllocPeriodEndTimeZone AS ProdAllocPeriodEndTimeZone,
  TS.ProdAllocAssignedQuantity AS ProdAllocAssignedQuantity,
  TS.ProdAllocAssignedQuantityUnit AS ProdAllocAssignedQuantityUnit,
  TS.ProdAllocSqncConstraintUUID AS ProdAllocSqncConstraintUUID,
  TS.ProdAllocSqncCstrtCnsmpnUnit AS ProdAllocSqncCstrtCnsmpnUnit
FROM P_ProdAllocPerdsValCombnOrdItm AS TS
;

Learn More