Skip to Content

 

Introduction

 

I have involved in conducting more than 150 interviews for SD and whenever I ask a question “How to restrict a saleable material to one particular customer”, an immediate response from the candidate was “Listing / Exclusion” functionality which is incorrect.  So this blog will explain why Listing / Exclusion functionality will not address this requirement and also how it can be addressed with the standard configuration.  A brief explanation has already been posted by me is here

 

Listing

I am not going to configuration and master data set up as it has already been discussed many times here.  If you explore this functionality, it doesn’t mean that system will restrict to other buyers.  That particular customer can only buy the listed materials and if you try to enter any other material that is not listed, it will not allow you as shown below:-

 

Message no. V1118

 

 

Exclusion

Similarly, exclusion will also won’t work for the subject question because, you need to maintain master data for all customers in vb01 which is NOT a Best Practice.

So, how to achieve this requirement.

 

Solution

 

Step-1 – Go to IMG > Sales and Distribution > Sales > Sales Document Item > Define Item Category Usage

 

Step-2 – Create a new “Item Usage” as shown below:-

 

 

Step-3 – Assign this Usage in VOV4

Note:-  If needed, you can also have a new item category and assignment can be made here accordingly

 

Step-4 – Maintain the Usage in VD51 with whom you want to restrict this saleable material

 

Step-5 – Now try to create sale order for any other customer and see how it works.

 

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Kivanc Bilgin

    Hi G Lakshmipathi ;

     

    Something’s not clear for me about your option on why Exclusion would not be a best practice regarding this process. You have mentioned ” exclusion will also won’t work for the subject question because, you need to maintain master data for all customers in vb01 which is NOT a Best Practice.”, but the same master data maintenance applies for customer material info record solution as well. One would have to maintain VD51 for all customers also, so I do not see the solution you have provided here “better” than the Exclusion solution (though I do not find it worse either, I see them both as doable as alternatives to themselves). Have I been missing something here?

    Cheers and thanks for your work as always.

    (1) 
    1. G Lakshmipathi
      Post author

       

      Let us assume, your client are having 5k customers and take the example of the above as one of the Business requirement.  Now will it be possible for you to maintain Exclusion for all those customers.  Moreover, over a period of time, this would be on the higher side.

      (0) 
      1. Kivanc Bilgin

        Why wouldn’t it be? This is a master data topic, and needs to be handled by master data team, either by Exclusion or CMIR functionality. Either way a maintenance would always be required, that’s what I’ve been saying actually. Also considering CMIR depends on distribution chains (sales org + dist. channel are key), it might even require more master data work than exclusion, where one could define their own tables according to business logic.

        (0) 
        1. G Lakshmipathi
          Post author

           

          Just imagine, over a period of time, your master data would be increased or sales area ?  So accordingly, we need to take a call.  In fact, in many client places, there is no separate master data team which also you need to take into consideration.

          (0) 
          1. Kivanc Bilgin

            But handling this situation via VD51 would not be solving this issue either: It is not easier than solving it via Exclusion.

            In VD51 the user would need to enter Customer nr, material nr, sales org and dist. chain, and also item category usage, while for Exclusion only customer nr, material nr and sales org could be enough. Less button clicks I would say.

            (1) 
  2. Swapnesh Shah

    Yes, I agree with Kivanc Bilgin points. Most companies don’t use CMIR instead, they prefer the listing and exclusion as it is well known and easy to maintain. But this is also a new approach to solving the issue but not the best approach.

    (0) 

Leave a Reply