Calculation of dependent demand

[Former Member]

Hi,

We are able to calculate the Consensus Demand. We are working on a copy of SAP2. Now we are trying to run the supply plan. We are not able to get output for DependentDemand.  Is it that we need to define the calculation of DependentDemand (ConsensusDemand*CRatio) or is it calculated through supply planning engine automatically?

Similarly please advice us for DepndentCustomer, Location and Production demands.

Regards

Atri Kundu

[Alecsandra · Accepted solution]

Hi Atri,

These KFs are computed by heuristics, calculations are part of the algorithm.

Did you maintain the sourcing ratios?

For example: Customer Sourcing Ratio is needed to get Dependent Customer Demand, to have your consensus propagated at the location level. And so on...

You can check the attachments of this note, they are a very good start in understanding the planning operators.

https://css.wdf.sap.corp/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3...

Regards

Alecsandra

[Former Member · Accepted solution]

Hi Alecsandra,

The link is not opening at our end. Can you resend it please?

Regards

Atri Kundu

[Alecsandra · Accepted solution]

Hi Atri,

Then check for SAP Note 2238074.

Regards

Alecsandra

[Former Member · Accepted solution]

Hi Alecsandra,

Thank you for your invaluable inputs.

1. In Customer Source master data, we have mapped CUSTOMERs with PRDID : 100001 (Finished Product ID) and LOCID: WWDC. Considering one LOCID, for all combinations , the CRATIO is 1

2. In Location Source master data , we have mapped the LOCFR: ACP (plant location) with PRDID: M550001F (Plant Product ID) and LOCID: WWDC (location to)

Kindly refer the image below which elucidates the same.

Questions:

1. As per our understanding, we should atleast be able to generate the DEPENDENTCUSTOMERDEMAND solely on the basis of CUSTOMER -PRDID- LOCID for the end product 100001 and LOCID: DC. But we are unable to generate the same.

2. How about DEPENDENTLOCATIONDEMAND at ACP? Should this set up also be able to generate that Key fig value too?

FYI, the rest of the data upload is like this:

Looking forward to your reply.

Best Regards,

Alok Joshi

[Former Member · Accepted solution]

Hi Alok,

Can you please check if your supply key figures are defined at planning levels mentioned in note 2238074 and follows the naming convention. Also please post the heuristic error log and calculation graph of Consensus demand key figure.

Thanks,

Rohit

[Former Member · Accepted solution]

Hello Rohit,

Thanks for your prompt inputs.

1. As advised by you in another thread - we have configured the CDP @ PERPRODCUST level as it is the input to Supply PLanning.

2. We have not modified existing ones or created any new Supply Planning key figures.

3. The CDP is getting generated successfully , and the Unconstrained Supply Planning heuristic - no limits also executes successfully without error. below is the CDP configuration:

Please note: in our case, the CUSTID-PRDID-LOCID mapping includes the marketing part num. While the LOCFR - LOCID - PRDID includes the manufacturing part num. I have provided sample illustration in the post above.

Am not sure what the problem is as CDP is getting generated at CUST-PRDID level , however the same is not being taken up by supply planning heuristic which is getting executed with errors.

Taking the same set of data for illustration, kindly refer the images below:

CUSTID, PRDID, LOCID

The execution log is as follows (snippet).

We can fix this warning information in the log by adding the appropriate resource - location mapping. However, the dependentcustomerdemand key fig should still get generated at the upstream level (please refer the previous post for sample data).

Request your guidance.

Best Regards,

Alok

[Former Member · Accepted solution]

Hi Alok,

There are certain constrained in supply planning algorithm which need to be taken care of. CDP@PERPRODCUST is stored+calculated key figure in your case so all key figures involved in calculation should be on same planning level and all of them should be marked as 'Indirect input for supply'.

However this doesn't seem a feasible choice here considering key figures used in calculation are at PERPRODCUSTSPCODE level.

I would suggest to create  another key figure CDP1@PERPRODCUSTSPCODE to define the third calculation and use copy operator to copy value in CDP@PERPRODCUST which can be marked as stored and Input for supply planning.

Thanks,

Rohit

[Former Member · Accepted solution]

Hi Rohit,

As per your inputs I've configured COPY OPERATOR and KF changes as follows:

1. SOURCE_KF: M1TECHCONSENSUSDEMAND (this is the dummy KF @ PERPRODCUSTSPCODE, please note I have also added M1TECHCONSENSUSDEMAND@PERPRODCUST = SUM(M1TECHCONSENSUSDEMAND@PERPRODCUSTSPCODE) )

2. TARGET_KF: CONSENSUSDEMAND

3. In the CONSENSUSDEMAND KF configuration , I have made it as Stored only and tried to delete the SPCODE related logic entries. However, on saving the KF changes , these logic entries are automatically reverting back ? Don't know why.

4. The copy operator is available in the excel add_in and gets executed without errors. However, it does not copy the value . I think it is related with point 3 as the CONSENSUSDEMAND KF changes are not taking place.

Regards,

Alok

[Former Member · Accepted solution]

Hi Alok,

I think you already raised another query for deletion of calculation definition. Please follow the steps mentioned there and then run the unconstrained plan once CDP is configured as suggested above.

We will keep this thread open only for discussing heuristic issue in case it is still not resolved.

Thanks,

