I_FldLogsContainerListTP

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_FldLogsContainerListTP.
-- 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_FldLogsContainerListTP AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsCtnProcessingStartDate,
  FldLogsCtnProcessingEndDate,
  FldLogsShipmentID,
  FldLogsContainerUUID,
  FieldLogisticsProcessType,
  FldLogsContainerUnitUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  FldLogsCtnChangeDateTime,
  FieldLogisticsReceivingPlant,
  FldLogsSealNumber1,
  FldLogsSealNumber2,
  FldLogsSealNumber3,
  FldLogsSealNumber4,
  FldLogsSealNumber5,
  FldLogsContainerStatus,
  FldLogsContainerOwner,
  FldLogsRcvdContainerIsReleased,
  cast('' as charg_d ) AS Batch,
  cast('' as gernr ) AS SerialNumber,
  cast('' as vbeln_vl ) AS InboundDelivery,
  cast('' as flog_item_status ) AS FldLogsContainerItemStatus,
  cast('' as flog_doc) AS FldLogsReferenceDocumentNumber,
  cast('' as matnr ) AS Material,
  cast(''as abap.char(20)) AS FldLogsShptItmHndlgUnitID,
  cast(''as exidv) AS HandlingUnitExternalID,
  cast('' as flog_kit_id ) AS FieldLogisticsKitIdentifier,
  cast('' as flog_item_type) AS FldLogsItemType,
  cast('' as ps_s4_posid ) AS WBSElementExternalID,
  IsMarkedForDeletion,
  FldLogsCtnActualDispatchPlant,
  FldLogsCtnActualReceivingPlant,
  cast(''as vstel) AS GoodsReceivingPoint,
  cast(''as vstel) AS ShippingPoint
FROM I_FldLogsContainerList AS _CtnList
LEFT OUTER JOIN I_FldLogsContainerStatusTxt AS _CtnStatText ON _CtnList.FldLogsContainerStatus = _CtnStatText.FldLogsContainerStatus  -- association [0..*]
LEFT OUTER JOIN I_FldLogsCtnItmStatusTxt AS _ItemStatText ON FldLogsContainerItemStatus = _ItemStatText.DomainValueLow  -- association [0..*]
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 E_FldLogsRcvdShipmentContainer AS _ReceivedShptCtnExtension ON FldLogsContainerID = _ReceivedShptCtnExtension.FldLogsContainerID AND DispatchedStartDate = _ReceivedShptCtnExtension.DispatchedStartDate AND FldLogsDispatchPlant = _ReceivedShptCtnExtension.FldLogsDispatchPlant AND NumberOfCtnTripsPerDay = _ReceivedShptCtnExtension.NumberOfCtnTripsPerDay  -- association [1..1]
LEFT OUTER JOIN I_FldLogsContainerItemsTP AS _CtnItemTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_FldLogsRcvdPackggInCtnTP AS _RcvdPackggInCtn ON /* condition not available in parsed metadata */  -- association [1..*]
;