EHS standard CDS views not showing in SAC platform

[former_member753065]

Hi Team,

We are trying to build some KPIs on EHS module(EM mainly) using standard CDS views as source in SAC cloud platform. We are using S/4hana live connection to fetch data from standard CDS view (like EHENVV_ALL_AMNS, EHENVV_AMNALL etc) however we are not able to see these CDS views as a datasource in SAC.

I can see some records in S/4Hana system however not able for find these views either in Query Design tile of Fiori application nor in SAC.

Please let me know if I am missing something here, help me to get the data in SAC specifically EM(water, energy, land) data into SAC.

Thanks,
Pooja Paliwal

[michaelf_]

Dear Pooja Paliwal,

the CDS Views you mentioned (EHENVV_ALL_AMNS, EHENVV_AMNALL) are not published as an oData-Service. Therefore, they can't be selected as Data Source on the SAC environment. A quick workaround would be to create a custom gateway project and include the CDS views into it.

With kind regards,

Michael

[former_member753065]

Hi Michael,

My team has done this part & now I am able to see CDS view & query in my live connection with S4hana system however I am not able to see any data. I have tried to create AFO report on the same CDS view & here I can see the data with measure.

The error which is coming while selecting the data source "The data source has no measures" Or "can not read property 'type' of null".

Please help me if we are missing any annotation while using our a custom CDS view.

Thanks,

pooja

[michaelf_]

Hi Pooja,

can you please test if the odata-service for the CDS views is working? Just use the /IWFND/GW_CLIENT transaction or some REST-Tool to test.

With kind regards,

Michael