I_FldLogsProcessReceiptsTP

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_FldLogsProcessReceiptsTP.
-- 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: IFLPRTP

CREATE VIEW I_FldLogsProcessReceiptsTP AS
SELECT
  _PO.PurchasingDocument AS PurchasingDocument,
  _PO.PurchasingDocumentItem AS PurchasingDocumentItem,
  SearchEnabled.DeliveryDocument AS DeliveryDocument,
  SearchEnabled.DeliveryDocumentItem AS DeliveryDocumentItem,
  SearchEnabled.MaterialDocument AS MaterialDocument,
  SearchEnabled.MaterialDocumentItem AS MaterialDocumentItem,
  SearchEnabled.MaterialDocumentYear AS MaterialDocumentYear,
  SearchEnabled.FldLogsSuplrItemUUID AS FldLogsSuplrItemUUID,
  SearchEnabled.FldLogsSuplrItmMatlDoc AS FldLogsSuplrItmMatlDoc,
  SearchEnabled.GoodsMovementItem AS GoodsMovementItem,
  SearchEnabled.GoodsMovementYear AS GoodsMovementYear,
  SearchEnabled.FldLogsPurOrdItem AS FldLogsPurOrdItem,
  SearchEnabled.FldLogsDelivDocItem AS FldLogsDelivDocItem,
  SearchEnabled.DeliveryDate AS DeliveryDate,
  cast('' as abap.char(20)) AS FldLogsSuplrItmDelivStatusText,
  _ItemType.FldLogsSuplrItemTypeText AS FldLogsSuplrItemTypeText,
  SearchEnabled.FldLogsItemType AS FldLogsItemType,
  SearchEnabled.IsCompletelyDelivered AS IsCompletelyDelivered,
  SearchEnabled.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  SearchEnabled.Material AS Material,
  _PO.Material AS Product,
  _SupplierItem.FldLogsSuplrItemSerialNumber AS FldLogsSuplrItemSerialNumber,
  SearchEnabled.Plant AS Plant,
  SearchEnabled.FldLogsRemotePlant AS FldLogsRemotePlant,
  _PlantName.PlantName AS PlantName,
  SearchEnabled.FldLogsDelivQty AS FldLogsDelivQty,
  SearchEnabled.OpenQtyInPurchaseOrderUnit AS OpenQtyInPurchaseOrderUnit,
  SearchEnabled.FldLogsGRQty AS FldLogsGRQty,
  SearchEnabled.GoodsMovementEntryUnit AS GoodsMovementEntryUnit,
  SearchEnabled.POUnitOfMeasure AS POUnitOfMeasure,
  SearchEnabled.FldLogsReversedQty AS FldLogsReversedQty,
  SearchEnabled.FldLogsPOTotalQty AS FldLogsPOTotalQty,
  SearchEnabled.FldLogsBlockedQty AS FldLogsBlockedQty,
  SearchEnabled.FldLogsActlDeliveredQuantity AS FldLogsActlDeliveredQuantity,
  SearchEnabled.OrderQuantityUnit AS OrderQuantityUnit,
  SearchEnabled.MaterialBaseUnit AS MaterialBaseUnit,
  SearchEnabled.PlanningMaterialBaseUnit AS PlanningMaterialBaseUnit,
  SearchEnabled.FldLogsItmIsToBeReceived AS FldLogsItmIsToBeReceived,
  SearchEnabled.FldLogsItmIsReceived AS FldLogsItmIsReceived,
  SearchEnabled.FldLogsItmIsFailed AS FldLogsItmIsFailed,
  SearchEnabled.FldLogsItmIsPreReceived AS FldLogsItmIsPreReceived,
  SearchEnabled.StorageLocation AS StorageLocation,
  SearchEnabled.DocumentCurrency AS DocumentCurrency,
  SearchEnabled.NetPriceAmount AS NetPriceAmount,
  SearchEnabled.FldLogsOpenPackQty AS FldLogsOpenPackQty,
  SearchEnabled.MaterialName AS MaterialName,
  SearchEnabled.MaintPriority AS MaintPriority,
  _GenericPriorityText.GenericPriorityDesc AS GenericPriorityDesc,
  SearchEnabled.FldLogsDelivIsHeldOnShore AS FldLogsDelivIsHeldOnShore,
  SearchEnabled.QltyMgmtInProcmtIsActive AS QltyMgmtInProcmtIsActive,
  SearchEnabled.EWMWarehouse AS EWMWarehouse,
  SearchEnabled.FldLogsProcRecRcvgStatus AS FldLogsProcRecRcvgStatus,
  _FldLogsProcRcptRcvgStatus.FldLogsProcRcptRcvgStatusTxt AS FldLogsProcRcptRcvgStatusTxt,
  SearchEnabled.PostingDate AS PostingDate,
  SearchEnabled.DocumentDate AS DocumentDate,
  SearchEnabled.DocumentReferenceID AS DocumentReferenceID,
  SearchEnabled.GoodsMovementStatus AS GoodsMovementStatus,
  SearchEnabled.GoodsMovementType AS GoodsMovementType,
  SearchEnabled.InventoryValuationType AS InventoryValuationType,
  _GoodsMovementTypeT.GoodsMovementTypeName AS GoodsMovementTypeName,
  SearchEnabled.InventoryUsabilityCode AS InventoryUsabilityCode,
  SearchEnabled.InventoryUsabilityCode AS StockType,
  _StockTypeText.StockTypeName AS StockTypeName,
  SearchEnabled.DeliveryDocumentBySupplier AS DeliveryDocumentBySupplier,
  SearchEnabled.LoadingPoint AS LoadingPoint,
  SearchEnabled.FldLogsSuplrItemVislInspCode AS FldLogsSuplrItemVislInspCode,
  _FldLogsSuplrItmVislInspText.FldLogsSuplrItemVislInspText AS FldLogsSuplrItemVislInspText,
  SearchEnabled.ReversedMaterialDocument AS ReversedMaterialDocument,
  SearchEnabled.Batch AS Batch,
  SearchEnabled.CreatedByUser AS CreatedByUser,
  SearchEnabled.MaterialIsSerialManaged AS MaterialIsSerialManaged,
  FldLogsIsSupplierItem,
  concat(concat( FldLogsSuplrItmMatlDoc, '/'), SearchEnabled.GoodsMovementItem) AS FldLogsMatlDocItem,
  SearchEnabled.InventoryStockType AS InventoryStockType,
  SearchEnabled.InventoryStockTypeName AS InventoryStockTypeName,
  SearchEnabled.MaterialDocumentHeaderText AS MaterialDocumentHeaderText,
  cast( $session.system_date as budat preserving type ) AS FldLogsRvslPostingDate,
  SearchEnabled.FldLogsIsValnType AS FldLogsIsValnType,
  SearchEnabled.FldLogsManufactureDate AS FldLogsManufactureDate,
  SearchEnabled.FldLogsShelfLifeExpiryDate AS FldLogsShelfLifeExpiryDate,
  SearchEnabled.FldLogsItmIsAtRemote AS FldLogsItmIsAtRemote,
  SearchEnabled.FldLogsIsContainerHidden AS FldLogsIsContainerHidden,
  SearchEnabled.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  PackagingMaterial,
  SearchEnabled.FldLogsStatus AS FldLogsStatus,
  SearchEnabled.FldLogsStatusFrmEWMInbDeliv AS FldLogsStatusFrmEWMInbDeliv,
  _FldLogsStatusTxt.FldLogsStatusTxt AS FldLogsStatusTxt,
  _FldLogsStatusEWMTxt.FldLogsStatusTxt AS FldLogsStatusFrmEWMInbDelivTxt,
  SearchEnabled.MaterialGroup AS MaterialGroup,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  cast('' as boolean) AS FldLogsCtnInfoSecIsHidden,
  SearchEnabled.HandlingUnitExternalID AS HandlingUnitExternalID,
  SearchEnabled.HandlingUnitId AS HandlingUnitId,
  _PackagingMaterialTxt.MaterialName AS PackagingMaterialName,
  SearchEnabled.PickingStatus AS PickingStatus,
  SearchEnabled.IsToBeAcceptedAtOrigin AS IsToBeAcceptedAtOrigin,
  cast('' as boolean preserving type ) AS FldLogsGdsMvtTypeIsEditable,
  SearchEnabled.FldLogsPutawayQty AS FldLogsPutawayQty,
  SearchEnabled.FldLogsEWMStockType AS FldLogsEWMStockType,
  SearchEnabled.FldLogsOpenDelivQty AS FldLogsOpenDelivQty,
  _EWMStockTypeTxt.StockTypeName AS FldLogsEWMStockTypeText,
  SearchEnabled.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  SearchEnabled.SuplrCoIsBusPrpsCmpltd AS SuplrCoIsBusPrpsCmpltd,
  SearchEnabled.IsBusPrpsCmpltdCustomer AS IsBusPrpsCmpltdCustomer,
  SearchEnabled.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _PoDocCatTxt.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  _PoDocCatTxt.PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  SearchEnabled.FldLogsProcRcptExtUnionID AS FldLogsProcRcptExtUnionID,
  SearchEnabled.OrderCategory AS OrderCategory,
  _OrderCatTxt.OrderCategoryName AS OrderCategoryName,
  SearchEnabled.MaintenanceOrder AS MaintenanceOrder,
  SearchEnabled.PurchaseRequisition AS PurchaseRequisition,
  SearchEnabled.RequisitionerName AS RequisitionerName,
  SearchEnabled.UnloadingPointName AS UnloadingPointName,
  SearchEnabled.GoodsRecipientName AS GoodsRecipientName,
  SearchEnabled.OutboundDelivery AS OutboundDelivery,
  SearchEnabled.OutboundDeliveryItem AS OutboundDeliveryItem,
  coalesce(_RstrcdItmIntegration.FldLogsItemIsRestricted, '') AS FldLogsItemIsRestricted
