C_FldLogsProcessShipmentItemTP

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_FldLogsProcessShipmentItemTP.
-- 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_FldLogsProcessShipmentItemTP AS
SELECT
  FldLogsReferenceDocumentNumber,
  FldLogsDispatchPlant,
  DispatchedStartDate,
  FldLogsReferenceDocCategory,
  Material,
  _MaterialText.MaterialName : localized AS MaterialNamelocalized,
  FldLogsSrceStorLocID,
  _SourceStorageLocationText.StorageLocationName AS StorageLocationName,
  FldLogsDestStorLocID,
  _DestinationStorageLocationTxt.StorageLocationName AS SupplyingStorageLocationName,
  FldLogsSupplyProcess,
  OutboundDelivery,
  OutboundDeliveryItem,
  MaterialDocument,
  PurchasingDocument,
  StockTransportOrder,
  FldLogsRetServicePurOrd,
  Batch,
  ValuationType,
  SerialNumber,
  FieldLogisticsProcessType,
  FieldLogisticsReceivingPlant,
  _ReceivingPlantText.PlantName AS PlantName,
  FldLogsCtnItmChangeDateTime,
  FldLogsStorageType,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsSubcontractingPO,
  FldLogsSubcontrgPOIsCreated,
  FldLogsRcvdItmStsCriticality,
  SystemMessageTypeCriticality,
  ReferencePurchasingDocument,
  InboundDelivery,
  FldLogsReturnComment,
  FldLogsReturnLongComment,
  FldLogsCtnItmLastProcessingMsg,
  FldLogsPostProcessingMessage,
  FldLogsCtnItmProcessDateTime,
  FldLogsReturnProcgComment,
  ReferenceOrder,
  EWMWarehouse,
  WarehouseTask,
  ReferenceSDDocument,
  PackagingMaterial,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  FldLogsSuplrItemVislInspCode,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  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,
  FldLogsContainerID,
  FldLogsShptItmHndlgUnitID,
  HandlingUnitExternalID,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  RecipientLocationCode,
  FieldLogisticsKitIdentifier,
  FldLogsKitItmRefDocument1,
  FldLogsItemType,
  _ItemTypeText.FldLogsSuplrItemTypeText : localized AS FldLogsSuplrItemTypeTextlocalized,
  FldLogsRefurbishmentOrder,
  FldLogsRefrbmtOrderReservation,
  FldLogsRefrbmtOrderResvnItem,
  WBSElementExternalID,
  InventorySpecialStockType,
  _InventorySpecialStockTypeText.InventorySpecialStockTypeName : localized AS InventorySpecialStockTypeNamelocalized,
  _DispatchPlantText.PlantName AS PlantName2,
  IsInternalBatchManaged,
  WarehouseStorageBin,
  IsMarkedForDeletion,
  FldLogsItemActualDispatchPlant,
  FldLogsItmActualReceivingPlant,
  MaterialDocumentYear,
  MaterialDocumentItem,
  InspectionLot,
  GoodsReceivingPoint,
  ShippingPoint,
  FldLogsContainerID AS FldLogsContainerIDForFilter,
  OrderCategory,
  _OrderCategoryText.OrderCategoryName : localized AS OrderCategoryNamelocalized,
  SemanticObject,
  FldLogsRcvdItmIsAcctAssgd,
  PurchasingDocumentItem,
  FldLogsGdsIssMatlDocument,
  virtual IsDynamic : boolean AS virtualIsDynamicboolean,
  _FldLogsHandlingDecisionsBsc.FldLogsItmIsPostProcessAllowed AS FldLogsItmIsPostProcessAllowed,
  FldLogsReferenceObjectType,
  _RefObjTypeDesc.FldLogsReferenceObjectTypeText AS FldLogsReferenceObjectTypeText,
  FldLogsReferenceObjectNumber,
  FldLogsItemIsRestricted
FROM R_FldLogsProcessShipmentItemTP
LEFT OUTER JOIN C_FldLogsDeliverySerialItmDets AS _SerialItems ON OutboundDelivery = _SerialItems.DeliveryDocument AND OutboundDeliveryItem = _SerialItems.DeliveryDocumentItem  -- association [0..*]
;