Hi Gurus,
The standard CDS view, I_StatisticalKeyFigureItem, does not support data extraction and Change Data Capture (CDC) capabilities. The requirement is to enable these capabilities in the standard I_StatisticalKeyFigureItem CDS view.
We developed a custom CDS view ZI_StatisticalKeyFigureItem, but encountered the error: ‘Error while reading CDC annotation: Mapping field does not exist.’, for which this support case is created.
We believe this issue is related to the key field FiscalPeriod, which does not physically exist in the COSR table. In the I_StatisticalKeyFigureItem CDS view definition, the FiscalPeriod field has a constant value key cast as cast(cast(‘001’ as abap.numc(3)) as fins_fiscalperiod preserving type) This field is used in Mapping of @analytics annotation.
Could you please suggest an approach or best practice to handle such scenarios?
Best Regards
Arvind