I_FldLogsKitPurchaseOrderItem

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_FldLogsKitPurchaseOrderItem.
-- 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_FldLogsKitPurchaseOrderItem AS
SELECT
  FieldLogisticsKitItemUUID,
  FieldLogisticsKitHeaderUUID,
  FldLogsKitItmRefDocument1,
  FldLogsKitItmRefDocument2,
  FldLogsKitItmRefDocument3,
  fldlogskititmrefdocumentuuid1 AS FldLogsKitItmRefDocument1UUID,
  ParentObjectUUID,
  LastChangeDateTime,
  cast(_PurchaseOrderItem.PurchaseOrderItemText as maktx preserving type ) AS ItemDescription,
  _ScheduleLine.ScheduleLineDeliveryDate AS FldLogsKitPlannedDeliveryDate,
  _PurchaseOrderItem.OrderQuantity AS OrderQuantity,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  _PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  _PurchaseOrderItem.PurchaseRequisition AS PurchaseRequisition,
  _PurchaseOrderItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  cast(concat(_PurchaseOrderItem.PurchaseRequisition, _PurchaseOrderItem.PurchaseRequisitionItem) as purgdocnodeuniqueid) AS PurchasingDocumentUniqueID,
  _PurchaseOrderItem.Material AS Material,
  _PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _ParentNode.FldLogsKitDispatchOnHold AS FldLogsKitDispatchOnHold,
  case when _PurchaseOrderItem._PurchaseOrder.SupplyingPlant is initial then _PurchaseOrderItem.Plant else _PurchaseOrderItem._PurchaseOrder.SupplyingPlant end as FldLogsSrcePlnt AS SupplyingPlantendasFldLogsSrcePlnt,
  _MaterialDocumentRecord.MaterialDocument AS MaterialDocument
FROM flog_kititem
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON FldLogsKitItmRefDocument1 = _PurchaseOrderItem.PurchaseOrder AND FldLogsKitItmRefDocument2 = _PurchaseOrderItem.PurchaseOrderItem  -- association [1]
LEFT OUTER JOIN I_PurgDocScheduleLine AS _ScheduleLine ON FldLogsKitItmRefDocument1 = _ScheduleLine.PurchasingDocument AND FldLogsKitItmRefDocument2 = _ScheduleLine.PurchasingDocumentItem AND _ScheduleLine.ScheduleLine = '0001'  -- association [1]
LEFT OUTER JOIN I_FldLogsKitMatlDocAggrgdQty AS _AggrgdQty ON FldLogsKitItmRefDocument1 = _AggrgdQty.PurchaseOrder AND FldLogsKitItmRefDocument2 = _AggrgdQty.PurchaseOrderItem  -- association [1]
LEFT OUTER JOIN I_FldLogsKitOutbDelivAggrgdQty AS _OutbDelivAggrgdQty ON FldLogsKitItmRefDocument1 = _OutbDelivAggrgdQty.PurchasingDocument AND FldLogsKitItmRefDocument2 = _OutbDelivAggrgdQty.PurchasingDocumentItem  -- association [1]
LEFT OUTER JOIN I_FieldLogisticsKit AS _ParentNode ON FieldLogisticsKitHeaderUUID = _ParentNode.FieldLogisticsKitHeaderUUID AND ParentObjectUUID = _ParentNode.FieldLogisticsKitItemUUID  -- association [1]
LEFT OUTER JOIN I_FldLogsSupplierItem AS _SupplierItem ON FldLogsReferenceDocumentNumber = _SupplierItem.FldLogsSuplrItmPOItmUniqueID  -- association [1]
LEFT OUTER JOIN I_ChgImpactPurDocAcctAssign AS _PurOrdAccAssgmt ON FldLogsKitItmRefDocument1 = _PurOrdAccAssgmt.PurchasingDocument AND FldLogsKitItmRefDocument2 = _PurOrdAccAssgmt.PurchasingDocumentItem  -- association [1]
LEFT OUTER JOIN I_FieldLogisticsKit AS _ParentNodePO ON FieldLogisticsKitHeaderUUID = _ParentNodePO.FieldLogisticsKitHeaderUUID AND FieldLogisticsKitItemUUID = _ParentNodePO.FieldLogisticsKitItemUUID  -- association [1]
LEFT OUTER JOIN I_MaterialDocumentRecord AS _MaterialDocumentRecord ON FldLogsKitItmRefDocument1 = _MaterialDocumentRecord.PurchaseOrder AND FldLogsKitItmRefDocument2 = _MaterialDocumentRecord.PurchaseOrderItem AND _MaterialDocumentRecord.GoodsMovementIsCancelled = '' AND _MaterialDocumentRecord.IsAutomaticallyCreated = '' AND _MaterialDocumentRecord.MaterialDocumentRecordType = 'MDOC' AND _MaterialDocumentRecord.StockIdfgStorageLocation <> '' AND ( _MaterialDocumentRecord.GoodsMovementType = '105' OR _MaterialDocumentRecord.GoodsMovementType = '109' )  -- association [1]
;