Cannot distribute data to the 0CALQUARTER by using the Distribution by Reference planning function

[mollaei_amir]

Hi experts,

I have an Real-time InfoCube like this:

CustomerGP - Calyear - Calquarter - Version - Currency - Net-value

01 - 2019 - 20191 - A - USD - 100

01 - 2019 - 20192 - A - USD - 130

01 - 2019 - 20193 - A - USD - 170

01 - 2019 - 20194 - A - USD - 100

02 - 2019 - 20191 - A - USD - 150

02 - 2019 - 20192 - A - USD - 130

02 - 2019 - 20193 - A - USD - 120

02 - 2019 - 20194 - A - USD - 200

03 - 2019 - 20191 - A - USD - 250

03 - 2019 - 20192 - A - USD - 200

03 - 2019 - 20193 - A - USD - 350

03 - 2019 - 20194 - A - USD - 300

These are my actual data and I want to plan base on them. I've put my actual and plan data into one Real-time Infocube. After the actual data transferred to the InfoCube, I've changed the load behavior of the InfoCube to the planning mode for executing the planning functions.

I want to plan these data for Calyear 2020, so first of all I run a copy function (change the Calyear to 2020 and Version to B) so my plan data become like this:

CustomerGP - Calyear - Calquarter - Version - Currency - Net-value

# - 2020 - 00000 - B - USD - 2100

Then, I revaluate the net-value by 20 percent:

CustomerGP - Calyear - Calquarter - Version - Currency - Net-value

# - 2020 - 00000 - B - USD - 2520

Now, I want to distribute the net-value to the CalQuarter. In this regard, my filter, and planning function selections set as follow screenshots:

Fig.1- Screenshot from my filter for the Planning Function:

Fig.2- Screenshot from my Planning Function (Distribution by Reference):

Unfortunately, when I run this planning function, I've encounter with this message:

"Cannot find reference data for sub-process 1 of the function".

I must mention that I'm using the SAP BW 7.4.

Any help would be appreciated.

Thanks in advance,

Amir

[mollaei_amir · Accepted solution]

Hi experts,

I've found a solution to my problem and I'm sharing with you maybe someone encounters the same problem.

The point is that because the 0CALQUARTER or 0CALMONTH are in the form of Year/Quarter or Year/Month, you can't distribute it by a reference. Instead, you can use the 0CALMONTH2 InfoObject and due to the Month form of it (it only includes month and not year), you can distribute the data by reference, just like the Material Group, Division and so on.

As you can see, the point is that your selected InfoObject in the "Fields to be changed" column of the Distribution by Reference function must include one type of data. Because your reference data and the data to be changed must be the same.

Let me explain to you by example:

Consider we select the 0CALMONTH in the "Fields to be changed" column so we have:

Data to be distributed is non-assigned (#) and we want to distribute it to the month. The first month (January) value of the 0CALMONTH for the year 2020 that we want to plan is 202001, and it has the value of 201901 for reference data, so the distribution cannot be done. But when we use the 0CALMONTH2 InfoObject its value for both of the plan and reference data is 01, and because it is the same for both of them distribution can be done.

I hope that it helps you.

Best Regards,

Amir