Material Listing and Exclusion Functionality

Explain how the Material Listing / Exclusion works in SAP.

Material listing and exclusion lets you control which materials specific customers may or may not buy. For example, if you create a material listing for a specific customer, the customer can only order products from that list. You can also create a master record for material exclusion for a particular customer. Then the customer cannot order excluded materials from you. 

That means if you produce 100 materials and you wish to sell him only 60 materials, this is done by material listing. If you want to use exclusion, it does not allow the customer to have the products which are kept in exclusion list.

Material listing/exclusion is controlled with the condition technique. 

By default, the system takes exclusion first and listing then.

Configuration procedures:

It is used in the sales order to list the products or services specific customers may or may not purchase. For example, you may list products that a specific customer may not buy or conversely you may list only the products that the customer can select. Mat. Listing and exclusion uses the condition technique to determine its values and procedures.

IMG Menu Path : SPRO -> Sales & Distribution -> Basic Functions -> Listing/Exclusion

1. Put the fields you will need into the field catalogue.
2. Create the condition tables you need.
3. Create the access seq. 
4. Assign the condition tables to the acc. seq.
5. Create the condition types.
6. Assign the acc seq. to the condition types.
7. create the determination procedure and assign condition types.
8. Assign the determination procedure.
9. Create condition records VB01.

Functionality:

Sales and Distribution -> Master data -> Products -> Listing/Exclusion> Create 

Tcode for entering Listing / Exclusion:

1. VB01 to create,
2. VB02 to change and
3. VB03 to display.

Enter the list/exclusion type B001: For the required 

Create the order and enter material excluded to test exclusion. 

See Also
How To Use Condition Exclusion Type In SO

Get help for your SAP SD problems
SAP SD Forums - Do you have a SAP SD Question?

SAP Sales and Distribution Books
SAP SD Books  - Certification, Interview Questions and Configuration

Delivery Hints
SAP Logistics Execution

SAP Sales and Distribution Tips
SAP SD Discussion Forum and Sales/Distribution Tips

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.

SAP SD Tips