C_FldLogsContainerItems

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 C_FldLogsContainerItems.
-- 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 C_FldLogsContainerItems AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  FldLogsShptItmHndlgUnitID,
  Material,
  _MaterialText.MaterialName : localized AS MaterialNamelocalized,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  FldLogsSrceStorLocID,
  _SourceStorageLocationText.StorageLocationName AS StorageLocationName,
  FldLogsDestStorLocID,
  _DestinationStorageLocationTxt.StorageLocationName AS SupplyingStorageLocationName,
  FldLogsRcvdItmStsCriticality,
  ReferencePurchasingDocument,
  OutboundDelivery,
  OutboundDeliveryItem,
  InboundDelivery,
  MaterialDocument,
  PurchasingDocument,
  FldLogsReturnComment,
  FldLogsReturnLongComment,
  FldLogsSupplyProcess,
  FldLogsReferenceDocCategory,
  FldLogsCtnItmLastProcessingMsg,
  FldLogsPostProcessingMessage,
  FldLogsCtnItmProcessDateTime,
  FldLogsCtnItmChangeDateTime,
  FldLogsReturnProcgComment,
  FldLogsStorageType,
  ReferenceOrder,
  EWMWarehouse,
  WarehouseTask,
  StockTransportOrder,
  Batch,
  ValuationType,
  SerialNumber,
  FldLogsRetServicePurOrd,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsSubcontractingPO,
  FldLogsSubcontrgPOIsCreated,
  ReferenceSDDocument,
  IsInternalBatchManaged,
  FieldLogisticsProcessType,
  FieldLogisticsReceivingPlant,
  SystemMessageTypeCriticality,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  RecipientLocationCode,
  HandlingUnitQuantity,
  HandlingUnitQuantityUnit,
  PackagingMaterial,
  FldLogsRcvdHndlgUnitCnctntdID,
  ReferenceDocumentLongNumber,
  FldLogsSuplrItemVislInspCode,
  FieldLogisticsKitIdentifier,
  FldLogsKitItmRefDocument1,
  _CtnClssfn.FieldLogisticsCtnIsOwned AS FieldLogisticsCtnIsOwned,
  FldLogsRefurbishmentOrder,
  FldLogsRefrbmtOrderReservation,
  FldLogsRefrbmtOrderResvnItem,
  FldLogsReturnStatus,
  _RetStatText.FldLogsReturnStatusText : localized AS FldLogsReturnStatusTextlocalized,
  FldLogsContainerItemStatus,
  _ItemStatText.FldLogsContainerItemStatusText : localized AS FldLogsContainerItemStatusTextlocalized,
  FldLogsCtnQuickAction,
  _QuickActionText.FldLogsCtnQuickActionText : localized AS FldLogsCtnQuickActionTextlocalized,
  FldLogsRecommendedAction,
  _ActionText.FldLogsRecommendedActionText : localized AS FldLogsRecommendedActionTextlocalized,
  FldLogsSuplrItmPackggTypeCode,
  _SuplrItmPackggTypeT.FldLogsSuplrItmPackggTypeTxt : localized AS FldLogsSuplrItmPackggTypeTxtlocalized,
  FldLogsItemType,
  _ItemTypeText.FldLogsSuplrItemTypeText : localized AS FldLogsSuplrItemTypeTextlocalized,
  HandlingUnitExternalID,
  WBSElementExternalID,
  InventorySpecialStockType,
  _InventorySpecialStockTypeText.InventorySpecialStockTypeName : localized AS InventorySpecialStockTypeNamelocalized,
  WarehouseStorageBin,
  IsMarkedForDeletion,
  FldLogsItemActualDispatchPlant,
  FldLogsItmActualReceivingPlant,
  MaterialDocumentYear,
  MaterialDocumentItem,
  InspectionLot,
  GoodsReceivingPoint,
  ShippingPoint,
  OrderCategory,
  _OrderCategoryText.OrderCategoryName : localized AS OrderCategoryNamelocalized,
  SemanticObject,
  FldLogsRcvdItmIsAcctAssgd,
  PurchasingDocumentItem,
  FldLogsGdsIssMatlDocument,
  virtual IsDynamic : abap_boolean AS virtualIsDynamicabap_boolean,
  _FldLogsHandlingDecisionsBsc.FldLogsItmIsPostProcessAllowed AS FldLogsItmIsPostProcessAllowed,
  FldLogsReferenceObjectType,
  _RefObjTypeDesc.FldLogsReferenceObjectTypeText AS FldLogsReferenceObjectTypeText,
  FldLogsReferenceObjectNumber,
  FldLogsItemIsRestricted
FROM I_FldLogsContainerItemsTP
LEFT OUTER JOIN C_FldLogsDeliverySerialItmDets AS _SerialItems ON OutboundDelivery = _SerialItems.DeliveryDocument AND OutboundDeliveryItem = _SerialItems.DeliveryDocumentItem  -- association [0..*]
;