cancel
Showing results for 
Search instead for 
Did you mean: 

Error reading CDC annotations: mapping field does not exist [Analytics] - TM tables

Loed
Active Contributor
0 Kudos

Hi,

Just wanted to check how to remove the error shown below? Not sure if it is related to the tableElement fields used since they are not the same.

1. How will the CDS view knows that parent_key and db_key should be matched if they are not the same?

2. Is the field possible to be renamed? Let's say I will change the db_key to "parent_key".

3. Do you know any standard CDS view which I can use for my scenario? I am about to join the five (5) TM tables below.

/SCMTMS/D_TORDRF
/SCMTMS/D_TORROT
/SCMTMS/D_TORITE
/SCMTMS/D_TORSTP
/SCMTMS/D_TOREXE 

Here is the full code.

@EndUserText.label: 'TEST_TM Fields'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@Analytics: {
    dataCategory: #FACT,
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
            mapping:[
                {
                    table: '/SCMTMS/D_TORDRF', role: #MAIN,
                    viewElement: ['NodeID'],
                    tableElement: ['parent_key'] },
                {
                    table: '/SCMTMS/D_TORROT', role: #LEFT_OUTER_TO_ONE_JOIN,
                    viewElement: ['NodeID'],
                    tableElement: ['db_key'] }
            ]
        }
    }
 }
@AccessControl.authorizationCheck:#CHECK
@AbapCatalog.sqlViewName: 'YV_TEST'
@AbapCatalog.preserveKey: true

define view Y_TEST
as select from /scmtms/d_tordrf as tordrf
left outer join /scmtms/d_torrot as torrot
on tordrf.parent_key = torrot.db_key

{
key tordrf.db_key as tordrf_db_key,
key torrot.db_key as torrot_db_key,
tordrf.btd_id,
tordrf.parent_key
}

Thanks a lot.

Loed

Paresh_Dalvi
Discoverer
0 Kudos
Hi Loed, Did you found any solution I am facing the same error but CDS view is getting activated also able to view the data but error is still appearing.

Accepted Solutions (1)

Accepted Solutions (1)

Loed
Active Contributor
0 Kudos

Answers (0)