IP - Trying to better understand FOREACH IN REFDATA

[Former Member]

Hi,

We would like to implement a copy function to copy actual data to plan (multi-provider). I know I'll need to use FOREACH IN REFDATA but I would like to better understand it.

If you use FOREACH IN REFDATA, will this loop over your reference data within each block of your plandata? For example if you have only two combinations in your plan data, will it then loop twice over the entire reference data (with the characteristics in the foreach in refdata loop)?

Will the FOREACH IN REFDATA also work even if you have no planning data at yet created?

=> we would like the budget process to start with a copy of actual data (to default data, but also to generate the most important combinations). We cannot use standard copy because there are some special items to be taken into account.

regards

D

[Former Member · Accepted solution]

D,

This is my understanding.Say you have chars X,Y,Z in the agg level.You are using a filter(package) consisting of only X and Y.The filter leads to the construction of the planning blocks along with the fields to be changed.

Now in my Formula function , if I want to access the values of the char Z , I would use the FOREACH REF data for accessing the Z values.So it will loop exactly as many times as the combination of values permit for Char Z in the aggregation level.

Not sure how you are using this construct in your special case.

Regs,

skaBPS

[Former Member · Accepted solution]

I want to loop over all actuals within one company code (which will be maintained in the filter). For example we have company code, customer and product

-> I want to copy ALL actual data within company code of the filter. When I start I have no plan data

D

[Former Member · Accepted solution]

Hi,

I solved it myself. foreach in selection should be used ... since foreach in refdata only starts from what is in your plandata.

D