I_FldLogsProcRcptSrchEnbld

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_FldLogsProcRcptSrchEnbld.
-- 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.
-- SQL view name: IFLRCPTSRCH

CREATE VIEW I_FldLogsProcRcptSrchEnbld AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  hextobin( '00000000000000000000000000000000' ) AS FldLogsSuplrItemUUID,
  MaterialDocument AS FldLogsSuplrItmMatlDoc,
  MaterialDocumentItem AS GoodsMovementItem,
  MaterialDocumentYear AS GoodsMovementYear,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  _Order.MaintPriority AS MaintPriority,
  _Order.MaintenanceOrder AS MaintenanceOrder,
  _Order.FldLogsDelivIsHeldOnShore AS FldLogsDelivIsHeldOnShore,
  QltyMgmtInProcmtIsActive,
  FldLogsPurOrdItem,
  FldLogsDelivDocItem,
  DeliveryDate,
  cast('SK' as flog_item_type preserving type ) AS FldLogsSuplrItemType,
  cast('SK' as flog_item_type preserving type ) AS FldLogsItemType,
  IsCompletelyDelivered,
  Supplier,
  Material,
  Plant,
  _Order.FldLogsRemotePlant AS FldLogsRemotePlant,
  FldLogsDelivQty,
  OpenQtyInPurchaseOrderUnit,
  FldLogsGRQty,
  FldLogsPOTotalQty,
  FldLogsBlockedQty,
  OrderQuantityUnit,
  OrderQuantityUnit AS MaterialBaseUnit,
  cast('' as boolean preserving type ) AS FldLogsItmIsPreReceived,
  I_FldLogsStockItems.StorageLocation AS StorageLocation,
  DocumentCurrency,
  NetPriceAmount,
  coalesce(_OpenPackQty.HandlingUnitQuantityUnit,OrderQuantityUnit) AS HandlingUnitQuantityUnit,
  _MaterialDetails.MaterialName AS MaterialName,
  _FldLogsInbDelivWhseTsk.EWMWarehouse AS EWMWarehouse,
  FldLogsProcRecRcvgStatus,
  PostingDate,
  DocumentDate,
  DocumentReferenceID,
  InventoryStockType,
  InventoryStockTypeName,
  GoodsMovementStatus,
  GoodsMovementType,
  InventoryValuationType,
  StockType,
  DeliveryDocumentBySupplier,
  LoadingPoint,
  UnloadingPointName,
  FldLogsSuplrItemVislInspCode,
  ReversedMaterialDocument,
  Batch,
  CreatedByUser,
  _MaterialDetails.IsBatchManagementRequired AS IsBatchManagementRequired,
  cast($session.system_date as abap.dats) AS FldLogsManufactureDate,
  case _MaterialDetails.ShelfLifeExpirationDatePeriod when ' ' then dats_add_days(cast($session.system_date as abap.dats),cast( _MaterialDetails.TotalShelfLife as abap.int4), 'UNCHANGED') when '2' then dats_add_months(cast($session.system_date as abap.dats), cast( _MaterialDetails.TotalShelfLife as abap.int4), 'UNCHANGED') when '1' then dats_add_days(cast($session.system_date as abap.dats),cast(cast( _MaterialDetails.TotalShelfLife as abap.int4) * cast(7 as abap.int4) as abap.int4), 'UNCHANGED') when '3' then dats_add_months(cast($session.system_date as abap.dats), cast(cast( _MaterialDetails.TotalShelfLife as abap.int4) * cast(12 as abap.int4) as abap.int4), 'UNCHANGED') else cast($session.system_date as abap.dats) end as FldLogsShelfLifeExpiryDate AS datsendasFldLogsShelfLifeExpiryDate,
  MaterialDocumentHeaderText,
  PurchasingDocumentSubtype,
  cast('' as boolean preserving type ) AS FldLogsIsSupplierItem,
  case when _Order.FldLogsDelivIsHeldOnShore is not initial and _Order.FldLogsRemotePlant <> Plant then cast( 'H' as flpkz preserving type ) when _Order.MaintenanceOrder is not initial and _Order.FldLogsDelivIsHeldOnShore is initial and _Order.FldLogsRemotePlant <> Plant then cast( 'C' as flpkz preserving type ) else _FldLogsInbDelivWhseTsk.FldLogsStatus end as FldLogsStatus AS FldLogsStatusendasFldLogsStatus,
  _FldLogsInbDelivWhseTsk.FldLogsStatus AS FldLogsStatusFrmEWMInbDeliv,
  MaterialGroup,
  cast(' ' as matnr ) AS PackagingMaterial,
  cast(' ' as exidv preserving type ) AS HandlingUnitExternalID,
  cast('' as hum_handlingunitid ) AS HandlingUnitId,
  PickingStatus,
  _DelivPutawayQty.FldLogsPutawayQty AS FldLogsPutawayQty,
  IsToBeAcceptedAtOrigin,
  _FldLogsInbDelivWhseTsk.EWMStockType AS FldLogsEWMStockType,
  coalesce(_DeliveryAggrgQty.FldLogsDelivOpenQty, FldLogsDelivQty) AS FldLogsOpenDelivQty,
  DistrStatusByDecentralizedWrhs,
  IsBusinessPurposeCompleted,
  SuplrCoIsBusPrpsCmpltd,
  PurchasingDocumentItemCategory,
  IsEndOfPurposeBlocked,
  IsBusPrpsCmpltdCustomer,
  cast('PO' as char2) AS FldLogsProcRcptExtUnionID,
  cast( OrderQuantity as bstmg ) AS FldLogsActlDeliveredQuantity,
  cast( FldLogsDelivQty as vmeng) AS FldLogsOpenPackQty,
  case when FldLogsProcRecRcvgStatus = '01' then cast($session.system_date as abap.dats) else PostingDate end as PostingDate AS datselsePostingDateendasPostingDate,
  case when FldLogsProcRecRcvgStatus = '01' then cast($session.system_date as abap.dats) else DocumentDate end as DocumentDate AS datselseDocumentDateendasDocumentDate,
  cast('' as boolean) AS MaterialIsSerialManaged,
  cast('' as boolean) AS FldLogsIsValnType,
  cast('00000000' as vfdat) AS FldLogsShelfLifeExpiryDate,
  I_FldLogsSuplrReceiptItem.FldLogsItmIsAtRemote AS FldLogsItmIsAtRemote
FROM I_FldLogsStockItems
LEFT OUTER JOIN I_FldLogsProcRcptMaintOrd AS _Order ON PurchaseRequisition is not initial AND _Order.PurchaseRequisition = PurchaseRequisition AND _Order.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsDelivPutawayQty AS _DelivPutawayQty ON DeliveryDocument is not initial AND ( PurchasingDocumentItemCategory = '0' OR PurchasingDocumentItemCategory = '3' ) AND DeliveryDocument = _DelivPutawayQty.DeliveryDocument AND DeliveryDocumentItem = _DelivPutawayQty.DeliveryDocumentItem  -- association [0..1]
-- UNION ALL with additional select branch(es): I_FldLogsSuplrReceiptItem
;