Why does data extraction annotation fail only on tabl...

[#1]

Hi,

I'm trying to enable data extraction on a CDS view based on SAP standard table PRHI.
Other standard tables (e.g. EKKO) work fine, but PRHI always fails.

I tried both full load and delta (CDC) configurations:

[Full load]
@analytics.dataExtraction.enabled: true

[Delta with CDC]
@analytics: {
dataExtraction: {
enabled: true,
delta.changeDataCapture: {
mapping:[ {
table : 'PRHI', role: #MAIN,
viewElement : ['posnr'],
tableElement : ['posnr']
}]
}
}
}

Both result in the same errors:
- An exception was raised. [Analytics]
- CDS view inconsistent [Analytics]
- Data extraction for CDS entity not possible [Analytics]

Is there a known restriction on PRHI for data extraction?
Or is there something special about this table?

Thank you.

[_ed7ae6]

@roland_szajko 
Hi,

Thank you for the suggestion.
I added @Analytics.dataCategory: #FACT but the same errors still occur.

- An exception was raised. [Analytics]
- CDS view inconsistent [Analytics]
- Data extraction for CDS entity not possible [Analytics]

Note: When I create a CDS view based on a table that does NOT contain
reserved keyword fields, data extraction works fine.
The issue seems to be specific to table PRHI which contains fields
named LEFT and RIGHT (CDS reserved keywords).

Do you have any other suggestions?

Thank you.