Rohit

[Former Member]

Hi Rohit,

as per your advice we have removed the PromotionsFCSTQty KF reference to PERPRODCUSTEVENT. Please note this is the same configuration as copied from SAP2.

1. The unconstrained planning engine is running successfully and generating the dep demand, prod requirements calculations.

2. The constrained planning engine is throwing error. The error says: Error: SCMPLAN | 129 | LEADTIMECOMPLETE_FINITE | 12/7/2015 12:56

We have provided the prod lead time (1 month). Request your guidance in this regard.

Thanks,

Alok Joshi

[Former Member]

Hi Alok,

You can use algorithm type OPTIMIZE for constrained planning. For available algorithms, see section 10.9 in the model configuration document-

http://help.sap.com/download/ibp/ibp50_sps5_model_conf.pdf

Thanks,

Rohit

[Former Member]

Hi Rohit,

The  optimisers are running. However we want to run only a Constrained Supply Plan. Is it possible or is it that Constrained Supply Plan is run by Optimisers only?

If its possible to run a Constrained Supply Plan separately, please let me know how.

Regards

Atri Kundu

[Former Member]

Hi Atri,

You are right. Constrained plan is achieved using optimiser only. The earlier used complete_finite algorithm is now obsolete.

Thanks,

Rohit

[Alecsandra]

Hi Atri,

As this topic seems answered by Rohit, kindly close the thread.

Regards

Alecsandra

[Former Member]

Hi,

We are trying to run the Supply Planning Optimiser. However it is taking too much time or may be not running. Even after 2 to 3 hours the status shows "Running", and we are not getting any input.

Is there any specific reason for that?

Regards

Atri Kundu

[carsten_schumm]

Hello Atri,

dependent on the data volume and involved decisions the optimizer may run several hours. Especially if discrete decision are involved (e.g. fix costs or minimum lot-sizes). Please set a runtime limit in the optimizer profile and re-run the optimizer.

Regards, Carsten

[Former Member]

Hi Carsten,

If I am running an optimiser and if it is in running stage, how can I stop the process? Its still running and I am afraid it will not stop by itself.

Regards

Atri Kundu

[Former Member]

Hi Carsten,

Can we also have a status of the job and a job log as to what is happening inside?

Regards

Atri Kundu

[carsten_schumm]

Hello Atri,

optimization runs in the foreground can be canceled, but I don't think that it is possible for runs in the background. In the worst case they can only be stopped via a HANA restart.

Once an optimization run is finished, you select 'Show messages' to get some informations about the optimization run.

Regards, Carsten

[Former Member]

Hi Rohit,

As there was some confusion with SP code, we are now working in a planning areaa where there is no SP code. So the definitions of the KFs and Planning levels are as per SAP2. We have a multi level supply chain to be configured. The example is shown below:

We are able to generate the CDP and Statistical forecast at ProdCust. However we are not able to generate the Dependent Customer Demand even at WWDC level.

Request your help.

Regards

Atri Kundu

[Former Member]

Hi Atri,

I hope Consensus demand is configured at PERPRODCUST level now and marked as stored. In case it is stored and calculated both, then all key figures involved in calculation chain are selected as 'Indirect input for supply planning' and are at PERPRODCUST level only.

If the above statement is true, then please check that you are using correct planning operator to run heuristic. You can also try to run in batch mode and then refresh the planning view to see if output is generated. Also check the log and see if you get any error message.

In case you still don't see the result, i would suggest to raise an incident for SAP to check it further in your system.

Thanks,

Rohit

[Former Member]

Hi Rohit,

You are correct. CDP is both stored and calculated. Please note we did not make changes to the default settings (as copied from SAP2). The demand planning quantity is not configured as indirect input for supply planning. This is also as per SAP2 configurations.  We have marked Demand Planning Qty as Indirect input for supply planning and ran the supply heuristic (Unconstrained Demand and Supply Plan (no shortages)). It completed without errors but the Dep Cust Demand did not get generated.

The customer Ratio (C-Ratio) is provided in SOURCECUSTOMER table and also in the KF input table at PERPRODLOCCUST planning level.

The  table structures are as below:

   
 
 
  Regards

Atri Kundu
 
 
 
 
 
 
 
 

[Former Member]

Hi Atri,

Are you using the calculated value of demand planning qty in CDP  or stored? For calculated value, you need to mark other key figures involved in calculation chain like MKTGPROMOTIONQTY, MARKETINGFCST, SALESMGRFCSTQTY as indirect input.

Thanks,

Rohit

[Former Member]

Hi Rohit,

We
configured all the following supporting KFs as “indirect input for supply planning” .

1. Demand planning qty
2. Marketing + Promotions forecast qty
3. Marketing forecast qty
4. Promotions forecast qty
5. Sales mgr forecast qty
6. Sales forecast qty
7. Actual qty
8. Statistical forecast qty

Below is a sample out put for the PRDID:100001, LOCATION: WWDC , The heuristic ran without errors but didn’t generate the Dep Customer Demand Qty.

Regards

Atri Kundu

[Former Member]

Hi Atri,

To further analyse this in your system, please raise an incident to SAP.

Thanks,

Rohit

[Former Member]

Hi Rohit,

SAP incident 0000998744 2015 has been raised. Request if its possible for you to look into it

Regards

Atri Kundu