I_FldLogsContainerItemRecord

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_FldLogsContainerItemRecord.
-- 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_FldLogsContainerItemRecord AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  Material,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  FldLogsReturnStatus,
  FldLogsContainerItemStatus,
  FldLogsCtnQuickAction,
  FldLogsReferenceDocCategory,
  _ReturnItms.FldLogsRecommendedAction AS FldLogsRecommendedAction,
  MaterialDocument,
  PurchasingDocument,
  StockTransportOrder,
  FldLogsRetServicePurOrd,
  _ReturnItms.ReferencePurchasingDocument AS ReferencePurchasingDocument,
  FldLogsCtnItmChangeDateTime,
  FldLogsSupplyProcess,
  FldLogsStorageType,
  MaintenanceOrder AS ReferenceOrder,
  Batch,
  ValuationType,
  SerialNumber,
  FieldLogisticsProcessType,
  FieldLogisticsReceivingPlant,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsSubcontrgPOIsCreated,
  FldLogsSubcontractingPO,
  FldLogsContainerUnitUUID,
  FldLogsShptItemUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  FldLogsItemType,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  _WarehouseNumber.EWMWarehouse AS EWMWarehouse,
  PackagingMaterial,
  FldLogsShptItmHndlgUnitID,
  HandlingUnitQuantity,
  HandlingUnitQuantityUnit,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  FldLogsRefurbishmentOrder,
  FldLogsRefrbmtOrderReservation,
  FldLogsRefrbmtOrderResvnItem,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsSuplrItemUUID,
  FldLogsSuplrItemVislInspCode,
  OutboundDelivery,
  OutboundDeliveryItem,
  FldLogsReturnProcgComment,
  WarehouseTask,
  DeliveryDocument,
  DeliveryDocumentItem,
  _PurOrdSpclStkDet.WBSElementExternalID AS WBSElementExternalID,
  _PurOrdSpclStkDet.InventorySpecialStockType AS InventorySpecialStockType,
  WarehouseStorageBin,
  PurchasingDocumentItem,
  IsMarkedForDeletion,
  FldLogsItemActualDispatchPlant,
  FldLogsItmActualReceivingPlant,
  MaterialDocumentYear,
  MaterialDocumentItem,
  InspectionLot,
  OrderCategory,
  FldLogsRcvdItmIsAcctAssgd,
  FldLogsGdsIssMatlDocument,
  coalesce(_RstrcdItmIntegration.FldLogsItemIsRestricted, '') AS FldLogsItemIsRestricted
FROM I_FldLogsContainerItems
LEFT OUTER JOIN I_FldLogsPlntStorLocWrhsNmbr AS _WarehouseNumber ON FldLogsItmActualReceivingPlant = _WarehouseNumber.Plant AND FldLogsDestStorLocID = _WarehouseNumber.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_FldLogsReturnItem AS _ReturnItms ON OutboundDelivery = _ReturnItms.OutboundDelivery AND OutboundDeliveryItem = _ReturnItms.OutboundDeliveryItem AND _ReturnItms.OutboundDelivery is not initial  -- association [0..1]
LEFT OUTER JOIN I_FldLogsPurOrdSpclStockDetail AS _PurOrdSpclStkDet ON ReferenceSDDocument = _PurOrdSpclStkDet.ReferenceSDDocument AND PurchasingDocumentItem = _PurOrdSpclStkDet.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsRstrcdItmIntegration AS _RstrcdItmIntegration ON FldLogsReferenceDocumentNumber = _RstrcdItmIntegration.FldLogsRstrcdItmRefDocNmbr AND _RstrcdItmIntegration.FldLogsRstrcdItmRefDocType = 'FOBD'  -- association [0..1]
;