CTM-how to restrict to finite planning

[former_member906762]

Hello all ,

,

                       Can you please tell me how to restrict CTM for finite planning .

                       Currently we are trying to design a prototype to generate PurReq using CTM .

The following have been maintained

1) T lane from A to B.

2)  A procurement type F is maintained.

3) Master Data selection Profile for product X at A and B( these have been maintained only in location product tab of master data selection)

Scenario:

                                       B                                             A

                                 No stock                                  stock -2(april 3rd)

                                                                                    Pchord-3( april19th)

Q1)  We created a sales order of quantity 1 with a request date april 3rd

Result :

                                       B                                             A

                                 No stock                                  stock -2(april 3rd)

                                  Purreq(1)                                               

                                                                                   Pchord-3( april19th)

Now the issue is how is that the CTM run created Purreq at B but there is no Preqrel at B.

Q2) Made the setting in master data selection " select dependent data automatically "

Created sales order of quantity 4 with request date april6th.

Result:

                                         B                                             A

                                 No stock                                  stock -2(april 3rd)

                                  Purreq(4)(april4th)               Purreq-2(april 4th)

                                                                                   Preqrel-2(april 4th)              

                                                                                   Pchord-3( april19th)

The issue is i dont get why CTM is generating such results ...what it should have done is created

                                           B                                             A

                                 No stock                                  stock -2(april 3rd)

                                 Purreq(4)(april19th)                 Pchord-3( april19th)

                                                                                      Preqrel-4(april19th)

REgards,

Nick

[rajkj]

Hi Nick,

I appreciate the way you presented the query with all the details.

From the given data with respect to Product X, the supply network can be represented as follows (approx).

External supplier --------------------> Location A ------------------------------> Location B

Location B - Destination

Location A - Source

Q1)  We created a sales order of quantity 1 with a request date april 3rd
Result :
                                       B                                             A
                                 No stock                                  stock -2(april 3rd)
                                  Purreq(1)                                                
                                                                                   Pchord-3( april19th)

Since you haven't selected "Select dependent data automatically", the CTM model does not consider the external supplier to Location A.

You have created a Sales order at A to deliver Product X at

[former_member906762]

Hello Rajesh,

                        Sorry for getting you confused .....in the above scenario i have question 2 also where i maintained the setting .

The sales order is created on location B and it is to take from location A . There is no external supplier for A currently ....how i want the system to behave is

                                          B                                             A

                                 No stock                                  stock -2(april 3rd)

                                 Purreq(4)(april19th)                 Pchord-3( april19th)

                                                                                      Preqrel-4(april19th)

but currently it is doing something like this

                                            B                                             A

                                 No stock                                  stock -2(april 3rd)

                                  Purreq(4)(april4th)               Purreq-2(april 4th)

                                                                                   Preqrel-2(april 4th)             

                                                                                   Pchord-3( april19th)

I want it to check when the stock is available at location A and generate PREQREL for that date ....if you see above what the scenario is

We are having a sales order of quantity 4 on B for April 4th , but since a total quantity of 4 is not available at location A till 19th of april i want it to generate Preq for 19th ...but currently it is satisfying the requested date itself by consuming 2 stock at A which is readily available and it is creating Preq of 2 at A.....i dont want it to generate any Preq at the supplying location . It should just see when the stock is available and generate accordingly .

[former_member906762]

To add to that ...both A and B are DC and the only Tlane maintained is with

A as source and

B as Destination .

There is no Tlane where A is destination .

Why is it generating Purreq at A????....we dont want that .

[rajkj]

Hi Nick,

It looks like, my message did not come completely. Anyway, I will update it as per the new information you sent and respond ASAP.

Thanks,
Rajesh

[rajkj]

Hi Nick,

The system tried to fulfill the demand partially. Please check your CTM global settings and deselect the 'Allow Shortage' Flag as shown below. (t.code /SAPAPO/CTMCUST)

Please run your test scenario and let me know the results to move forward.

Thanks,

Rajesh

[former_member906762]

