In some cases, Company wants to provide a material to a specific customer which is not provided to other customers or want to restrict a material for any specific customer. This can be achieved by a technique called “Listing and Exclusions” in SAP ECC.

The purpose of Listing and Exclusions is to create a material list for a specific customer such that only those materials which are maintained in Listing list can buy by a specific customer, this is called as “Listing” and you can also maintain an exclusion list such that a specific customer cannot buy those materials which are maintained in exclusion list, this is called “Exclusions”.

For e.g. in some situations, certain restrictions occurs at company level prevents from shipping certain products to some areas. So, there is a need to restrict those certain products to the customers resided in those particular areas. This restriction can be done by “Exclusion technique”.


Some of our top blog posts

Setups to create Material Listing Master Records

  • You can maintain material listing/exclusion condition records for a customer.

Screenshot of material listing exclusion condition records

  • Enter the tcode VB01 or by following menu path Logistics ➢ Sales and Distribution ➢ Master Data ➢ Products ➢ Listing/Exclusion ➢
  • Standard SAP defines A001 for material listing and B001 for material exclusion. You can define your own type by customizing the same within SAP. For the purpose of this article we will be using the standard SAP listing and exclusion types.

Screenshot of Create Page


  • Select the List/excl.type
  • In the example exclusion type (B001) is selected.

Screenshot of exclusion

  • Maintain the condition records for the customers.
  • In the example, for customer 1000 material 100-100 is excluded. 1000 customer will not able to buy this product.
  • Click on save button it will display message “condition records saved”

Screenshot of condition records

  • Enter the tcode VA01 for placing the order.
  • Enter the fields like Sold-to-party and ship-to-party & material number.
  • In the example, 1000 is the customer number and 100-100 is the product.

Screenshot of Order Display page

  • Press enter It will display the message as “Material 100-100 has been excluded” which is shown above fig.


  • Select the List/excl.type
  • In the example listing type (A001) is selected.

Screenshot of listing page

  • The listing can maintain in two ways which are shown in below fig.
  • We can list the products with respect to the sales area and we can list the materials for the customer.

Screenshot of listing types

  • We can maintain specific to sales area, Distribution channel and Sales area.
  • In the example, for 1000 customer material 100-100 is listed in sales area 1000, distribution channel 10 and division 00.

Screenshot of material and customer


  • We can maintain the listing with respect to material and customer.
  • In the example, 100-100 material is listed for customer 1000.

Screenshot of material and customer

  • Customer will able to buy the listed products.

Screenshot Order Create

  • For 100-100 material is listed for customer 1000. So the customer will able to buy this product successfully.

Screenshot of Order successfull

In this way we can restrict the customers to buy the products and We can trade the certain products with specific customers.

 Benefits of Material Listing & Exclusion in SAP

  1. Listing and Exclusion can be applied to specific customers but not for all the customers.
  2. While placing an order if the customer tries to order the material which is maintained in exclusion list then a message “material has been excluded” is shown.
  3. The customer can order only those materials which are maintained in material list.