I want to extend standard CDS /PF1/C_VH_ACCOUNT_ID with “segment_id” field from table /PF1/DB_SGMT_ACT. The reason is that i want to use this field to build additional access control to this CDS and restrict the usage of one of the Fiori Apps that is based on that. I’ve made the below:
but when activating it raises the error msg:
Can you give me some advice how to do it properly? I tried to replace the direct association to the table with other custom cds that fetches data from the table but same result. Is it even possible to achieve what I want with this CDS?