I_FldLogsPurchasingItem

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_FldLogsPurchasingItem.
-- 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_FldLogsPurchasingItem AS
SELECT
  _PurchasingDocumentItem.PurchasingDocument AS PurchasingDocument,
  _PurchasingDocumentItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  coalesce( _DeliveryItem.DeliveryDocument, ' ') AS DeliveryDocument,
  coalesce( _DeliveryItem.DeliveryDocumentItem, '000000' ) AS DeliveryDocumentItem,
  _PurchasingDocumentItem.PurchaseRequisition AS PurchaseRequisition,
  _PurchasingDocumentItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  concat(concat(_PurchasingDocumentItem.PurchasingDocument, '/'), _PurchasingDocumentItem.PurchasingDocumentItem) AS FldLogsPurOrdItem,
  concat(concat(_DeliveryItem.DeliveryDocument, '/'), _DeliveryItem.DeliveryDocumentItem) AS FldLogsDelivDocItem,
  _PurchasingDocumentItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  _PurchasingDocumentItem.Material AS Material,
  _PurchasingDocumentItem.Plant AS Plant,
  _PurchasingDocumentItem.StockType AS TargetStockType,
  coalesce( _DeliveryItem.DeliveryDate,_POOpenQty.DeliveryDate ) AS DeliveryDate,
  cast( coalesce( _DeliveryItem.ActualDeliveryQuantity,0) as lfimg ) AS FldLogsDelivQty,
  _DeliveryItem.DeliveryQuantityUnit AS DeliveryQuantityUnit,
  _POOpenQty.OpenQtyInPurchaseOrderUnit AS OpenQtyInPurchaseOrderUnit,
  cast( coalesce( _OpenBlockedItems.FldLogsBlockedQty, 0 ) as lfimg ) AS FldLogsBlockedQty,
  cast( coalesce( _ReceivedItems.FldLogsTotalReceivedQty, 0 ) as lfimg ) AS FldLogsTotalReceivedQty,
  _PurchasingDocumentItem.OrderQuantity AS FldLogsPOTotalQty,
  _PurchasingDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  case when _PurchasingDocumentItem._PurchasingDocument.PurchasingDocumentSubtype = 'T' then _PurchasingDocumentItem.StorageLocation else coalesce(_DeliveryItem.StorageLocation,_PurchasingDocumentItem.StorageLocation ) end as StorageLocation AS StorageLocationendasStorageLocation,
  coalesce(_DeliveryItem.Batch,_POOpenQty.Batch) AS Batch,
  _PurchasingDocumentItem.DocumentCurrency AS DocumentCurrency,
  _PurchasingDocumentItem.NetPriceAmount AS NetPriceAmount,
  _PurchasingDocumentItem._PurchasingDocument.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _PurchasingDocumentItem._PurchasingDocument.Supplier AS Supplier,
  _PurchasingDocumentItem.MaterialGroup AS MaterialGroup,
  _PurchasingDocumentItem._PurchasingDocument AS _PurchasingDocument,
  _PurchasingDocumentItem._Plant AS _Plant,
  _DeliveryItem.DeliveryDocument AS InboundDelivery,
  _DeliveryItem.GoodsMovementStatus AS GoodsMovementStatus,
  _DeliveryItem.ActualDeliveryQuantity AS ActualDeliveryQuantity,
  coalesce(_DeliveryItem.InventoryValuationType, _PurchasingDocumentItem.ValuationType) AS InventoryValuationType,
  _DeliveryItem.FldLogsStatus AS FldLogsStatus,
  _DeliveryItem.DistrStatusByDecentralizedWrhs AS DistrStatusByDecentralizedWrhs,
  _DeliveryItem.DeliveryDocumentBySupplier AS DeliveryDocumentBySupplier,
  _DeliveryItem.LoadingPoint AS LoadingPoint,
  _DeliveryItem.UnloadingPointName AS UnloadingPointName,
  _DeliveryItem.PickingStatus AS PickingStatus,
  cast('' as boolean) AS IsToBeAcceptedAtOrigin,
  _PurchasingDocumentItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurchasingDocumentItem._PurchasingDocument.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _ShipToParty.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _SoldToParty.IsBusinessPurposeCompleted AS IsBusPrpsCmpltdCustomer,
  _DeliveryItem._Supplier.IsBusinessPurposeCompleted AS SuplrCoIsBusPrpsCmpltd,
  _MaterialDetails.MaterialType AS MaterialType
FROM I_PurchasingDocumentItem AS _PurchasingDocumentItem
INNER JOIN I_FieldLogisticsPlantAll AS _FldLogsAllPlants ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FldLogsPurOrdOpenQty AS _POOpenQty ON PurchasingDocument = _POOpenQty.PurchasingDocument AND PurchasingDocumentItem = _POOpenQty.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsValuationType AS _ValuationType ON _PurchasingDocumentItem.Material = _ValuationType.Material AND _PurchasingDocumentItem.Plant = _ValuationType.Plant  -- association [0..*]
LEFT OUTER JOIN I_FldLogsMaterialDetails AS _MaterialDetails ON _PurchasingDocumentItem.Material = _MaterialDetails.Material  -- association [0..1]
LEFT OUTER JOIN I_FldLogsMaterialPlantDetails AS _ProductPlant ON _PurchasingDocumentItem.Material = _ProductPlant.Material AND _PurchasingDocumentItem.Plant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_FldLogsAggregateBlockedQty AS _OpenBlockedItems ON PurchasingDocument = _OpenBlockedItems.PurchaseOrder AND PurchasingDocumentItem = _OpenBlockedItems.PurchaseOrderItem AND _DeliveryItem.DeliveryDocument = _OpenBlockedItems.DeliveryDocument AND _DeliveryItem.DeliveryDocumentItem = _OpenBlockedItems.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsAggregateReceivedQty AS _ReceivedItems ON PurchasingDocument = _ReceivedItems.PurchaseOrder AND PurchasingDocumentItem = _ReceivedItems.PurchaseOrderItem AND _DeliveryItem.DeliveryDocument = _ReceivedItems.DeliveryDocument AND _DeliveryItem.DeliveryDocumentItem = _ReceivedItems.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsInbDelivWhseTsk AS _FldLogsInbDelivWhseTsk ON _DeliveryItem.DistrStatusByDecentralizedWrhs is not initial AND DeliveryDocumentItem = _FldLogsInbDelivWhseTsk.DeliveryDocumentItem AND _DeliveryItem.DeliveryDocument = _FldLogsInbDelivWhseTsk.DeliveryDocument  -- association [0..1]
LEFT OUTER JOIN I_FldLogsAggregateDelivQty AS _DeliveryAggrgQty ON _DeliveryItem.DeliveryDocument is not initial AND _DeliveryItem.DeliveryDocument = _DeliveryAggrgQty.DeliveryDocument AND DeliveryDocumentItem = _DeliveryAggrgQty.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsOpenPackQty AS _OpenPackQty ON _DeliveryItem.DeliveryDocument is not initial AND _DeliveryItem.DeliveryDocument = _OpenPackQty.DeliveryDocument AND DeliveryDocumentItem = _OpenPackQty.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON _DeliveryItem.SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON _DeliveryItem.ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_FldLogsNonEvalMatConfig AS _config ON _PurchasingDocumentItem.Plant = _config.Plant AND _PurchasingDocumentItem.MaterialType = _config.MaterialType  -- association [0..1]
;