I_MKT_WebTrckgMappingLog

DDL: I_MKT_WEBTRCKGMAPPINGLOG SQL: IMKTWTML Type: view BASIC Package: CUAN_CDS_WEB_TRACKING_MAPPING

Web Tracking Mapping Log

I_MKT_WebTrckgMappingLog is a Basic CDS View that provides data about "Web Tracking Mapping Log" in SAP S/4HANA. It reads from 1 data source (cuand_wtm_log) and exposes 8 fields with key field WebTrckgMappingLogUUID. Part of development package CUAN_CDS_WEB_TRACKING_MAPPING.

Data Sources (1)

SourceAliasJoin Type
cuand_wtm_log wtm from

Annotations (8)

NameValueLevelField
EndUserText.label Web Tracking Mapping Log view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IMKTWTML view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WebTrckgMappingLogUUID cuand_wtm_log webtrckgmappingloguuid NodeID
WebTrackingMappingUUID cuand_wtm_log webtrackingmappinguuid NodeID
WebTrckgRtrvlHeaderName cuand_wtm_log webtrckgrtrvlheadername
ValidityStartDate cuand_wtm_log validitystartdate Validity Start Date
ValidityEndDate cuand_wtm_log validityenddate ValidTo
ExecutionDateTime cuand_wtm_log executiondatetime
WebTrckgMappgLgSts cuand_wtm_log webtrckgmappglgsts
WebTrckgMappgLogText cuand_wtm_log webtrckgmappglogtext

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_WebTrckgMappingLog.
-- 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: IMKTWTML

CREATE VIEW I_MKT_WebTrckgMappingLog AS
SELECT
  wtm.webtrckgmappingloguuid AS WebTrckgMappingLogUUID,
  wtm.webtrackingmappinguuid AS WebTrackingMappingUUID,
  wtm.webtrckgrtrvlheadername AS WebTrckgRtrvlHeaderName,
  wtm.validitystartdate AS ValidityStartDate,
  wtm.validityenddate AS ValidityEndDate,
  wtm.executiondatetime AS ExecutionDateTime,
  wtm.webtrckgmappglgsts AS WebTrckgMappgLgSts,
  wtm.webtrckgmappglogtext AS WebTrckgMappgLogText
FROM cuand_wtm_log AS wtm
;