Sana Commerce 9.3
Your connector

Material Exclusion


Applies to: Sana 9.3.3 and higher.

There are two features in SAP using which you can manage your catalog in the best way and offer your customers only the products which appeal to them. These features are: Sana feature called Customer Assortment and standard SAP feature called Material Exclusion.

Using customer assortment in SAP you can specify which products (materials) or products assigned to a product hierarchy should be shown to or hidden from the individual customers or customers within a customer account group.

Using material exclusion in SAP, you can create a list of materials that will be restricted for specific customers for a certain period. This means, that these customers will not see these materials in the Sana webstore and thus will not be able to buy them.

You can use either Sana "Customer Assortment" or the standard SAP feature "Material Exclusion", depending on which feature suits your needs best.

Enable material exclusion

To exclude materials from the Sana webstore, you should enable material exclusion in SAP and select the necessary customer assortment mode in Sana Admin. 

Step 1: Open the Webstore Optimization window. You can access Webstore Optimization from the main window of the Sana Commerce solution (/n/sanaecom/webstore), or by calling the transaction /n/sanaecom/optimize.

Expand Product Optimizations and select the Standard Material Exclusion option to enable material exclusion. In case you are using customer assortment to manage the catalog, select the SANA Customer Assortment.

Step 2: Open Sana Admin and click: Setup > Products > Stock and assortment. For the correct functioning of material exclusion in the Sana webstore select the Additional customer assortment mode.

For more information, see "Customer Assortment".

Create material exclusion

To manage material exclusion, use the following transaction codes:

  • Create Material Listing/Exclusion (VB01)
  • Change Material Listing/Exclusion (VB02)
  • Display Material Listing/Exclusion (VB03)

Material Listing is not available in Sana 9.3.3, only Material Exclusion is supported.

Step 1: To create material exclusion use the VB01 transaction code. Select B001 (Exclusion) condition type in the List/excl.type field and click Enter.

Step 2: In the Key Combination window select the necessary combination.

You can create the list of excluded materials using the following combinations:

  • Customer/Material
  • Customer Group/Material
  • Customer/Product Hierarchy

Other combinations are not supported by Sana.

Step 3: In the Create Exclusion window select a customer or a customer group, depending on the combination you selected, and specify a validity period during which materials will not be available for a customer or a customer group in the Sana webstore. When the material exclusion you created expires, the materials will be shown to this customer or customer group in the webstore after updating the product index in Sana.

Create the list of materials or product hierarchies you want to exclude.

Step 4: When the material exclusion is created in SAP, you need to rebuild index for the Product import task in Sana Admin. Open Sana Admin and click: Tools > Scheduled tasks. Once the product index is rebuilt, the materials from the list of exclusion will not be shown in the Sana webstore.