No representative key element found in CDS view

[Former Member]

Hi Expert,

I create a ABAP CDS view with annotation as below:

@ObjectModel.representativeKey: 'FORM_ID'

@AbapCatalog.sqlViewName: 'ZTAB_LINEV'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'table line text for replacing text universe' @Analytics.dataExtraction.enabled: true

@Analytics.dataCategory: #DIMENSION

when I activate this CDS view, I get error message below, even though I already define representive key in annotation

" No representative key element found in CDS view "

by following picture, you can see there is 'FORM_ID' field in the CDS view.

fields-in-cds-view.png

[Former Member]

Hi Expert,

I create a ABAP CDS view with annotation as below:

@ObjectModel.representativeKey: 'FORM_ID'

@AbapCatalog.sqlViewName: 'ZTAB_LINEV'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'table line text for replacing text universe' @Analytics.dataExtraction.enabled: true

@Analytics.dataCategory: #DIMENSION

when I activate this CDS view, I get error message below, even though I already define representive key in annotation

" No representative key element found in CDS view "

by following picture, you can see there is 'FORM_ID' field in the CDS view.

fields-in-cds-view.png

[UweFetzer_se38]

Missing "KEY" in front of the first column?

[Former Member]

thanks.

[former_member39336]

Hi,

i had experience in this issue and below is the way how i resolved it.

we need to provide the following Annotation to overcome this error.

@ObjectModel.representativeKey: [ 'Countrykey', 'Bankkeys', 'BankShortKey', 'Companycode' ]

Here the fields Mentioned in [ ] are key fields in my case.

Mention all the key fields in your CDS View with above annotation and activate the CDS View and test it . it will work.

Regards

Sri Ram

[lakshminarasimhan_n4]

Thanks, worked fine. i was getting the error only for "master data extractor" and the code @ObjectModel.representativeKey: fixed it. Thanks again.