R_FldLogsRcvdHndlgUnitItemTP

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 R_FldLogsRcvdHndlgUnitItemTP.
-- 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 R_FldLogsRcvdHndlgUnitItemTP AS
SELECT
  FldLogsShptItemUUID,
  FldLogsShptItmHndlgUnitID,
  FldLogsReferenceDocumentNumber,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  FldLogsReferenceDocCategory,
  Material,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  FldLogsSrceStorLocID AS RemoteStorageLocation,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  FldLogsSupplyProcess,
  FldLogsItemType,
  FldLogsReturnStatus,
  FldLogsContainerItemStatus,
  FldLogsCtnQuickAction,
  MaterialDocument,
  case when FldLogsCtnQuickAction = '30' then PurchasingDocument end AS PurchasingDocument,
  case when FldLogsCtnQuickAction = '40' then StockTransportOrder end AS StockTransportOrder,
  case when FldLogsCtnQuickAction = '20' then FldLogsRetServicePurOrd end AS FldLogsRetServicePurOrd,
  FldLogsStorageType,
  Batch,
  ValuationType,
  FieldLogisticsReceivingPlant,
  FieldLogisticsProcessType,
  FldLogsSubcontractingPO,
  FldLogsSubcontrgPOIsCreated,
  FldLogsCtnItmChangeDateTime,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsContainerUnitUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  PackagingMaterial,
  HandlingUnitQuantity,
  HandlingUnitQuantityUnit,
  ReferenceOrder,
  FldLogsRecommendedAction,
  FldLogsKitItmRefDocument2,
  ReferenceDocumentItem,
  _ReturnComment.FldLogsReturnComment AS FldLogsReturnComment,
  _ReturnComment.FldLogsReturnLongComment AS FldLogsReturnLongComment,
  _SupplierItem.FldLogsSuplrItmPackggTypeCode AS FldLogsSuplrItmPackggTypeCode,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  EWMWarehouse,
  _MatBatch.IsInternalBatchManaged AS IsInternalBatchManaged,
  _ProcessingLog.FldLogsCtnItmLastProcessingMsg AS FldLogsCtnItmLastProcessingMsg,
  _ProcessingLog.FldLogsCtnItmProcessDateTime AS FldLogsCtnItmProcessDateTime,
  _ProcessingLog.FldLogsPostProcessingMessage AS FldLogsPostProcessingMessage,
  WarehouseTask,
  _Comment.FldLogsRcvdItmProcgComment AS FldLogsRcvdItmProcgComment,
  FldLogsContainerID,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  FldLogsRefurbishmentOrder,
  FldLogsRefrbmtOrderReservation,
  FldLogsRefrbmtOrderResvnItem,
  _ReservationItem.RecipientLocationCode AS RecipientLocationCode,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsSuplrItemUUID,
  FldLogsSuplrItemVislInspCode,
  OutboundDelivery,
  OutboundDeliveryItem,
  FldLogsRcvdHndlgUnitCnctntdID,
  _ShipmentItem._KitHeader.FieldLogisticsKitIdentifier AS FieldLogisticsKitIdentifier,
  _ShipmentItem._KitHeader.FldLogsReferenceDocumentNumber AS FldLogsKitItmRefDocument1,
  cast(FldLogsShptItmHndlgUnitID as exidv) AS HandlingUnitExternalID,
  SerialNumber,
  WBSElementExternalID,
  InventorySpecialStockType,
  DeliveryDocument,
  DeliveryDocumentItem,
  WarehouseStorageBin,
  PurchasingDocumentItem,
  IsMarkedForDeletion,
  FldLogsItmActualReceivingPlant,
  FldLogsItemActualDispatchPlant,
  MaterialDocumentYear,
  MaterialDocumentItem,
  InspectionLot,
  _DeliverySTO._DeliveryDocument.ShippingPoint AS ShippingPoint,
  OrderCategory,
  FldLogsRcvdItmIsAcctAssgd,
  FldLogsGdsIssMatlDocument,
  _SupplierItem.FldLogsReferenceObjectType AS FldLogsReferenceObjectType,
  _SupplierItem.FldLogsReferenceObjectNumber AS FldLogsReferenceObjectNumber,
  coalesce(_RstrcdItmIntegration.FldLogsItemIsRestricted, '') AS FldLogsItemIsRestricted
