I_FldLogsKitRblPurMaintOrdDet

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_FldLogsKitRblPurMaintOrdDet.
-- 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_FldLogsKitRblPurMaintOrdDet AS
SELECT
  FieldLogisticsKitItemUUID,
  FieldLogisticsKitHeaderUUID,
  FldLogsKitItmRefDocument1,
  FldLogsKitItmRefDocument2,
  FldLogsKitItmRefDocument1UUID,
  FldLogsReferenceDocumentNumber,
  ItemDescription,
  FldLogsKitPlannedDeliveryDate,
  cast((cast(OrderQuantity as abap.dec( 18, 3 )) - coalesce(_AggrgdQty.NumberOfReceivedParts, 0)) as abap.quan( 13, 3 )) AS Quantity,
  PurchaseOrderQuantityUnit AS BaseUnit,
  PurchaseOrder,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  LastChangeDateTime,
  Material,
  PurchasingDocumentUniqueID,
  cast(_ParentNode.FldLogsKitItmRefDocument1 as abap.char(12)) AS MaintenanceOrder,
  cast(_ParentNode.FldLogsKitItmRefDocument2 as abap.char(4)) AS MaintenanceOrderOperation,
  cast(_ParentNode.FldLogsKitItmRefDocument3 as abap.char(4)) AS MaintenanceOrderComponent,
  AccountAssignmentCategory,
  _PurchasingDocument.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM I_FldLogsKitPurchaseOrderItem
LEFT OUTER JOIN I_FldLogsPrjMatlCompBasicData AS _MaintenanceOrderComponent ON MaintenanceOrder = _MaintenanceOrderComponent.ProjectNetwork AND MaintenanceOrderOperation = _MaintenanceOrderComponent.NetworkActivity AND MaintenanceOrderComponent = _MaintenanceOrderComponent.BillOfMaterialItemNumber  -- association [1]
LEFT OUTER JOIN I_FieldLogisticsOrder AS _FldLogsOrder ON MaintenanceOrder = _FldLogsOrder.OrderID  -- association [1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchaseOrder = _PurchasingDocument.PurchasingDocument  -- association [1..1]
;