Material Listing And Exclusion In Sap

Material Listing And Exclusion In Sap

In SAP, the process of excluding materials is set up in the same location as material listing. However, for this tutorial, we will focus solely on the functionality of material exclusion. To configure material exclusion, follow the customizing path provided below within transaction code SPRO.

Sales and Distribution – Basic Functions – Listing/Exclusion is a feature in SAP that allows for the management of materials. This functionality enables businesses to control which materials are included or excluded from various processes, such as sales orders and deliveries. By utilizing this feature, companies can ensure that only relevant materials are considered during these operations, thereby streamlining their business processes and improving overall efficiency.

Choose the initial task from the inventory: Enable material listing or exclusion based on sales document type.

Allocate the appropriate sales document types to the standard material exclusion process B00001 as demonstrated below.

What is the Tcode for managing material inclusion and exclusion in SAP?

After selecting the exclusion type, you need to click on “Key combination” which allows you to choose both the material and customer that are involved in this exclusion process. Once selected, click on the save icon present on your screen.

By doing so, a confirmation message will appear indicating that your changes have been successfully saved. This means that any materials or customers listed under this exclusion type (B001) will not be allowed or included for certain activities within SAP system.

SAP Material Exclusion Execution

In order to demonstrate the exclusion of a material in SAP, it is necessary to establish a master record for the exclusion with the appropriate validity dates. Once this is done, the sales order can be generated and a validation process will be initiated. The subsequent sections will guide you through these procedures.

You might be interested:  Exclusive Opportunities for SAP ABAP Developers in Canada

Sap Material Exclusion Master Record Creation

– Location in SAP: Go to Logistics > Sales and Distribution > Master Data > Products > Listing/Exclusion, then select Create.

– Transaction code: Use VB01 to create a listing or exclusion.

On the initial screen of transaction code VB01, input the listing type B001 – Exclusion as displayed below.

To create the master record for excluding materials, simply press the Enter key. Input the required details as mentioned below.

Material Exclusion Sales Order Creation in SAP

To generate a sales order, access transaction code VA01. Input one of the designated sales order types that have been assigned with the material exclusion during the configuration process. In our given scenario, we will utilize order type ZDEM as depicted below:

Once all data is entered, hit Enter to trigger the validation of the document. Since the entered materials are not part of the material exclusion, the system accepts them with no error message:

In order to proceed with the sales order, it is necessary to eliminate the material that has been excluded. Press Enter and then Save to finalize and post the sales order.

If you found this tutorial helpful, we would greatly appreciate your feedback. Please leave any questions or comments in the section below. Your input is valuable to us and will assist us in improving our free SAP SD tutorials for your benefit.

Is it possible to enable both material inclusion and exclusion for a customer?

In standard SAP, if you have maintained the same material for both listing and exclusion purposes, only the exclusion will be considered. In such cases, you need to access transaction VB02 and remove the material/items from the exclusion list. By doing so, the item will then be determined in the sales order during creation.

You might be interested:  Step-by-Step Guide: Creating a Cost Center in SAP

When using SAP, it is important to understand that if a material is set as both listed and excluded simultaneously, only its exclusion status will take effect. This means that even though you may have intended for the material to be listed in certain scenarios, it will not appear in those situations unless it is removed from the exclusion list.

What does exclusion material mean?

The following is a list of forbidden materials:

1. Explosive substances

2. Hazardous chemicals

3. Pathological waste

4. Noxious substances

5. Illegal items

6. Dangerous materials

What is the T code for SAP material list checking?

In SAP, the MM60 transaction code allows users to generate a materials list based on various filter criteria such as plant location and whether the materials are valuated or non-valuated. By executing this report, users can obtain a comprehensive overview of the materials stored in their system.

Additionally, the MM50 transaction code enables users to extend material views. This means that they can add new fields or attributes to existing material master data for further customization and flexibility.

Another useful transaction code is MM17, which stands for Mass Maintenance: Materials. With this functionality, users can perform mass updates or changes to multiple materials at once instead of making individual modifications for each material separately.

Overall, these transactions provide efficient ways for managing and organizing material-related information in SAP systems. They help streamline processes by allowing bulk operations and providing customizable options for viewing and maintaining materials data.


1. MM60 – Materials List generation with filter criteria.

2. MM50 – Extending Material Views for additional customization.

3. MM17 – Performing mass maintenance tasks on multiple materials simultaneously

Removing material exclusion in SAP: How can it be done?

To remove a selected material record from the exclusion condition record in SAP, you can utilize transaction code VB02. This is applicable when the order type being used has activated the Material Exclusion procedure. By accessing VB02, you will be able to modify or delete the specific material record that needs to be removed from the exclusion list.

You might be interested:  The meaning of SAP in strategic management

Alternatively, if you wish to completely remove the assignment of Material Exclusion procedure with your order type, you can use transaction code OV04. This allows for removing the association between a particular order type and the Material Exclusion procedure.

What does exclusion indicator mean in SAP?

August 30, 2011. No Likes. The exclusion indicator in SAP plays a crucial role in determining the search for a condition record when it is used in a document such as a purchase order (PO). Essentially, when a condition is marked with an exclusion key, the system will not continue searching for the condition record once it has been found in the relevant table.

When working with materials and listings in SAP, it becomes essential to understand how this exclusion indicator functions. It allows users to prioritize specific conditions or exclude others based on their requirements or business rules. By utilizing this functionality effectively, organizations can enhance efficiency and accuracy in their procurement processes.

Listing materials in SAP: What is the process?

To retrieve a list of materials in SAP, you can follow these steps. Firstly, go to the SE16 transaction code and enter the MARA table. In this table, you can filter the results by material type, created by, and created on criteria. This will provide you with a list of materials based on your specified filters.

Alternatively, you can use the MM60 transaction code to access another method for retrieving a list of materials. By entering this transaction code, you will be able to generate a comprehensive list of materials without having to specify any additional filters.

1. Use SE16 transaction code and enter MARA table.

2. Filter results based on material type, created by, and created on criteria.

3. Alternatively, use MM60 transaction code for a complete list of materials.