I_FldLogsKitRcvdPurrOrderItem

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_FldLogsKitRcvdPurrOrderItem.
-- 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_FldLogsKitRcvdPurrOrderItem AS
SELECT
  FieldLogisticsKitItemUUID,
  FieldLogisticsKitHeaderUUID,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  PurchaseOrder,
  PurchaseOrderItem,
  QuantityInBaseUnit AS Quantity,
  MaterialBaseUnit AS BaseUnit,
  _PurchaseOrderItem.ItemDescription AS ItemDescription,
  dats_add_days($session.system_date, cast(_PurchaseOrderItem._PurchaseOrderItem.PlannedDeliveryDurationInDays as int1), 'UNCHANGED') AS FldLogsKitPlannedDeliveryDate,
  Material,
  LastChangeDateTime,
  case when _PurchaseOrderItem._SupplierItem.FldLogsSuplrBasePlant is not initial then _PurchaseOrderItem._SupplierItem.FldLogsSuplrBasePlant else _PurchaseOrderItem.FldLogsSrcePlnt end as FldLogsSrcePlnt AS FldLogsSrcePlntendasFldLogsSrcePlnt,
  case when _PurchaseOrderItem.AccountAssignmentCategory = 'F' then _PurchaseOrderItem._PurOrdAccAssgmt.ProductionOrder else cast(_PurchaseOrderItem._ParentNode.FldLogsKitItmRefDocument1 as abap.char(12)) end as MaintenanceOrder AS char12endasMaintenanceOrder,
  cast(_PurchaseOrderItem._ParentNode.FldLogsKitItmRefDocument2 as abap.char(4)) AS MaintenanceOrderOperation,
  cast(_PurchaseOrderItem._ParentNode.FldLogsKitItmRefDocument3 as abap.char(4)) AS MaintenanceOrderComponent,
  _PurchasingDocument.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _DocLinks.StockTransportOrder AS StockTransportOrder,
  _DocLinks.StockTransportOrderItem AS StockTransportOrderItem,
  _PurchaseOrderItem.FldLogsReferenceDocumentNumber AS FldLogsReferenceDocumentNumber,
  _PurchaseOrderItem._SupplierItem AS _SupplierItem,
  FldLogsKitDispatchOnHold
FROM I_FldLogsKitMatlDocumentItem
LEFT OUTER JOIN I_FldLogsKitPurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1]
LEFT OUTER JOIN I_FldLogsKitMatlDocumentItem AS _ReversedMatDocItem ON MaterialDocumentYear = _ReversedMatDocItem.ReversedMaterialDocumentYear AND MaterialDocument = _ReversedMatDocItem.ReversedMaterialDocument AND MaterialDocumentItem = _ReversedMatDocItem.ReversedMaterialDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsKitPurrOrderShptItem AS _PurchaseOrderShipmentItem ON fldlogsreferencedocumentnumber = _PurchaseOrderShipmentItem.FldLogsReferenceDocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_FldLogsKitOutbDelivAggrgdQty AS _OutboundDeliveryQuantity ON PurchaseOrder = _OutboundDeliveryQuantity.PurchasingDocument AND PurchaseOrderItem = _OutboundDeliveryQuantity.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderComponent AS _MaintenanceOrderComponent ON MaintenanceOrder = _MaintenanceOrderComponent.MaintenanceOrder AND MaintenanceOrderOperation = _MaintenanceOrderComponent.MaintenanceOrderOperation AND MaintenanceOrderComponent = _MaintenanceOrderComponent.MaintenanceOrderComponent  -- association [1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchaseOrder = _PurchasingDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_FldLogsExtLinksForPurDocs AS _DocLinks ON MaterialDocumentYear = _DocLinks.MaterialDocumentYear AND MaterialDocument = _DocLinks.MaterialDocument AND MaterialDocumentItem = _DocLinks.MaterialDocumentItem  -- association [0..1]
;