Definitions:
Material Listing and Exclusion are used in the business scenarios where the business want to limit specific customers to order some specific materials due to some business reasons.
Material Listing: A Material Listing is created for a Customer. The Customer can only buy the Material contained in the list. The system does not allow any Material to be entered if they are not contained in the Material Listing.
Material Exclusion: A Material Exclusion is created for a Customer. The Customer cannot buy the Material contained in the list. It excludes the material from buying for the customer. The system will not allow the material to enter that are in the Material Exclusion List.
Material Listing and Exclusion uses Condition Techniques to List / Exclude Material for specific Customers.
Configuration Path: SPRO>Sales and Distribution>Basic Functions>Listing/Exclusion.
Configuration Nods:
- Activate Listing/Exclusion by Sales Document Type
- Procedures for Maintaining Listing/Exclusion
- Maintain Listing/Exclusion Types
- Optimize Accesses
- Maintain Access Sequences for Listing/Exclusion
- Maintain Allowed Fields for Listing/Exclusion
- Maintain Condition Tables for Listing/Exclusion
Configuration Steps:
Activate Listing/Exclusion by Sales Document Type

Maintain Condition Tables for Listing/Exclusion

Maintain Access Sequences for Listing/Exclusion


Maintain Listing/Exclusion Types

Procedures for Maintaining Listing/Exclusion



Maintain Condition Record
T-Code=
VB01
Material Listing Condition Record.


Material Exclusion Condition Record



Sales Order Behavior:
Material Exclusion Sales Order
T-Code=
VA01
Note: Material Listed in material exclusion conditions are
Customer:
INCBAN0102
Material exclusion List:
1.
M0001
2.M0002
When we create sales order and use the customer and try to input the exclusion listed materials, the system will not allow to proceed the order and will show error messages “Material has been excluded”.

Material Listing Sales Order
T-Code=
VA01
Note: Material Listed in material listing conditions are
Customer:
INCBAN0102
Material exclusion List:
1.
M0003
2.
M0004
3.
M0005
When we create sales order and try to input material outside the material listed in the listing condition records the system will show message” Material is not listed and therefore not allowed”
As you can see material M0003 & M0004 are in the Material Listing Condition Record but material M0008 are not in the Material Listing Condition Record so in sales order it’s not allowing to use it and shows the error message.

Tables:
- G000
- KOTG001
- KOTG002
- KOTG003
- KOTG004
Conclusion:
Material Listing / Exclusion is a key feature provided by SAP SD that allows the sale of materials to allowed / disallowed Customer in different business scenarios and this blog post contains the step by step configuration of Material Listing / Exclusion Configuration in SAP S/4HANA system.
Next Post will be on Material Determination in S/4HANA.
Hope this blog will be useful To all and if you like the post please share your feedback and comments.
Regards
Surajit Biswas