CDS view extension error

[former_member226239]

Hi All,

I have a CDS view as follows.

@AbapCatalog.sqlViewName: 'ZCS_DD_CDS_00_1'
@AbapCatalog.compiler.CompareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS view 00'
define view Zcs_Dd_Cds_00_simple as select from snwd_so
{
    key so_id as order_id,
    buyer_guid,
    gross_amount,
    currency_code
}

Now, I am trying to extend this as follows:

@AbapCatalog.sqlViewAppendName: 'ZCS_DD_CDS_05_1'
@AbapCatalog.compiler.CompareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'View extension'
extend view Zcs_Dd_Cds_00_simple with zcs_dd_cds_05_simple {
  snwd_so.delivery_status,
  snwd_so.billing_staus,
  snwd_so.created_at,
  snwd_so.created_by
  }

but it is giving me 'Specify at lease one base table' error. Please advise on how to fix this.

Thank you,

[former_member226239]

Can someone help me with this please?

[Former Member]

Please try without @AccessControl.authorizationCheck and @AbapCatalog.compiler.CompareFilter - It is working for me.

And which version of S4HANA are you working with here?

Thanks,
Remya