I_FldLogsKitPkablOutbDelivItm

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_FldLogsKitPkablOutbDelivItm.
-- 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_FldLogsKitPkablOutbDelivItm AS
SELECT
  FieldLogisticsKitItemUUID,
  FieldLogisticsKitHeaderUUID,
  FldLogsKitItmRefDocument1,
  FldLogsKitItmRefDocument2,
  _DeliveryItem.DeliveryDocumentItemText AS ItemDescription,
  _DeliveryItem.StorageBin AS StorageBin,
  _DeliveryItem.ActualDeliveryQuantity AS Quantity,
  _DeliveryItem.DeliveryQuantityUnit AS BaseUnit,
  _DeliveryItem._DeliveryDocument.DeliveryDate AS DeliveryDate,
  _DeliveryItem.Material AS Material,
  LastChangeDateTime,
  _FldLogsEWMRefDoc.DeliveryUUID AS DeliveryUUID,
  _FldLogsEWMRefDoc.DeliveryItemUUID AS DeliveryItemUUID,
  _FldLogsEWMRefDoc._EWMOutboundDelivOrder.EWMOutboundDeliveryOrder AS EWMOutboundDeliveryOrder,
  _FldLogsEWMRefDoc._EWMOutboundDelivOrder.EWMWarehouse AS EWMWarehouse,
  ParentObjectUUID,
  cast( _ParentNodeMO.FldLogsKitItmRefDocument1 as abap.char(12) ) AS MaintenanceOrder,
  cast( _ParentNodePO.FldLogsKitItmRefDocument1 as abap.char(10) ) AS PurchaseOrder,
  cast( _ParentNodePO.FldLogsKitItmRefDocument2 as abap.numc(5) ) AS PurchaseOrderItem,
  _OutboundDelivery.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM I_FldLogsKitOutbDeliveryItem
LEFT OUTER JOIN I_FldLogsKitOutbDelivShptItem AS _PurchaseOrderShipmentItem ON FldLogsKitItmRefDocument1 = _PurchaseOrderShipmentItem.OutboundDelivery AND FldLogsKitItmRefDocument2 = _PurchaseOrderShipmentItem.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_EWM_OutbDelivOrdSts AS _PickingStatus ON deliveryuuid = _PickingStatus.OutboundDeliveryOrderUUID AND deliveryitemuuid = _PickingStatus.OutboundDeliveryOrderItemUUID AND _PickingStatus.DeliveryStatusType = 'DPI'  -- association [0..1]
LEFT OUTER JOIN I_FieldLogisticsKitItem AS _ParentNodeMO ON FieldLogisticsKitHeaderUUID = _ParentNodeMO.FieldLogisticsKitHeaderUUID AND ParentObjectUUID = _ParentNodeMO.FieldLogisticsKitItemUUID AND _ParentNodeMO.FldLogsReferenceDocCategory = 'PM'  -- association [0..1]
LEFT OUTER JOIN I_FieldLogisticsKitItem AS _ParentNodePO ON FieldLogisticsKitHeaderUUID = _ParentNodePO.FieldLogisticsKitHeaderUUID AND ParentObjectUUID = _ParentNodePO.FieldLogisticsKitItemUUID AND _ParentNodePO.FldLogsReferenceDocCategory = 'PO'  -- association [0..1]
LEFT OUTER JOIN I_ChgImpactPurDocAcctAssign AS _PurOrdAccAssgmt ON PurchaseOrder = _PurOrdAccAssgmt.PurchasingDocument AND PurchaseOrderItem = _PurOrdAccAssgmt.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseRequestOutItem AS _WarehouseRequestOutItem ON deliveryuuid = _WarehouseRequestOutItem.EWMWarehouseRequestUUID AND deliveryitemuuid = _WarehouseRequestOutItem.EWMWarehouseRequestItemUUID AND deliveryuuid is not null  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSupplierItemRecord AS _SupplierItem ON FldLogsKitItmRefDocument1 = _SupplierItem.OutboundDelivery AND FldLogsKitItmRefDocument2 = _SupplierItem.OutboundDeliveryItem  -- association [0..1]
;