Skip to Content
0
Aug 21, 2020 at 08:22 PM

How to pass analytical query CDS View parameter to another query prompt?

97 Views Last edit Aug 25, 2020 at 02:52 PM 2 rev

Hi Experts,

I am unable to find a solution for a requirement where I need to pass the CDS view parameter from the main query entered at selection screen to a Jump To target query having the object as a prompt. Example: I have P_Version as a CDS view parameter in Analytical query 1. This parameter is used to get the Plan Amount based on the entered Version. The query has both Actual & Plan Amount and Actual Amount is only entered as Version 0, hence Version is not in the report layout.

The requirement is to pass the P_Version to a Plan Line Item query which has Version as a prompt. I am unable to pass the entered value from selection screen of main report to target report in the Fiori Target mappings.

Is there a standard way a pass the CDS view parameter for a object not in the report layout?

We are on S/4HANA 1809 FP1 On-prem.

Any inputs would be highly appreciated.

Thanks

Ajesh