Hey Rajesh ,

                       Sorry about the above thing ver there is small mistake

                                         B                                             A

                                 No stock                                  stock -2(april 3rd)

                                  Purreq(4)(april4th)               Purreq-2(april 4th)

                                                                                  Preqrel-4(april 4th)            

                                                                                   Pchord-3( april19th)

i have not tested your above setting and will update you soon ...but to your point the system is satisfying the demand .....for a

Sales order            request date(4th april)            quantity 4       location B

the system is creating a purreq of 4 on 4th april at B and satisfying it but what it is doing at A is as citied above .

Regards,

Nick

[former_member906762]

Hello Rajesh ,

                                I ran running the above setting  but the results are still the same to satisfy the demand from B it is still generating quantity 4 preqrel at A and also a quantity 2 purreq at A both for 4th april.

[former_member906762]

Hello Rajesh,

          It is satisfying the demand but the issue is it should have satisfied the demand on 19th april but taking into consideration that there is a receipt on 19th at A....but wat it is doing is ....to satisfy the demand on 4th itself ...the system is like

                                         B                                             A

                                 No stock                                  stock -2(april 3rd)

                                  Purreq(4)(april4th)               Purreq-2(april 4th)

                                                                                  Preqrel-4(april 4th)           

                                                                                   Pchord-3( april19th)

but as i mentioned initially in my question what i want the system to do is

                                           B                                             A

                                 No stock                                  stock -2(april 3rd)

                                Purreq(4)(april19th)                 Pchord-3( april19th)

                                                                                     Preqrel-4(april19th)

Regards,

Nick

[rajkj]

Hi Nick,

Thanks for the update. It's good to know that your system is generating the results as expected from standard settings.

Regarding moving the order fulfillment to your required date, there are 2 alternatives.

• Master data setting 'Late Demand Fulfillment' in your CTM profile that influence CTM engine run. However, it may not be a good idea to stretch for 2 weeks.
  

       t.code /SAPAPO/CTM

       (Strategies -> Special Strategies)

• Manipulate with ATP categories that make up your supplies as shown below and update your Order selection for supplies. It will influence the CTM engine to wait until you have sufficient stock to fulfill the demand.

       t.code /SAPAPO/CTMORDSEL

Please run your test scenario and let me know the results. If there is an issue, I would appreciate if you could share the order selection info details for both demand and supplies.

Thanks,

Rajesh

[former_member906762]

Hello Rajesh,

                      Late demand fulfillment is set to standard procedure ..

i tried testing the supply order selection as u showed above

Supply selection is set as shown above by you ...

Demand selection is set to all ATP categories .

When i run i still have the same result.

                                          B                                             A

                                 No stock                                  stock -2(april 3rd)

                                  Purreq(4)(april4th)               Purreq-2(april 4th)

                                                                                  Preqrel-4(april 4th)          

                                                                                   Pchord-3( april19th)

[former_member906762]

Hello Rajesh,

                      Late demand fulfillment is set to standard procedure ..

i tried testing the supply order selection as u showed above

Supply selection is set as shown above by you ...

Demand selection is set to all ATP categories .

When i run i still have the same result.

                                          B                                             A

                                 No stock                                  stock -2(april 3rd)

                                  Purreq(4)(april4th)               Purreq-2(april 4th)

                                                                                  Preqrel-4(april 4th)          

                                                                                   Pchord-3( april19th)

[rajkj]

Hi Nick,

Oops.. I forgot to ask you about the basic configuration step.

Could you please let me know the details of your supply categorization profile and search strategy? That will allow me to think about the next move. (t.code /SAPAPO/CTMSCPR, /SAPAPO/CTMSUPCAT, and /SAPAPO/CTMSSTRAT)

I would also appreciate if you could restrict your Supply Categories limited to the following.

Supply Category - Stock

ATP Category - CC - Valuated, unrestricted-use stock

Supply Category - Confirmed/Firmed Receipts

ATP Category - BF - Purchase Order

Thanks,
Rajesh

[former_member906762]

