cancel
Showing results for 
Search instead for 
Did you mean: 

Listing of Customer against Material

Former Member
0 Kudos

Hi,

Is it possible to list customer against material, i.e. a particular material should be sold to only a particular customer or group of customer.

Std listing and exclusion functionality is not fulfilling my requirement.

ex. Material "MAT01" should be sold to only Customer "A", system should not process sales order if user sales MATNR to other customers.

Customer "A" can purchase other materials also  so we can do listing of material or exclusion.

How can we map this requirement?

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

By very simple ABAP coding, you can put your logic in program mv45afzz in exit save_document_prepare. I don't think it will take more than 5 minutes.

Former Member
0 Kudos

Hi DB49,

Yes what you are saying is for allocation of material (stock in quantity) for customer, In my case its not about stock.

My client has few products which can be sold to a customer or a group of customers.

system should not create sales order for other customers in the same way as system behave for Listing and Exclusion.

Former Member
0 Kudos

Tanveer,

Allocation is unrelated to stock; it is related to confirmations of sales orders.  However, if, as you say, you wish to prevent the order for this material from being created, rather than prevent the the order from being sold, as you stated previously, then allocation is not suitable.

Best Regards,

DB49

Former Member
0 Kudos

Thank you for inputs.

Venu: Please explain how exclusion will fulfill my requirement. In exclusion I need to list materials which are excluded for customer. In my case customer can purchase any product.

reuirement is to list customer against material and in std we list or exclude material against customer.

DB49:  what you are suggesting is about availability check with product allocation. But my requirement is to list customer against material.

If I am failing to explain my requirement please let me know...

Former Member
0 Kudos

Tanveer,

But my requirement is to list customer against material.

Uh, "Customer list" is an SAP solution, not a requirement.  As I see it, the stated requirements (so far) are:

...Std listing and exclusion functionality is not fulfilling my requirement.

ex. Material "MAT01" should be sold to only Customer "A", system should not process sales order if user sales MATNR to other customers.

Customer "A" can purchase other materials...

and I would say these requirements are met by the Product Allocation solution.

Of course, you are free to use any solution you wish.

Good Luck & Best Regards,

DB49

moazzam_ali
Active Contributor
0 Kudos

Std listing and exclusion functionality is not fulfilling my requirement.

Tanveer

Why standard exclusion function not fulfilling the requirement? It can be achieved with std. Can you please explain your above statement.

Thanks

Former Member
0 Kudos

Tanveer,

Restricting sales of specific materials by customer is typically done through use of Product Allocation during the SD availability check.

Once this is configured, you can create allocations for customers, by part number, or other combination of criteria.  In your case, you could create allocation quantities of "999,999,999 per week for customer 'A'; and 0 per week for 'All other customers'".  If a customer enters an order, and he has no allocation, his order cannot be confirmed.

Product allocation is not trivial to set up, but an experienced SD person should not have difficulty.

SAP online help at

http://help.sap.com/erp2005_ehp_06/helpdata/EN/93/744d12546011d1a7020000e829fd11/frameset.htm

There is a simplified configuration doc at

http://scn.sap.com/docs/DOC-22686

More configuration found in the Generic SD Best practices doc at

http://help.sap.com/saap/sap_bp/BBLibrary/HTML/105_ERP606_EN_US.htm

Best Regards,

DB49

Former Member
0 Kudos

Dear in your case just use Exclusion for this customer with the combination

Then customer easily buy other products , i have one doubt why you are asking not to give exclusion