R_FldLogsRcvdPackggInCtnTP

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 R_FldLogsRcvdPackggInCtnTP.
-- 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 R_FldLogsRcvdPackggInCtnTP 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,
  FldLogsParentContainerID,
  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
FROM I_FldLogsRcvdPackaging AS _RcvdPackgg
LEFT OUTER JOIN I_FldLogsContainerStatusTxt AS _CtnStatText ON _RcvdPackgg.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]
;