CUAND_CMO_VISITS
CMO Dashboard: Web Visits
CUAND_CMO_VISITS is an SAP database table in S/4HANA. CMO Dashboard: Web Visits. It contains 9 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MKT_WebVisits | view | from | BASIC | Web Visits |
Fields (9)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | db_key | guid | GUID | |||
| brand | hpa_brand_id | |||||
| country | land1 | Country/Reg. | ||||
| audience_id | hpa_audience_id | |||||
| kpi_date | hpa_kpi_date | |||||
| visits | cuan_impressions | |||||
| unique_visitors | cuan_unique_impressions | |||||
| page_views | cuan_page_views |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- CMO Dashboard: Web Visits
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUAND_CMO_VISITS (
CLIENT, -- Client [mandt]
DB_KEY, -- GUID [guid]
BRAND, -- hpa_brand_id
COUNTRY, -- Country/Reg. [land1]
AUDIENCE_ID, -- hpa_audience_id
KPI_DATE, -- hpa_kpi_date
VISITS, -- cuan_impressions
UNIQUE_VISITORS, -- cuan_unique_impressions
PAGE_VIEWS, -- cuan_page_views
PRIMARY KEY (CLIENT, DB_KEY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA