Material Listing and Exclusion in ERP SD

At times, Business tries to control the materials to be sold to customers and this can be achieved to Material Listing and Exclusion Functionality.

With material listing or exclusion, you can control which materials can be sold to each customer. Material listing lists which materials a customer can buy. Material exclusion lists which materials a customer cannot buy.

During sales order processing system perform listing and exclusion as an initial check as soon as material is keyed in and if material listing/exclusion functionality is not active then system considers all the materials entered but however if listing/exclusion functionality is active, the system will allow creating orders for the materials that are listed.

Listing/ Exclusion as well follows condition technique in order to filter materials list.

Below are the process steps need to be followed.

1. Maintain condition tables for listing/exclusion

2. Maintain access sequences for listing/exclusion

3. Maintain listing/exclusion types

4. Procedures for maintaining listing/exclusion

5. Activate listing/exclusion by sales document type

Maintain condition tables for listing/exclusion

Ideally, the Standard system has provided condition tables which we can make use but however, if standard tables don't suffice the requirement then we will proceed with the customer table creation which ranges between 501-999.

Listing and Exclusion tables will be stored in database tables with prefix KOTG<Condition Table>.

Maintain access sequences for listing/exclusion