Cannot make a setting of location source of supply

[former_member687629]

Hi experts,

I am currently working on PoC of the setting of location supply, trying to figure out how and whether Time Series Transportation Sourcing Indicator(RATIOTS) works. I would like to ask if the procedures I have done are correct or not because the result does not go as I expected.

What I want to achieve is the following; There are two DCs called 9990 and 9991 that are supplied by a plant called 1310. I want the plant to supply products called FG126 as the following ratio for three months.

First, I created CSV file of WKPRODLOCLOCFR so that location souring ratio can be input into DB. I successfully uploaded it without errors.

Second, I put X for the attribute of Time Series Transportation Sourcing Indicator(RATIOTS) so that the value of Location Sourcing Ratio(LOCATIONRATIO) can be referred in supply calculation. I uploaded the csv file of Location Source of Supply(SOURCELOCATION) successfully and confirmed that the change has been made via excel

Third, I uploaded my PA with dependency successfully.

Forth, looking back to planning view in excel, I put 1000 for the value of Consensus Demand Plan Qty for each periods as the value of FG126 which the plant supplies two linked DCs. That means, I want the value to be disaggregated based on the value of Location Sourcing Ratio(LOCATIONRATIO) as the excel presents.

However, the result of disaggregation is not as same as my expectation as the following capture....Can anyone help me fix the problem, plz?

。...

[sap_km · Accepted solution]

Hi Kenta,

If I understand the query correctly you want to disaggregate the consensus demand on the basis of Location Sourcing ratio for that you need to change the configuration of the consensus Demand plan Qty.

Please check the disaggregation mode and change it to Other key figure - Stored value and give the key figure for proportionality as LOCATIONRATIO:

Hope it helps!!

Regards

Arif

[former_member687629 · Accepted solution]

Oh, I totally forgot the setting of the target KF. thanks for reminding me of it. However, when I try to set the location sourcing ratio(LOCATIONRATIO), nothing shows up in the box...Can you tell me what should be done to help me this out.

[sap_km · Accepted solution]

Hi Kenta,

As the planning level is different for Location Sourcing Ratio due to which its not appearing in the search list. As an alternative you can follow the below steps in order to meet the requirement:

1) Create a new key figure at WKPRODLOCCUST level and copy Location sourcing Ratio to this key figure at Product Location level.

2) Use the above newly created key figure as the basis of disaggregation for consensus demand plan qty as shown in the below screen shot:

Consensus Demand entered at Aggregated level : 1000

Ratios maintained : 0.3 , 0.3, 0.4

Consensus Demand at detailed level : 300 , 300, 400

Hope it helps!!

Regards

Arif