https://community.sap.com/t5/application-development-and-automation-discussions/regarding-error-while-reading-cdc-annotation-mapping-field-does-not-exist/m-p/13783670#M2029676 <P>Hi Gurus,</P><P>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.<BR />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.</P><P>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 <a href="https://community.sap.com/t5/user/viewprofilepage/user-id/15206">@analytics</a> annotation.</P><P>Could you please suggest an approach or best practice to handle such scenarios?</P><P>Best Regards<BR />Arvind</P> Tue, 06 Aug 2024 04:42:26 GMT sharmaar 2024-08-06T04:42:26Z https://community.sap.com/t5/application-development-and-automation-discussions/regarding-error-while-reading-cdc-annotation-mapping-field-does-not-exist/m-p/13783670#M2029676 <P>Hi Gurus,</P><P>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.<BR />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.</P><P>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 <a href="https://community.sap.com/t5/user/viewprofilepage/user-id/15206">@analytics</a> annotation.</P><P>Could you please suggest an approach or best practice to handle such scenarios?</P><P>Best Regards<BR />Arvind</P> Tue, 06 Aug 2024 04:42:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regarding-error-while-reading-cdc-annotation-mapping-field-does-not-exist/m-p/13783670#M2029676 sharmaar 2024-08-06T04:42:26Z