PF Distribution by Reference Data: Cannot find reference data

[former_member539392]

Hi Experts,

i'm facing with an situation when PF Distribution by Reference Data says to me that it cannot find reference data for sub-process 1 of the function while tracing of PF Sequence.

Below I'll describe my case and what I would like to do.

I'm entering data on materials group that I expected to be distributed to materials by Distribution by Reference Data planning function type.

I have two BW-queries on material group (Z2TGB) level and one more on material (Z2ARTIC). I'm inputted value 5.000 on material group level and saved. As you can see there is no materials in query. It should place 5.000 on material #.

It works well and when I'm opening BW-query with materials I see result is here:

Let's go next.

I have created a planning function and make all steps for my case logic. (Or not?)

Then created PF Sequence to trace and Execute step with Trace. PF was executed without errors but show warning with "Cannot find reference data for sub-process 1 of the function" message

What I'm doing wrong? Why it doesn't distribute as I expected?

Regards,

Alexander.

[gregor_dieckmann · Accepted solution]

Hi Alexander,

you want to distribute the value 5000 (and the other key figures as you have chosen 'Select all Key Figures') from the initial material to the three other materials, but for the key figure with value 5000 you have no key figure value (implicitly 0) on the non-initial materials; thus the system cannot determine the weight factors for the distribution. Under 'Behavior if the referenced data exists' use the option 'Equal Distribtion ...'.

Regards,

Gregor

[former_member539392 · Accepted solution]

Hi Gregor,

you're AWESOME! As usual 🙂

I've copied via PF Copy type data from actual aDSO to planning aDSO and then execute Distribution by ref PF. Thank you!

Regards,

Alex.