基于 CDS 的数据提取 CDC增量处理

参考资料:

基于 CDS 的数据提取 - 第 II 部分 增量处理 - SAP Community --- CDS based data extraction - Part II Delta Handling - SAP Community

单表CDC增量配置

@Analytics:{

    dataCategory: #DIMENSION,

    dataExtraction: {

       enabled: true,

       delta.changeDataCapture: {

            automatic : true

        }

      }

}

多表CDC增量配置

@Analytics:{

    dataCategory: #DIMENSION

    dataExtraction: {

       enabled: true,

       delta.changeDataCapture: {

         mapping : [ {

           table : 'name of table',

           role : #MAIN|#LEFT_OUTER_TO_ONE,

           viewElement : ['list of CDS view elements'],

           tableElement: ['list of table fields']

         }, ...

        ]

      }

   }

}

1. @analytics.dataExtraction.delta.changeDataCapture.mapping.table

This annotation serves to identify the name of the underlying table(s) to be logged.

此批注用于标识要记录的基础表的名称。

2. @analytics.dataExtraction.delta.changeDataCapture.mapping.role

This annotation is used for identifying the role of a participating table

此注释用于标识参与表的角色

The main table receives the value #MAIN. The key(s) of the CDS view correspond(s) exactly to the key(s) of the underlying main table to be logged. The outer table(s) receive(s) the value #LEFT_OUTER_TO_ONE_JOIN.

主表接收值 #MAIN。CDS 视图的键与要记录的基础主表的键完全对应。外部表接收值 #LEFT_OUTER_TO_ONE_JOIN。

3. @analytics.dataExtraction.delta.changeDataCapture.mapping.viewElement

In case of the main table, (identified by role: #MAIN), this list enumerates all exposed CDS view element names corresponding to the key fields of the main table

对于主表（由角色：#MAIN 标识），此列表枚举与主表的关键字段相对应的所有公开的 CDS 视图元素名称

In case of an outer table, (identified by role: #LEFT_OUTER_TO_ONE_JOIN), this list enumerates all exposed CDS view element names that correspond to key fields in this underlying outer table; in other words that correspond to the foreign key fields used in the on-conditions of the joins.

对于外部表（由角色：#LEFT_OUTER_TO_ONE_JOIN 标识），此列表枚举与此基础外部表中的关键字段相对应的所有公开的 CDS 视图元素名称;换言之，对应于连接条件中使用的外键字段。

4. @analytics.dataExtraction.delta.changeDataCapture.mapping.tableElement

This list enumerates the respective key fields of the underlying tables to be logged.

此列表枚举要记录的基础表的相应关键字段。