I_DFS_ActlFltgMatlOrdDlvrdQty

DDL: I_DFS_ACTLFLTGMATLORDDLVRDQTY Type: view_entity COMPOSITE
27 Fields 1 Data Sources 2 Associations

PO Delivery Quantity for Material

I_DFS_ActlFltgMatlOrdDlvrdQty is a Composite CDS View that provides data about "PO Delivery Quantity for Material" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 27 fields with key fields Material, Plant, StorageLocation, PurchaseOrder, PurchaseOrderItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem _PurchaseOrderItem from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_PurgDocScheduleLine _PurgDocScheduleLine _PurchaseOrderItem.PurchaseOrder = _PurgDocScheduleLine.PurchasingDocument and _PurchaseOrderItem.PurchaseOrderItem = _PurgDocScheduleLine.PurchasingDocumentItem
[1..1] I_PurgDocAccountAssignment _PurgDocAccountAssignment _PurchaseOrderItem.PurchaseOrder = _PurgDocAccountAssignment.PurchasingDocument and _PurchaseOrderItem.PurchaseOrderItem = _PurgDocAccountAssignment.PurchasingDocumentItem and _PurgDocAccountAssignment.AccountAssignmentNumber = '01'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PO Delivery Quantity for Material view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY Material I_PurchaseOrderItem Material Vehicle Model
KEY Plant _DeliveryDocumentItem Plant Valuation Area
KEY StorageLocation _DeliveryDocumentItem StorageLocation StorageLocation
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY ScheduleLine _PurgDocScheduleLine ScheduleLine Schedule Line
KEY AccountAssignmentNumber _PurgDocAccountAssignment AccountAssignmentNumber Account Assgmt No.
KEY DeliveryDocument _DeliveryDocumentItem DeliveryDocument Outbound Delivery
KEY DeliveryDocumentItem _DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
KEY PurchaseRequisition I_PurchaseOrderItem PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_PurchaseOrderItem PurchaseRequisitionItem Requisn. item
KEY DocRelationshipUUID _SDDocumentMultiLevelProcFlow DocRelationshipUUID
IsCompletelyDelivered I_PurchaseOrderItem IsCompletelyDelivered Is completely delivered
OriginPlant I_PurchaseOrderItem Plant Valuation Area
SourceStorageLocation I_PurchaseOrderItem StorageLocation StorageLocation
SupplyingPlant
SupplyingStorageLocation I_PurchaseOrderItem IssuingStorageLocation Iss. Stor. Loc.
PurchaseOrderQuantityUnit I_PurchaseOrderItem PurchaseOrderQuantityUnit Order Unit
WBSElementInternalID _PurgDocAccountAssignment WBSElementInternalID_2
Batch _PurgDocScheduleLine Batch Lot No.
SDDocumentCategory _DeliveryDocumentItem SDDocumentCategory Document Cat.
PrecedingDocumentCategory _SDDocumentMultiLevelProcFlow PrecedingDocumentCategory
SubsequentDocumentCategory _SDDocumentMultiLevelProcFlow SubsequentDocumentCategory
SDFulfillmentCalculationRule _SDDocumentMultiLevelProcFlow SDFulfillmentCalculationRule
OrderQuantity _PurgDocScheduleLine ScheduleLineOrderQuantity Scheduled Qty
ScheduleLineIssuedQuantity _PurgDocScheduleLine ScheduleLineIssuedQuantity
RoughGoodsReceiptQty _PurgDocScheduleLine RoughGoodsReceiptQty Delivered

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 I_DFS_ActlFltgMatlOrdDlvrdQty.
-- 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 I_DFS_ActlFltgMatlOrdDlvrdQty AS
SELECT
  _PurchaseOrderItem.Material AS Material,
  _DeliveryDocumentItem.Plant AS Plant,
  _DeliveryDocumentItem.StorageLocation AS StorageLocation,
  _PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  _PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  _PurgDocScheduleLine.ScheduleLine AS ScheduleLine,
  _PurgDocAccountAssignment.AccountAssignmentNumber AS AccountAssignmentNumber,
  _DeliveryDocumentItem.DeliveryDocument AS DeliveryDocument,
  _DeliveryDocumentItem.DeliveryDocumentItem AS DeliveryDocumentItem,
  _PurchaseOrderItem.PurchaseRequisition AS PurchaseRequisition,
  _PurchaseOrderItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _SDDocumentMultiLevelProcFlow.DocRelationshipUUID AS DocRelationshipUUID,
  _PurchaseOrderItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  _PurchaseOrderItem.Plant AS OriginPlant,
  _PurchaseOrderItem.StorageLocation AS SourceStorageLocation,
  _PurchaseOrderItem._PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  _PurchaseOrderItem.IssuingStorageLocation AS SupplyingStorageLocation,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _PurgDocAccountAssignment.WBSElementInternalID_2 AS WBSElementInternalID,
  _PurgDocScheduleLine.Batch AS Batch,
  _DeliveryDocumentItem.SDDocumentCategory AS SDDocumentCategory,
  _SDDocumentMultiLevelProcFlow.PrecedingDocumentCategory AS PrecedingDocumentCategory,
  _SDDocumentMultiLevelProcFlow.SubsequentDocumentCategory AS SubsequentDocumentCategory,
  _SDDocumentMultiLevelProcFlow.SDFulfillmentCalculationRule AS SDFulfillmentCalculationRule,
  _PurgDocScheduleLine.ScheduleLineOrderQuantity AS OrderQuantity,
  _PurgDocScheduleLine.ScheduleLineIssuedQuantity AS ScheduleLineIssuedQuantity,
  _PurgDocScheduleLine.RoughGoodsReceiptQty AS RoughGoodsReceiptQty
FROM I_PurchaseOrderItem AS _PurchaseOrderItem
LEFT OUTER JOIN I_PurgDocScheduleLine AS _PurgDocScheduleLine ON _PurchaseOrderItem.PurchaseOrder = _PurgDocScheduleLine.PurchasingDocument AND _PurchaseOrderItem.PurchaseOrderItem = _PurgDocScheduleLine.PurchasingDocumentItem  -- association [1..*]
LEFT OUTER JOIN I_PurgDocAccountAssignment AS _PurgDocAccountAssignment ON _PurchaseOrderItem.PurchaseOrder = _PurgDocAccountAssignment.PurchasingDocument AND _PurchaseOrderItem.PurchaseOrderItem = _PurgDocAccountAssignment.PurchasingDocumentItem AND _PurgDocAccountAssignment.AccountAssignmentNumber = '01'  -- association [1..1]
;

Learn More