APD issue

[Former Member]

Dear Experts

I have a query with 2 hidden key figure fields and 1 unhidden key figure that is adding these 2 using a formula key figure.

I created a APD using this query for a routine. The issue is the APD ran but the Key figure result is all 0.

The routine source fields have been selected from the query except the 2 hidden fields which are quantitites and the APD shows units for these also.
But i did not select the units for the formula key figure.

This key figure is shown as field KYF_003 . I filled up the target field structure for the routine.

I am not sure what TYPE (infoobject) to use for this keyfigure kyf_003.

Also, in the query designer, should the Technical name in the General tab of this keyfigure be filled with a technical id?

The routine generated Type declarations shows the Source field KYF_003 is defined as type FLOAT.

How does the system know it is type float when the components for this formula key figure is of type quantity?

This formula is  (Nodim(orecvalstck) + Abs(nodim(kf2)).

Thanks for reading.

Regards

Pascal

[Former Member · Accepted solution]

Hello SCN Experts

To make it simple, could you kindly confirm if APD allows use of  Formulas in a Query for routines.

I tried, it does not seem to allow. I tried with restricted key figure was ok.

Thanks so miuch for reading.

Regards

Pascal

[Former Member · Accepted solution]

Hi Pascal,

that should be no problem.

If you can run the query in BEx, you can use it in an APD (except for input variables).

Does it work in BEx?

[Former Member · Accepted solution]

Hi  2X U

Yes Sir, there is no problem in BEx, only when in APD.

Also, tried using Global Calculated key figure and the problem persists.

Thanks.

Regards

Pascal

[Former Member · Accepted solution]

that is not normal.

Anything that requires a user input won't work, but all the rest should.

Have you checked the intermediate data after the query, so before the routine?

Also: hiding kfs for an apd does not make sense of course.

I always create separate queries which are as simple as possible.