Hello Rajesh ,

                        Currently we are using the basic profile and except for master data selection,demand prioritization , demand and supply selection ...i have not any thing else set up .

The tcode u have mentioned above are all blank ...i have nothing maintained over there.

REgards,

Nick

[former_member906762]

I have not defined any supply categorization because ...we are not limiting any use of stock .

What we are looking for is the demand be satisfied when there is sufficient supply ...might be in future . The point i am not getting is why is it generating Purreq at A .

Regards,

Nick

[rajkj]

Hi Nick,

I will try to setup a model in my system and provide you the details.

Thanks,
Rajesh

[former_member906762]

Hello Rajesh,

Thank you for the help ...appreciate that ....i would love to brief u what we are having currently

Our Requirement is to generate Transfers between location based on order sequencing .

Both A and B are DC there is no Plant

We have maintained Product X at A and B as external Procurement(F).

A Tlane is maintained with A as source and B as destination .

REgards,

Nick

[former_member906762]

Hello Rajesh,

                          I am trying to achieve the above functionality by making the product X at B as IN HOUSE PRODUCTION and create a resource and PPM for it with 0 capacity and check how the system would react .

I have created the PPM and the resource but when i run CTM master data check it says

No source of suply was found for X at location B.

Can you throw some light on this .

Regards,

Nick

[Former Member]

My understanding is that CTM is a tool for in-time demand fulfillment. This is an intrinsic hard constraint. CTM will only fill the demand LATE if it CANNOT fill it on-time.

In this case, the lead time is probably such that the product can be procured before the existing P.O. is received. You cannot force CTM to fill late if it can fill on time. Now, if you increase the lead time such that creating a new preq will deliver after april 19th, then the system will determine that it cannot fill demand on time, so it will try to minimize lateness by consuming the PO for April 19th.

In addition, why do you not want your demand to be filled in time on the April 4th?

If you must, then you are using the wrong SNP tool. You should consider optimizer and enter zero for cost for late delivery and positive cost for storage.

Please reflect on it first, and then reconsider your problem.

Does this help?

[former_member906762]

Hello SAP APO,

                              Thank you for your answer ....our requirement is

--> Based on predefined sort sequence create Stock transfer between A and B .

Now if we use Optimizer according to my understanding we cannot prioritize sales order .

Hence we are thinking of using CTM .

Now y we need it on april 19th is

We have no plants here in US and we give confirmation to the customer based on when the product is coming . Both A and B are DC and all the product is coming in location A and from there the product is transfered based on  sales order .

Now i am trying to understand if the functionality that i have been discussing above question can be achevied using CTM or not .

REgards,

Nick

[Former Member]

Nick,

I spent a couple of hours and found a solution that does what you want but it might require further tuning. Below is some high-level info:

I created supply categorization and search sequence considering only CC and BF ATP categories (stock and pchrord). Then I setup the master data for a component / product and created stock and pch order CIFed from ECC. Then I ran CTM with different options to restrict CTM from generating purch req (prevent on-time demand fulfillment) and the best option I found was using the 'order creation start' = 20 days on strategies tab on the CTM profile I created for your scenario. You can use a value here that suits your business.

As a result, CTM was instructed to look at CC and BF only and it generated a PerqRel using 4 out of 2 CC and 3 PchOrd.

I have the screen shots if you want. Does this help?

[former_member906762]

Hello SAP APO,

                         Can you please send the screen shots of the supply categorization and the search sequence . The only issue with your solution above is your are restricting Order creation by defining 20 days ...but we are looking for it to look at the future supplies that are coming in instead of creating a new Purreq to satisfy the demand on the given date .

We can achieve the above functionality by Optimizer by giving cost . Is there something in CTM where we can achienve this in CTM . One thing what i am thinking off is make the product X at location A as in house production and if we could restrict CTM to only consider purreq ,stock and Purchase Order .

But to try that i need to know how to restrict CTM to use only this supplies and if you send me the screen shots that would be great .

REgards,

Nick

[Former Member]

docx attachment with screen shot is giving error as not allowed. maybe my screen captures are in some format that's not allowed.

please send ur email id.