C_MKT_WebTrckgMappingLogTP

DDL: C_MKT_WEBTRCKGMAPPINGLOGTP SQL: CMKTWTMLTP Type: view CONSUMPTION Package: CUAN_CDS_WEB_TRACKING_MAPPING

Web Tracking Mapping Log

C_MKT_WebTrckgMappingLogTP is a Consumption CDS View that provides data about "Web Tracking Mapping Log" in SAP S/4HANA. It reads from 1 data source (I_MKT_WebTrckgMappingLogTP) and exposes 12 fields with key field WebTrckgMappingLogUUID. It has 1 association to related views. Part of development package CUAN_CDS_WEB_TRACKING_MAPPING.

Data Sources (1)

SourceAliasJoin Type
I_MKT_WebTrckgMappingLogTP I_MKT_WebTrckgMappingLogTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_MKT_WebTrackingMappingTP _WebTrackingMapping $projection.WebTrackingMappingUUID = _WebTrackingMapping.WebTrackingMappingUUID

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CMKTWTMLTP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Web Tracking Mapping Log view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.representativeKey WebTrckgMappingLogUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
UI.headerInfo.typeName Validation Result view
UI.headerInfo.typeNamePlural Validation Results view
UI.headerInfo.title.value WebTrckgRtrvlHeaderName view
VDM.viewType #CONSUMPTION view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WebTrckgMappingLogUUID WebTrckgMappingLogUUID NodeID
WebTrackingMappingUUID WebTrackingMappingUUID NodeID
WebTrckgRtrvlHeaderName WebTrckgRtrvlHeaderName
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ValidityDate ValidityDate Valid On
ExecutionDateTime ExecutionDateTime
WebTrckgMappgLgSts WebTrckgMappgLgSts
WebTrckgMappgLgStsCriticality WebTrckgMappgLgStsCriticality
WebTrckgMappgLogText WebTrckgMappgLogText
_WebTrackingMapping _WebTrackingMapping
_WebTrckgMappgLgSts _WebTrckgMappgLgSts

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_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: CMKTWTMLTP

CREATE VIEW C_MKT_WebTrckgMappingLogTP AS
SELECT
  WebTrckgMappingLogUUID,
  WebTrackingMappingUUID,
  WebTrckgRtrvlHeaderName,
  ValidityStartDate,
  ValidityEndDate,
  ValidityDate,
  ExecutionDateTime,
  WebTrckgMappgLgSts,
  WebTrckgMappgLgStsCriticality,
  WebTrckgMappgLogText
FROM I_MKT_WebTrckgMappingLogTP
LEFT OUTER JOIN C_MKT_WebTrackingMappingTP AS _WebTrackingMapping ON WebTrackingMappingUUID = _WebTrackingMapping.WebTrackingMappingUUID  -- association [1..1]
;