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,
  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,
  FldLogsDelivQty,
  OpenQtyInPurchaseOrderUnit,
  FldLogsGRQty,
  EntryUnit AS GoodsMovementEntryUnit,
  OrderQuantityUnit AS POUnitOfMeasure,
  FldLogsPOTotalQty,
  FldLogsBlockedQty,
  OrderQuantityUnit,
  cast('' as boolean preserving type ) AS FldLogsItmIsPreReceived,
  DocumentCurrency,
  NetPriceAmount,
  coalesce(_OpenPackQty.HandlingUnitQuantityUnit,OrderQuantityUnit) AS HandlingUnitQuantityUnit,
  FldLogsProcRecRcvgStatus,
  PostingDate,
  DocumentDate,
  DocumentReferenceID,
  InventoryStockType,
  InventoryStockTypeName,
  GoodsMovementStatus,
  GoodsMovementType,
  InventoryValuationType,
  InventoryUsabilityCode,
  DeliveryDocumentBySupplier,
  LoadingPoint,
  UnloadingPointName,
  FldLogsSuplrItemVislInspCode,
  ReversedMaterialDocument,
  Batch,
  CreatedByUser,
  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,
  MaterialGroup,
  cast(' ' as matnr ) AS PackagingMaterial,
  cast(' ' as exidv preserving type ) AS HandlingUnitExternalID,
  cast('' as hum_handlingunitid ) AS HandlingUnitId,
  PickingStatus,
  cast( 0 as rfmng ) AS FldLogsPutawayQty,
  IsToBeAcceptedAtOrigin,
  coalesce(_DeliveryAggrgQty.FldLogsDelivOpenQty, FldLogsDelivQty) AS FldLogsOpenDelivQty,
  DistrStatusByDecentralizedWrhs,
  IsBusinessPurposeCompleted,
  SuplrCoIsBusPrpsCmpltd,
  PurchasingDocumentItemCategory,
  IsEndOfPurposeBlocked,
  IsBusPrpsCmpltdCustomer,
  cast('PO' as char2) AS FldLogsProcRcptExtUnionID,
  cast(' ' as aufnr ) AS MaintenanceOrder,
  cast(' ' as flog_hold) AS FldLogsDelivIsHeldOnShore,
  FldLogsRemotePlant,
  cast( OrderQuantity as bstmg ) AS FldLogsActlDeliveredQuantity,
  OrderQuantityUnit AS MaterialBaseUnit,
  StorageLocation,
  cast( FldLogsDelivQty as vmeng) AS FldLogsOpenPackQty,
  MaterialName,
  EWMWarehouse,
  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 xchpf) AS IsBatchManagementRequired,
  cast('' as boolean) AS FldLogsIsValnType,
  cast('00000000' as vfdat) AS FldLogsShelfLifeExpiryDate,
  FldLogsStatusFrmEWMInbDeliv,
  cast(''as /scdl/dl_stock_category) AS FldLogsEWMStockType,
  I_FldLogsSuplrReceiptItem.MaintPriority AS MaintPriority,
  I_FldLogsSuplrReceiptItem.OrderCategory AS OrderCategory,
  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]
-- UNION ALL with additional select branch(es): I_FldLogsSuplrReceiptItem
;