Material restriction by Customer

[Former Member]

Hello Gurus - I have a biz requirement where they would want a specific customer (sold to) to be able to order specific materials only. At first, I got a thought to define a division wherein that sold to and material be defined on that division. I am told that there is another way of achieving it and that is by condition records. I do understand that this is something very much similar to a info record in purchasing but am not sure how condition record would achieve it in sales processing. They need something of this sort.

Customer Materials they can order

QVC material1, material2, material5, material6 etc.

JC Penney Material3, Material4 etc

Thanks a bunch !!

[Former Member · Accepted solution]

Check out this link

Regards,

Gauravjit.

reward points if the solution helps

[Former Member · Accepted solution]

Gauravjit - I believe I am almost there after setting up a new condition type per your instructions....But when I am trying to create an order for a customer I defined int he new condition type (customer, sales org, material)...its still not picking the new condition type from the procedure.

I tried debugging the material determination step, but all it pulls from T685 (condition table) is the old condition type that was set. Here's what I did:

1. New condition type and created access sequence. The new condition type will have Sold to #, Sales org, Distribution Channel and Material as selection fields.

2. In the procedures defined, I added this condition to procedure A00001. Now this procedure has two conditions, one that was previously created and the new one that I just created.

3. For the sales order type, I see, we already have procedure A00001 assigned. So now while entering the order, the system checks the procedure assigned to the order type. It then goes to the first condition type defined and checks for material listing. Even though , I have given the step # ahead of the old condition for my condition type in the procedure control set up, its still taking up the old condition type.

I believe I did create the condition type and access sequence correctly. Table T685 is reflecting the new condition type.

Can you throw some light on this...I believe I'm almost there, thanks to your advises !!!

[Former Member · Accepted solution]

Hey Gaurav - I must apologise here...I might have erred somewhere while setting up the condition records. Now I find it working per the business requirements.

So nice of you to share this thanks for taking time to explain. Thanks to Sadhu as well !!!

[Former Member]

HI Nikhil,

This can be achieved using the Material Listing / Exclusion Functionality.Use Tcode VB01.

Pl Reward if it helps.

Regards

Srini

[Former Member]

Thanks for the honours,

Yes there is a way by which you can sell specific set of materials to cTo create a material listing or exclusion record, proceed as follows:

Use T. Code VB01.

Here we can actually perform two things. Either out of 10 materials list 3 materials which can be sold for that customer or we can even say exclude selling materials that we do not want that customer to able to sell.

Enter a value in the List/excl.type.

The standard version of the SAP R/3 system includes two material listing/exclusion condtion types:

– A001 for material listing

– B001 for material exclusion

Press ENTER.

The Selection of Key Combination window appears. The standard version includes only one key combination:Customer/material.

Mark the Customer/material field and press ENTER.

You reach the screen where you create the master data.

Enter a customer, validity period, and the materials that you want to list or exclude.

customers, by way of Listing/ Exclusion.

Hope I met your requirement. Pl. reward points suitably.

Thanks & Regards

Sadhu Kishore

[Former Member]

Hi Kishore - That certainly helped but I only see A001 condition type in our set up and that is customer material listing by sales division and brand code. So am not sure if I would have to set up a new customized condition type.

[Former Member]

Hi,

would not require to setup a new condition type anyway.However you do so if you want by using normal condition technique.

The basic idea in your system is that they have situations where they want to list materials. So only one condition type. But incase you need to use exclusion create a new one.

Hope it helps

Thanks & Regards

Sadhu Kishore