Question Re: Analytical Query on SAP Public Cloud: Parameter value help problem when creating query. in Technology Q&A

Analytical Query on SAP Public Cloud: Parameter value help problem when creating query.

BerkSaldir — Thu, 01 Aug 2024 17:07:01 GMT

Hello everyone,

I want to create an analytical query in public cloud system. The base CDS view was created in ADT. The CDS is as follows.

I defined value help definition for both fields Fiscal Period and Fiscal Year in cds. Firstly I tried to create a custom cds view in customizing system with that cds. Then, I created an analytical query with that custom cds. Value help of parameters when the query is published is as follows.

Value helps don't appear. Analytical query and custom cds look like the following in ADT.

As you can see, value help annotations didn't transfer to custom cds and analytical query. Then, I created an analytical query with cds which was created in ADT. Second analytical query's parameter value help is as follows.

Value helps don't appear again. Second analytical query looks like the following in ADT.

As you can see, value help annotations didn't transfer to analytical query. I found a solution for that problem. If correct value table is used in domain, value help is appeared but using tables in domain value table is restricted.

Is there any solution for that problem? Or is there a step I'm doing wrong?

Thanks in advance for any input.

Berk.

Re: Analytical Query on SAP Public Cloud: Parameter value help problem when creating query.

Enda — Fri, 02 Aug 2024 21:23:40 GMT

Adding tag SAP S/4HANA Cloud for Finance

Re: Analytical Query on SAP Public Cloud: Parameter value help problem when creating query.

HenrikeGroetecke — Tue, 13 Aug 2024 09:09:06 GMT

forwarded to experts

Re: Analytical Query on SAP Public Cloud: Parameter value...

Santosh_Jha1 — Fri, 16 Aug 2024 07:41:55 GMT

Hello,

You can refer to the following blog, on how to add value help for parameter in ABAP CDS Analytical query.

https://community.sap.com/t5/enterprise-resource-planning-blogs-by-sap/how-to-add-value-help-for-parameter-in-abap-cds-analytical-query/ba-p/13377436

Thank You!