P_ProdAllocOvwOrderItem

DDL: P_PRODALLOCOVWORDERITEM Type: view_entity CONSUMPTION Package: PRODUCT_ALLOCATION_OBJECT
18 Fields 3 Data Sources 3 Associations

ProdAllocOvwOrderItem

P_ProdAllocOvwOrderItem is a Consumption CDS View that provides data about "ProdAllocOvwOrderItem" in SAP S/4HANA. It reads from 3 data sources (I_ProdAllocCharcMetaDataTP, I_ProdAllocObjCharcValCombn, P_ProdAllocQuantityAssignment) and exposes 18 fields with key fields ProdAllocAssignedOrder, ProdAllocAssignedOrderItem, ProdAllocAssignedOrderType. It has 3 associations to related views. Part of development package PRODUCT_ALLOCATION_OBJECT.

Data Sources (3)

SourceAliasJoin Type
I_ProdAllocCharcMetaDataTP _ProdAllocCharcMetaDataTP left_outer
I_ProdAllocObjCharcValCombn _ProdAllocObjCharcValCombn left_outer
P_ProdAllocQuantityAssignment _ProdAllocQuantityAssignment from

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_ProdAllocSalesSchedLine _ProdAllocSalesSchedLine $projection.ProdAllocAssignedOrder = _ProdAllocSalesSchedLine.SalesDocument and $projection.ProdAllocAssignedOrderItem = _ProdAllocSalesSchedLine.SalesDocumentItem
[0..1] P_ProdAllocStkTransptSchedLine _ProdAllocStkTransptSchedLine $projection.ProdAllocAssignedOrder = _ProdAllocStkTransptSchedLine.PurchaseOrder and $projection.PurchaseOrderItem = _ProdAllocStkTransptSchedLine.PurchaseOrderItem
[0..1] I_ProdAllocATPStatusT _ProdAllocATPStatusT $projection.ProdAllocATPStatus = _ProdAllocATPStatusT.ProdAllocATPStatus and _ProdAllocATPStatusT.Language = $session.system_language

Annotations (6)

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

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocAssignedOrder P_ProdAllocQuantityAssignment ProdAllocAssignedOrder Assigned Order
KEY ProdAllocAssignedOrderItem P_ProdAllocQuantityAssignment ProdAllocAssignedOrderItem Assigned Order Item
KEY ProdAllocAssignedOrderType P_ProdAllocQuantityAssignment ProdAllocAssignedOrderType Order Type
OrderItem
PurchaseOrderItem P_ProdAllocQuantityAssignment PurchaseOrderItem Purchasing Document Item
ProductAllocationObject I_ProdAllocObjCharcValCombn ProductAllocationObject Allocation Object
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
_ProdAllocATPStatusT _ProdAllocATPStatusT

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_ProdAllocOvwOrderItem.
-- 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_ProdAllocOvwOrderItem AS
SELECT
  _ProdAllocQuantityAssignment.ProdAllocAssignedOrder AS ProdAllocAssignedOrder,
  _ProdAllocQuantityAssignment.ProdAllocAssignedOrderItem AS ProdAllocAssignedOrderItem,
  _ProdAllocQuantityAssignment.ProdAllocAssignedOrderType AS ProdAllocAssignedOrderType,
  concat( _ProdAllocQuantityAssignment.ProdAllocAssignedOrderType, concat(_ProdAllocQuantityAssignment.ProdAllocAssignedOrder, _ProdAllocQuantityAssignment.ProdAllocAssignedOrderItem) ) AS OrderItem,
  _ProdAllocQuantityAssignment.PurchaseOrderItem AS PurchaseOrderItem,
  _ProdAllocObjCharcValCombn.ProductAllocationObject AS ProductAllocationObject,
  _ProdAllocObjCharcValCombn.ProdAllocCharc01 AS ProdAllocCharc01,
  _ProdAllocObjCharcValCombn.ProdAllocCharc02 AS ProdAllocCharc02,
  _ProdAllocObjCharcValCombn.ProdAllocCharc03 AS ProdAllocCharc03,
  _ProdAllocObjCharcValCombn.ProdAllocCharc04 AS ProdAllocCharc04,
  _ProdAllocObjCharcValCombn.ProdAllocCharc05 AS ProdAllocCharc05,
  _ProdAllocObjCharcValCombn.ProdAllocCharc06 AS ProdAllocCharc06,
  _ProdAllocObjCharcValCombn.ProdAllocCharc07 AS ProdAllocCharc07,
  _ProdAllocObjCharcValCombn.ProdAllocCharc08 AS ProdAllocCharc08,
  _ProdAllocObjCharcValCombn.ProdAllocCharc09 AS ProdAllocCharc09,
  _ProdAllocObjCharcValCombn.ProdAllocCharc10 AS ProdAllocCharc10,
  _ProdAllocObjCharcValCombn.CharcValAuthznGroup AS CharcValAuthznGroup
FROM P_ProdAllocQuantityAssignment AS _ProdAllocQuantityAssignment
LEFT OUTER JOIN I_ProdAllocObjCharcValCombn AS _ProdAllocObjCharcValCombn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdAllocCharcMetaDataTP AS _ProdAllocCharcMetaDataTP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ProdAllocSalesSchedLine AS _ProdAllocSalesSchedLine ON ProdAllocAssignedOrder = _ProdAllocSalesSchedLine.SalesDocument AND ProdAllocAssignedOrderItem = _ProdAllocSalesSchedLine.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN P_ProdAllocStkTransptSchedLine AS _ProdAllocStkTransptSchedLine ON ProdAllocAssignedOrder = _ProdAllocStkTransptSchedLine.PurchaseOrder AND PurchaseOrderItem = _ProdAllocStkTransptSchedLine.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocATPStatusT AS _ProdAllocATPStatusT ON ProdAllocATPStatus = _ProdAllocATPStatusT.ProdAllocATPStatus AND _ProdAllocATPStatusT.Language = $session.system_language  -- association [0..1]
;

Learn More