Skip to Content
0

how to define the dynamic columns in BPC for S/4 HANA

Apr 25 at 05:32 PM

58

avatar image

We need to create a planning application for 12 month planning, the category for the 12 month include both actual and planning data, the columns need to be dynamic for actual/plan according to the month we run the application. for example if the we run the application in April, the first three month need to be actual, while the rest of the months need to be plan, how can we define thus kind of query in query designer?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Vadim Kalinin Apr 25 at 07:01 PM
0

What client are you talking about?

Share
10 |10000 characters needed characters left characters exceeded
Jerry Wen Apr 26 at 02:08 PM
0

We are using BPC for S/4 HANA which is embedded BPC, we fine the query using query designer, where we need to define the category as actual/planning depend on the month the users do their planning, for example if the month is April, the category value for the first three columns of Jan, Feb and Mar should be actual, while the rest of the month should be planning, the key point here is make the category value dynamic through the query variables. I am not sure how to achieve it here.

Share
10 |10000 characters needed characters left characters exceeded
Lucas Costa Apr 27 at 10:27 AM
0

The approach to achieve this is by using a number of query variables and calculated kf at the query level

https://archive.sap.com/discussions/thread/1734499

Share
10 |10000 characters needed characters left characters exceeded
Jerry Wen Apr 30 at 02:45 PM
0

I have go through the suggested link, looks like the key point is to create a variable to make the category value change to avctual/planning based on the system date. I did not find this information in that post, should we create a customer exit for that by using ABAP? anybody can through a light on this?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Yes, variable type SAP-Exit. Within the exit you can read the other characteristics selections. It's all in table

i_t_var_range. Simply do a read table using the info object category as key.

The implementation should be triggered when step = 2 (i_step = 2).

0
avatar image
Former Member Apr 30 at 07:32 PM
0

Hi Jerry,

Yes, a variable (SAP Customer) Exit has to be created for Period, which will hold the derivation for retrieving Category based on period of selection.

Thanks,

Harsha

Share
10 |10000 characters needed characters left characters exceeded