FROM I_FldLogsProcRcptSrchEnbld AS SearchEnabled
INNER JOIN I_PurchasingDocumentItem AS _PO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _PoDocCatTxt ON _PoDocCatTxt.PurchasingDocumentItemCategory = SearchEnabled.PurchasingDocumentItemCategory AND _PoDocCatTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _PlantName ON SearchEnabled.Plant = _PlantName.Plant AND _PlantName.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_FldLogsSupplierItem AS _SupplierItem ON _SupplierItem.FldLogsSuplrItemUUID = FldLogsSuplrItemUUID  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSuplrItmVislInspVH AS _FldLogsSuplrItmVislInspText ON _FldLogsSuplrItmVislInspText.FldLogsSuplrItemVislInspCode = FldLogsSuplrItemVislInspCode AND _FldLogsSuplrItmVislInspText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_GenericPriorityText AS _GenericPriorityText ON _GenericPriorityText.PriorityCode = MaintPriority AND _GenericPriorityText.Language = $session.system_language AND _GenericPriorityText.GenericPriorityType = 'PM'  -- association [0..1]
LEFT OUTER JOIN I_FldLogsItemTypeVH AS _ItemType ON _ItemType.FldLogsItemType = FldLogsItemType AND _ItemType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementTypeT AS _GoodsMovementTypeT ON GoodsMovementType = _GoodsMovementTypeT.GoodsMovementType AND _GoodsMovementTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_FldLogsStatusVH AS _FldLogsStatusTxt ON FldLogsStatus = _FldLogsStatusTxt.FldLogsStatus AND _FldLogsStatusTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_StockTypeText_2 AS _StockTypeText ON _StockTypeText.StockType = InventoryUsabilityCode AND _StockTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_FldLogsMaterialDetails AS _PackagingMaterialTxt ON PackagingMaterial = _PackagingMaterialTxt.MaterialName  -- association [0..1]
LEFT OUTER JOIN I_FldLogsRblShipmentItem AS _OBDContainerItem ON (DeliveryDocument is not initial AND DeliveryDocument = _OBDContainerItem.DeliveryDocument AND DeliveryDocumentItem = _OBDContainerItem.DeliveryDocumentItem ) OR (OutboundDelivery is not initial AND OutboundDelivery = _OBDContainerItem.DeliveryDocument AND OutboundDeliveryItem = _OBDContainerItem.DeliveryDocumentItem )  -- association [0..1]
LEFT OUTER JOIN I_FldLogsEWMStockTypeVH AS _EWMStockTypeTxt ON FldLogsEWMStockType = _EWMStockTypeTxt.FldLogsEWMStockType AND EWMWarehouse = _EWMStockTypeTxt.EWMWarehouse AND _EWMStockTypeTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FldLogsProcRcptRcvgStatus AS _FldLogsProcRcptRcvgStatus ON _FldLogsProcRcptRcvgStatus.FldLogsProcRecRcvgStatus = FldLogsProcRecRcvgStatus AND _FldLogsProcRcptRcvgStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FldLogsStatusVH AS _FldLogsStatusEWMTxt ON FldLogsStatusFrmEWMInbDeliv = _FldLogsStatusEWMTxt.FldLogsStatus AND _FldLogsStatusEWMTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BatchCrossPlant AS _Batch ON Batch = _Batch.Batch AND Material = _Batch.Material  -- association [0..1]
LEFT OUTER JOIN I_OrderCategoryText AS _OrderCatTxt ON OrderCategory = _OrderCatTxt.OrderCategory AND _OrderCatTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FldLogsRstrcdItmIntegration AS _RstrcdItmIntegration ON FldLogsPurOrdItem = _RstrcdItmIntegration.FldLogsRstrcdItmRefDocNmbr AND _RstrcdItmIntegration.FldLogsRstrcdItmRefDocType = 'PO'  -- association [0..1]
;