FROM I_FldLogsRcvdHndlgUnitItmRecd AS _ReceivedAllHUItems
LEFT OUTER JOIN I_RecommendedActionText AS _ActionText ON FldLogsRecommendedAction = _ActionText.FldLogsRecommendedAction  -- association [0..*]
LEFT OUTER JOIN I_FldLogsCtnItmStatusTxt AS _ItemStatText ON FldLogsContainerItemStatus = _ItemStatText.DomainValueLow  -- association [0..*]
LEFT OUTER JOIN I_FldLogsCtnItmQuickActionTxt AS _QuickActionText ON FldLogsCtnQuickAction = _QuickActionText.FldLogsCtnQuickAction AND FieldLogisticsProcessType = _QuickActionText.FieldLogisticsProcessType  -- association [0..*]
LEFT OUTER JOIN I_FldLogsReturnStatusT AS _RetStatText ON FldLogsReturnStatus = _RetStatText.FldLogsReturnStatus  -- association [0..*]
LEFT OUTER JOIN I_FldLogsCtnItmProcessingInfo AS _ProcessingLog ON FldLogsDispatchPlant = _ProcessingLog.FldLogsDispatchPlant AND DispatchedStartDate = _ProcessingLog.DispatchedStartDate AND FldLogsReferenceDocumentNumber = _ProcessingLog.FldLogsReferenceDocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_FldLogsMaterialBatch AS _MatBatch ON Material = _MatBatch.Material AND FldLogsItemActualDispatchPlant = _MatBatch.Plant  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSuplrItmPackggTypeT AS _SuplrItmPackggTypeT ON fldlogssuplritmpackggtypecode = _SuplrItmPackggTypeT.FldLogsSuplrItmPackggTypeCode  -- association [0..*]
LEFT OUTER JOIN E_FldLogsReceivedHandlingUnit AS _HandlingUnitExtension ON FldLogsShptItemUUID = _HandlingUnitExtension.FldLogsShptItemUUID AND FldLogsShptItmHndlgUnitID = _HandlingUnitExtension.FldLogsShptItmHndlgUnitID AND FldLogsReferenceDocumentNumber = _HandlingUnitExtension.FldLogsReferenceDocumentNumber  -- association [1..1]
LEFT OUTER JOIN E_FieldLogisticsReturns AS _ReturnsExtension ON Material = _ReturnsExtension.Material AND FldLogsDispatchPlant = _ReturnsExtension.FldLogsRemotePlant AND ReferenceSDDocument = _ReturnsExtension.FldLogsReferenceDocumentNumber AND ReferenceSDDocumentItem = _ReturnsExtension.ReferenceDocumentItem AND ReferenceOrder = _ReturnsExtension.FldLogsMaintenanceOrder AND RemoteStorageLocation = _ReturnsExtension.RemoteStorageLocation  -- association [1..1]
LEFT OUTER JOIN I_ReservationItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation AND ReservationItem = _ReservationItem.ReservationItem  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ReceivingPlantText ON FieldLogisticsReceivingPlant = _ReceivingPlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _DispatchPlantText ON FldLogsDispatchPlant = _DispatchPlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _SourceStorageLocationText ON FldLogsSrceStorLocID = _SourceStorageLocationText.StorageLocation AND FldLogsItemActualDispatchPlant = _SourceStorageLocationText.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _DestinationStorageLocationTxt ON FldLogsDestStorLocID = _DestinationStorageLocationTxt.StorageLocation AND FldLogsItmActualReceivingPlant = _DestinationStorageLocationTxt.Plant  -- association [0..1]
LEFT OUTER JOIN I_FldLogsShipmentItem AS _ShipmentItem ON FldLogsShptItemUUID = _ShipmentItem.FldLogsShptItemUUID  -- association [1]
LEFT OUTER JOIN I_FldLogsItemTypeVH AS _ItemTypeText ON FldLogsItemType = _ItemTypeText.FldLogsItemType  -- association [0..*]
LEFT OUTER JOIN I_FldLogsReturnComment AS _ReturnComment ON FldLogsKitItmRefDocument2 = _ReturnComment.FldLogsReferenceDocumentNumber AND ReferenceDocumentItem = _ReturnComment.ReferenceDocumentItem AND _ReturnComment.FldLogsReferenceDocumentNumber is not initial  -- association [0..1]
LEFT OUTER JOIN I_FldLogsMaterialText AS _MaterialText ON Material = _MaterialText.Material AND FldLogsSuplrItemUUID = _MaterialText.FldLogsSuplrItemUUID  -- association [0..*]
LEFT OUTER JOIN I_FldLogsSupplierItem AS _SupplierItem ON _SupplierItem.FldLogsSuplrItemUUID = FldLogsSuplrItemUUID  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockTypeT AS _InventorySpecialStockTypeText ON InventorySpecialStockType = _InventorySpecialStockTypeText.InventorySpecialStockType  -- association [0..*]
LEFT OUTER JOIN I_OrderCategoryText AS _OrderCategoryText ON OrderCategory = _OrderCategoryText.OrderCategory  -- association [0..*]
LEFT OUTER JOIN I_FldLogsHandlingDecisionsBsc AS _FldLogsHandlingDecisionsBsc ON FldLogsCtnQuickAction = _FldLogsHandlingDecisionsBsc.FldLogsCtnQuickAction AND FieldLogisticsProcessType = _FldLogsHandlingDecisionsBsc.FieldLogisticsProcessType  -- association [0..1]
LEFT OUTER JOIN I_FldLogsRefObjTypeBasic AS _RefObjTypeDesc ON FldLogsReferenceObjectType = _RefObjTypeDesc.FldLogsReferenceObjectType AND _RefObjTypeDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FldLogsRstrcdItmIntegration AS _RstrcdItmIntegration ON FldLogsReferenceDocumentNumber = _RstrcdItmIntegration.FldLogsRstrcdItmRefDocNmbr AND _RstrcdItmIntegration.FldLogsRstrcdItmRefDocType = 'FOBD'  -- association [0..1]
;