I_MKT_WebTrckgMappingLogTP

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_MKT_WebTrckgMappingLogTP.
-- 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.
-- SQL view name: IMKTWTMLTP

CREATE VIEW I_MKT_WebTrckgMappingLogTP AS
SELECT
  wtm.WebTrckgMappingLogUUID AS WebTrckgMappingLogUUID,
  wtm.WebTrackingMappingUUID AS WebTrackingMappingUUID,
  wtm.WebTrckgRtrvlHeaderName AS WebTrckgRtrvlHeaderName,
  wtm.ValidityStartDate AS ValidityStartDate,
  wtm.ValidityEndDate AS ValidityEndDate,
  DATS_DAYS_BETWEEN(ValidityStartDate, ValidityEndDate)+ 1 AS ValidityDate,
  cast( cast('10' as abap.sstring( 3 ) ) as abap.unit(3) ) AS UnitOfMeasure,
  wtm.ExecutionDateTime AS ExecutionDateTime,
  wtm.WebTrckgMappgLgSts AS WebTrckgMappgLgSts,
  wtm.WebTrckgMappgLogText AS WebTrckgMappgLogText
FROM I_MKT_WebTrckgMappingLog AS wtm
LEFT OUTER JOIN I_MKT_WebTrackingMappingTP AS _WebTrackingMapping ON WebTrackingMappingUUID = _WebTrackingMapping.WebTrackingMappingUUID  -- association [1..1]
LEFT OUTER JOIN I_MKT_WebTrckgMappgLgSts AS _WebTrckgMappgLgSts ON WebTrckgMappgLgSts = _WebTrckgMappgLgSts.WebTrckgMappgLgSts  -- association [0..1]
;