I_FldLogsContainerItemsTP

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_FldLogsContainerItemsTP.
-- 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_FldLogsContainerItemsTP AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  FldLogsShptItmHndlgUnitID,
  Material,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  FldLogsSrceStorLocID AS RemoteStorageLocation,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  FldLogsReturnStatus,
  FldLogsContainerItemStatus,
  FldLogsCtnQuickAction,
  FldLogsReferenceDocCategory,
  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,
  FldLogsRecommendedAction,
  FldLogsKitItmRefDocument2,
  ReferenceDocumentItem,
  _ReturnComment.FldLogsReturnComment AS FldLogsReturnComment,
  _ReturnComment.FldLogsReturnLongComment AS FldLogsReturnLongComment,
  FldLogsCtnItmChangeDateTime,
  ReferenceOrder,
  EWMWarehouse,
  ValuationType,
  SerialNumber,
  FieldLogisticsProcessType,
  FieldLogisticsReceivingPlant,
  FldLogsContainerUnitUUID,
  FldLogsShptItemUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  MaterialDocument,
  FldLogsStorageType,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsSubcontrgPOIsCreated,
  FldLogsSubcontractingPO,
  _SupplierItem.FldLogsSuplrItmPackggTypeCode AS FldLogsSuplrItmPackggTypeCode,
  PackagingMaterial,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  Batch,
  _MatBatch.IsInternalBatchManaged AS IsInternalBatchManaged,
  FldLogsSupplyProcess,
  _ProcessingLog.FldLogsCtnItmLastProcessingMsg AS FldLogsCtnItmLastProcessingMsg,
  _ProcessingLog.FldLogsPostProcessingMessage AS FldLogsPostProcessingMessage,
  _ProcessingLog.FldLogsCtnItmProcessDateTime AS FldLogsCtnItmProcessDateTime,
  WarehouseTask,
  FldLogsReturnProcgComment,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  _ReservationItem.RecipientLocationCode AS RecipientLocationCode,
  FldLogsRefurbishmentOrder,
  FldLogsRefrbmtOrderReservation,
  FldLogsRefrbmtOrderResvnItem,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsSuplrItemUUID,
  FldLogsSuplrItemVislInspCode,
  cast(concat(FldLogsReferenceDocumentNumber,FldLogsShptItmHndlgUnitID) as char40 ) AS FldLogsRcvdHndlgUnitCnctntdID,
  cast(lpad(FldLogsReferenceDocumentNumber,20,'0') as char20) AS ReferenceDocumentLongNumber,
  HandlingUnitQuantity,
  HandlingUnitQuantityUnit,
  OutboundDelivery,
  OutboundDeliveryItem,
  _ShipmentItem._KitHeader.FieldLogisticsKitIdentifier AS FieldLogisticsKitIdentifier,
  _ShipmentItem._KitHeader.FldLogsReferenceDocumentNumber AS FldLogsKitItmRefDocument1,
  FldLogsItemType,
  cast(FldLogsShptItmHndlgUnitID as exidv) AS HandlingUnitExternalID,
  WBSElementExternalID,
  InventorySpecialStockType,
  DeliveryDocument,
  DeliveryDocumentItem,
  WarehouseStorageBin,
  PurchasingDocumentItem,
  IsMarkedForDeletion,
  FldLogsItemActualDispatchPlant,
  FldLogsItmActualReceivingPlant,
  MaterialDocumentYear,
  MaterialDocumentItem,
  InspectionLot,
  _CtnClssfn.FieldLogisticsCtnIsOwned AS FieldLogisticsCtnIsOwned,
  _DeliverySTO._DeliveryDocument.ShippingPoint AS ShippingPoint,
  OrderCategory,
  FldLogsRcvdItmIsAcctAssgd,
  FldLogsGdsIssMatlDocument,
  _SupplierItem.FldLogsReferenceObjectType AS FldLogsReferenceObjectType,
  _SupplierItem.FldLogsReferenceObjectNumber AS FldLogsReferenceObjectNumber,
  FldLogsItemIsRestricted,
  _ReservationItem._RecipientLocationCode AS _RecipientLocationCode
FROM I_FldLogsContainerItemRecord AS _items
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_FldLogsCtnItmProcessingInfo AS _ProcessingLog ON FldLogsContainerID = _ProcessingLog.FldLogsContainerID AND FldLogsDispatchPlant = _ProcessingLog.FldLogsDispatchPlant AND DispatchedStartDate = _ProcessingLog.DispatchedStartDate AND NumberOfCtnTripsPerDay = _ProcessingLog.NumberOfCtnTripsPerDay 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 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 E_FldLogsReceivedShipmentItem AS _ReceivedCtnItemExtension ON FldLogsContainerID = _ReceivedCtnItemExtension.FldLogsContainerID AND DispatchedStartDate = _ReceivedCtnItemExtension.DispatchedStartDate AND FldLogsDispatchPlant = _ReceivedCtnItemExtension.FldLogsDispatchPlant AND NumberOfCtnTripsPerDay = _ReceivedCtnItemExtension.NumberOfCtnTripsPerDay AND FldLogsReferenceDocumentNumber = _ReceivedCtnItemExtension.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_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_RecommendedActionText AS _ActionText ON FldLogsRecommendedAction = _ActionText.FldLogsRecommendedAction  -- association [0..*]
LEFT OUTER JOIN I_FldLogsReturnStatusT AS _RetStatText ON FldLogsReturnStatus = _RetStatText.FldLogsReturnStatus  -- association [0..*]
LEFT OUTER JOIN I_FldLogsSupplierItem AS _SupplierItem ON FldLogsSuplrItemUUID = _SupplierItem.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_FldLogsShptCtnUnit AS _CtnClssfn ON FldLogsContainerUnitUUID = _CtnClssfn.FldLogsContainerUnitUUID  -- association [0..1]
LEFT OUTER JOIN I_FldLogsRefObjTypeBasic AS _RefObjTypeDesc ON FldLogsReferenceObjectType = _RefObjTypeDesc.FldLogsReferenceObjectType AND _RefObjTypeDesc.Language = $session.system_language  -- association [0..1]
;