I_FldLogsKitRblPurrOrderItem

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_FldLogsKitRblPurrOrderItem.
-- 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_FldLogsKitRblPurrOrderItem 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(substring( _ExternalReference.PurgDocExternalReference, 1, 10 ) as banfn) AS RefPurchaseRequisition,
  cast(substring( _ExternalReference.PurgDocExternalReference, 11, 15 ) as bnfpo) AS RefPurchaseRequisitionItem,
  ParentObjectUUID,
  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_FldLogsKitPurrOrderShptItem AS _PurchaseOrderShipmentItem ON FldLogsReferenceDocumentNumber = _PurchaseOrderShipmentItem.FldLogsReferenceDocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_ExternalRefForPurgDoc AS _ExternalReference ON PurchasingDocumentUniqueID = _ExternalReference.PurchasingDocumentUniqueID AND _ExternalReference.SAPObjectNodeType = 'StockTransportRequisition' AND _ExternalReference.LinkType = 'SS' AND _ExternalReference.SequenceNumber = 1  -- association [0..1]
LEFT OUTER JOIN I_PurchaseRequisitionItemBasic AS _PurchaseRequisitionItem ON RefPurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND RefPurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsPrjMatlCompBasicData AS _MaintenanceOrderComponent ON MaintenanceOrder = _MaintenanceOrderComponent.ProjectNetwork AND MaintenanceOrderOperation = _MaintenanceOrderComponent.NetworkActivity AND MaintenanceOrderComponent = _MaintenanceOrderComponent.BillOfMaterialItemNumber AND _MaintenanceOrderComponent.MatlCompIsMarkedForDeletion = ''  -- 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]
;