P_ProdAllocStkTranspReqdQty

DDL: P_PRODALLOCSTKTRANSPREQDQTY Type: view_entity COMPOSITE
7 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
P_AllocStkTranspQtyAssgmtPerd qaperd 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 (7)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocAssignedOrder P_AllocStkTranspQtyAssgmtPerd ProdAllocAssignedOrder Assigned Order
KEY ProdAllocAssignedOrderItem P_AllocStkTranspQtyAssgmtPerd ProdAllocAssignedOrderItem Assigned Order Item
KEY ProdAllocAssignedOrderType P_AllocStkTranspQtyAssgmtPerd ProdAllocAssignedOrderType Order Type
KEY ProdAllocPerdStartUTCDateTime P_AllocStkTranspQtyAssgmtPerd ProdAllocPerdStartUTCDateTime Period Start Date Time
KEY CharcValueCombinationUUID P_AllocStkTranspQtyAssgmtPerd CharcValueCombinationUUID Characteristic Value Combination UUID
BaseUnit
RequestedQuantity

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_ProdAllocStkTranspReqdQty.
-- 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_ProdAllocStkTranspReqdQty AS
SELECT
  qaperd.ProdAllocAssignedOrder AS ProdAllocAssignedOrder,
  qaperd.ProdAllocAssignedOrderItem AS ProdAllocAssignedOrderItem,
  qaperd.ProdAllocAssignedOrderType AS ProdAllocAssignedOrderType,
  qaperd.ProdAllocPerdStartUTCDateTime AS ProdAllocPerdStartUTCDateTime,
  qaperd.CharcValueCombinationUUID AS CharcValueCombinationUUID,
  cast( _ReqdAllocStkTransptSchedLine.BaseUnit as meins preserving type ) AS BaseUnit,
  cast( sum( _ReqdAllocStkTransptSchedLine.ScheduleLineOrderQuantity ) as pal_requestedquantity ) AS RequestedQuantity
FROM P_AllocStkTranspQtyAssgmtPerd AS qaperd
;

Learn More