How to use CDS view to develop SAP Marketing contact's facet traceability tool

This article is about how to use CDS view to develop SAP Marketing contact facet traceability tool, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

The following describes the storage table of the contact facet data model in SAP Marketing:

Mainly these two tables:

CUAND_CE_IC_ROOT

CUAND_CE_IC_FCET

What I need now is to sort the number of Origin Data data source channels of Contact in the system from high to low:

Solution: develop two CDS view

Zcontact_origin

@ AbapCatalog.sqlViewName: 'SQL_VIEW_NAME'@AbapCatalog.compiler.compareFilter: true@AbapCatalog.preserveKey: true@AccessControl.authorizationCheck: # CHECK@EndUserText.label:' Contact Origin tool'define view zcontact_origin as select from cuand_ce_ic_root as an inner join cuand_ce_ic_fcet as b on a.db_key = b.parent_key {key a.db_key, a.name_text, a.smtp_addr, b.db_key as children_key, b.id_origin}

Zcontact_count

@ AbapCatalog.sqlViewName: 'ZCONCOUNT'@AbapCatalog.compiler.compareFilter: true@AbapCatalog.preserveKey: true@AccessControl.authorizationCheck: # CHECK@EndUserText.label:' count aggregation'define view ZCONTACT_COUNT as select from zcontact_origin {key zcontact_origin.db_key, zcontact_origin.smtp_addr, count (*) as facet_count} group by db_key, smtp_addr

The final effect:

The above is how to use CDS view to develop SAP Marketing contact's facet traceability tool. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.