Study guide

9.5 Material Determination, Material Listing, and Material Exclusion

SAP S/4HANA Sales C_TS462

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: SAP S/4HANA Sales Overview and Enterprise Structure

1.1 SAP Business Suite, SAP S/4HANA Sales, Deployment Options, and User Interfaces 1.2 Sales Organization, Distribution Channel, Division, and Sales Area Architecture 1.3 Sales Office, Sales Group, Plant, Storage Location, and Shipping Point Assignments 1.4 Cross-Company and Multi-Plant Sales Enterprise Setup & SD-FI Integration

2 Chapter 2: The Order-to-Cash Process and Sales Master Data

2.1 The Order-to-Cash Process: Sales Order, Shipping, Billing, and Finance Integration 2.2 Business Partner (BP) Approach, Customer Roles, and Partner Functions 2.3 Material Master / Product Master Sales Views, Tax Classifications, and Unit of Measure 2.4 Customer-Material Information Records (CMIR), Item Proposals, and Cross-Selling

3 Chapter 3: Sales Documents, Copying Control, Presales, and Outline Agreements

3.1 Sales Document Header Architecture and Customizing Sales Document Types 3.2 Special Functions in Sales Documents: Business Data, Blocks, and Reasons for Rejection 3.3 Copying Control and Document Flow Between Sales Documents 3.4 Pre-Sales Processing: Inquiries, Quotations, and Document Validity 3.5 Outline Agreements: Scheduling Agreements, Quantity Contracts, and Release Orders 3.6 Value Contracts: Releases, Partner Authorization, Contract Data, and Billing 3.7 Special Business Processes: Consignment, Rush Orders, Cash Sales, and Free-of-Charge Deliveries

4 Chapter 4: Item Categories, Schedule Line Categories, and Sales BOMs

4.1 Item Category Customizing Controls and Item Category Determination Logic 4.2 Schedule Line Categories and Determination Mechanics 4.3 Bill of Materials (BOM) Explosion in Sales Orders

5 Chapter 5: Pricing and the Condition Technique

5.1 Condition Technique Architecture: Field Catalogs, Tables, and Access Sequences 5.2 Condition Types, Calculation Types, Scales, and Condition Classes 5.3 Pricing Procedure Determination and Calculation Schema Configuration 5.4 Working with Condition Records: Maintenance Tools, Price Lists, Pricing Reports, and Manage Prices 5.5 Special Pricing Functions: Condition Exclusion, Group Conditions, Header Conditions, Condition Update, and Supplements 5.6 Special Condition Types: Manual Net Pricing, Minimum Values, Customer Hierarchy, Pallet Discounts, and Rounding 5.7 Statistical Condition Types and Tax Determination 5.8 Condition Contract Management: Contracts, Business Volume, Accruals, and Settlement

6 Chapter 6: Availability Check (ATP) and Delivery Scheduling

6.1 Availability Check Fundamentals: Checking Groups, Checking Rules, and Scope of Check 6.2 Delivery Scheduling & Routing: Transit Time, Loading Time, and Pick/Pack Time Calculations 6.3 Advanced ATP (aATP), Backorder Processing (BOP), and Transfer of Requirements

7 Chapter 7: Delivery Processing and Embedded EWM

7.1 Delivery Documents and Organizational Units for Delivery Processing, Including EWM 7.2 Shipping Point Determination and Route Determination Mechanics 7.3 Outbound Delivery Creation, Delivery Document Types, and Delivery Item Categories 7.4 Warehouse Execution: Picking, Packing, and Post Goods Issue (PGI) 7.5 Picking and Goods Issue with Embedded EWM 7.6 Inbound Deliveries with EWM and Special Functions in Deliveries

8 Chapter 8: Billing and Integration with Financial Accounting

8.1 Billing Document Types, Categories, and Billing Due List Processing 8.2 Order-Related vs. Delivery-Related Billing, Invoice Splits, and Collective Invoicing 8.3 Credit and Debit Memos, Down Payments, and Invoice Cancellation Workflows 8.4 Special Types of Settlement: Invoice Lists, External Billing Document Requests, and Preliminary Billing Documents 8.5 Billing Plans, Down Payment Agreements, and Installment Payments 8.6 Revenue Account Determination and FI-SD General Ledger Integration 8.7 The Interface Between Sales and Financial Accounting, Billing Output, and Technical Options

9 Chapter 9: Basic Functions: Partners, Incompletion, Texts, Material Determination, and Output

9.1 Partner Determination Procedures and Account Group Linkage 9.2 Incompletion Procedures, Status Groups, and Log Configuration 9.3 Text Control I: Text Objects, Text Types, Text Determination Procedures, and Manual Text Entry 9.4 Text Control II: Automatic Text Transfer, Text Determination Analysis, and Special Features 9.5 Material Determination, Material Listing, and Material Exclusion 9.6 Output Management: Modern BRFplus Architecture and Migration from Classical NAST 9.7 Output Parameter Determination with Decision Tables

10 Chapter 10: SAP Fiori, Sales Analytics, RISE with SAP, and Clean Core

10.1 SAP Fiori Sales Apps, Smart Business Monitoring, and Embedded Analytics 10.2 Working with the SAP Fiori Launchpad: My Home, Spaces and Pages, Help, Joule, Responsibilities, Situations, and Workflows 10.3 RISE with SAP Methodology: Standardized Framework, Transformation Preparation Service, Toolchain, Expert Guidance, and Dashboard 10.4 Clean Core: Definition, Benefits, the Five Principles, and Clean Core Levels

11 Chapter 11: Implementing SAP S/4HANA Cloud Private Edition

11.1 SAP S/4HANA Cloud Private Edition: Characteristics, Transition Paths, and the Implementation Team 11.2 System Landscapes, System Provisioning, and Release Upgrades 11.3 Setting Up the Project in SAP Cloud ALM and Preparing a System Conversion 11.4 Identity and Access Management: Users, Business Roles, Catalogs, Spaces, and Pages 11.5 Fit-to-Standard Workshops, Design Workshops, and Business Process Configuration 11.6 Extensibility in SAP S/4HANA Cloud Private Edition: Key User, Developer, and Side-by-Side 11.7 Integration: ISA-M, SAP Integration Suite, Prepackaged Content, and Monitoring 11.8 Data Migration with the SAP S/4HANA Migration Cockpit and Testing in SAP Cloud ALM

9.5 Material Determination, Material Listing, and Material Exclusion

Key Takeaways Explain This Topic AI

Material Determination leverages the Condition Technique (transaction VB11) to automatically substitute materials for product obsolescence, packaging changes, or customer GTIN/EAN conversion.

The substitution reason controls whether the material entered or the substitute is printed, whether a warning appears, the strategy (automatic replacement, manual selection, or ATP-based selection), and whether the substitute replaces the item or becomes a sub-item.

Material Listing acts as an exclusive positive catalog, restricting customers to authorized materials, whereas Material Exclusion functions as a negative blacklist barring specific products.

When both Listing and Exclusion procedures are assigned to a sales document type, Material Exclusion takes absolute precedence over Material Listing.

Free goods distinguish inclusive bonus quantities (part of the ordered quantity becomes a free sub-item) from exclusive bonus quantities (free goods added on top as a sub-item); the free sub-item gets TANN.

Last updated: October 2026

Material Determination, Material Listing, and Material Exclusion

In dynamic commercial environments, the products ordered by a customer do not always align perfectly with the materials shipped by the warehouse. A consumer electronics manufacturer phases out an older television model in favor of a newer generation; a customer places an order using a European Article Number (EAN/GTIN) rather than an internal SAP material code; or a regulatory restriction prohibits hazardous chemical shipments to specific geographic zones.

SAP S/4HANA provides three foundational Basic Functions driven by the Condition Technique to govern these operational requirements:

Material Determination ( VB11 ) : Automated or dialog-driven substitution of products.

Material Listing and Material Exclusion ( VB01 ) : Positive product catalogs and negative blacklists.

Free Goods ( VBN1 ) : Commercial trade promotions providing inclusive or exclusive bonus quantities.

Material Determination Architecture (Transaction VB11 / VB12)

Material Determination enables the automated exchange of an entered material for an alternative substitute material during sales document processing. Like pricing, it is built upon the Condition Technique : Condition Technique Architecture

  • │
  • ┌─────────────────────────────────┼─────────────────────────────────┐
  • ▼ ▼ ▼
  • Field Catalog Condition Table Access Sequence
  • (allowed fields (Table 001 - Mat Entered) (Sequence A001)
  • │ │ │
  • └─────────────────────────────────┼─────────────────────────────────┘
  • ▼
  • Condition Type
  • (Standard: A001)
  • │
  • ▼
  • Material Determination Procedure
  • (Standard: A00001)
  • │ Assigned to VOV8
  • ▼
  • Sales Document Type (OR)
  • Primary Business Use Cases

Product Life Cycle & Supersession : Material M-100 reaches end-of-life and is automatically substituted by next-generation product M-200 .

Promotional Packaging : Replaces individual retail units with bundled promotional gift packs during seasonal sales.

Customer Barcode / EAN / GTIN Translation : Allows external buyer EDI orders containing international GTINs to map seamlessly to internal materials.

Plant or Packaging Variations : Automatically substitutes products based on customer delivery preferences.

Master Record Maintenance (Transaction VB11)

When creating a material determination condition record ( VB11 ), the user maintains:

Input Material : The material number entered by the order processor or sent via EDI.

Substitute Material(s) : One or more target replacement materials.

Validity Period : Effective start and end dates.

Substitution Reason : Controls how the substitution behaves.

Substitution Reasons and Line Item Outcomes (Table TVSU)

The substitution reason in the condition record decides how the substitution behaves in VA01 . It is defined in Customizing (table TVSU ) with these settings:

Entry : whether the material entered or the substitute material is printed on outputs.

Warning : whether the user receives a warning that the material is substituted.

Strategy : blank means the entered material is replaced automatically; A displays the substitutes for manual selection ; B selects automatically based on the availability check (ATP-based substitution).

Outcome : blank means the substitute replaces the entered material in the item; A keeps the entered material as the main item and adds the substitute as a sub-item .

Outcome Behavior in the Sales Order Consequence

Blank (Replace item) The substitute becomes the item's material ( VBAP-MATNR ); the original is kept in VBAP-MATWA (material entered) Pricing, ATP, delivery, and billing use the substitute

A (Sub-item) The entered material stays as the main item; the substitute is added as a sub-item The sub-item gets its own item category through the higher-level item category; delivery and billing use the sub-item

Note

With the sub-item outcome, the documents show both the material the customer ordered and the substitute that was shipped, which helps customers reconcile their purchase orders.

Material Listing vs. Material Exclusion (Transaction VB01 / VB02)

Assortment control allows an enterprise to control exactly which products a customer is permitted or forbidden to purchase: ┌────────────────────────────────┐ ┌────────────────────────────────┐

  • │ Material Listing (VB01) │ │ Material Exclusion (VB01) │
  • │ "Positive List" │ │ "Negative List" │
  • │ • Customer can ONLY buy items │ │ • Customer CANNOT buy items │
  • │ present on the list. │ │ present on the list. │
  • │ • Condition Type: A001 │ │ • Condition Type: B001 │
  • └────────────────┬───────────────┘ └────────────────┬───────────────┘
  • │ │
  • └──────────────────┬───────────────────┘
  • ▼
  • ┌───────────────────────────────────────────────────────────────────────┐
  • │ PRECEDENCE RULE │
  • │ Material Exclusion ALWAYS takes absolute precedence over Listing! │
  • │ If a material is on both lists, order entry is strictly BLOCKED. │
  • └───────────────────────────────────────────────────────────────────────┘
  • Material Listing (Positive Assortment List)

Business Concept : The customer is legally or commercially restricted to purchasing only materials explicitly listed in their master record.

Transactional Effect : If a sales representative attempts to enter an unlisted material, the system issues a hard error message: "Material X is not listed for customer Y and cannot be sold." Order entry is terminated for that line.

Condition Customizing : Standard listing condition type A001 with procedure A00001 .

Typical Application : High-end luxury retail agreements (where boutique stores are only authorized to carry specific product lines) or medical supplies distribution.

Material Exclusion (Negative Blacklist)

Business Concept : The customer is prohibited from purchasing specific materials.

Transactional Effect : If an excluded material is entered, the system issues a hard error message: "Material X is excluded for customer Y."

Condition Customizing : Standard exclusion condition type B001 with procedure B00001 .

Typical Application : Environmental/chemical compliance (barring hazardous substances from customers lacking valid storage permits) or market territorial exclusivity.

Assignment and Precedence in Sales Documents

Listing and Exclusion procedures are assigned directly to the Sales Document Type in transaction VOV8 :

  • Field Listing Procedure : e.g. A00001
  • Field Exclusion Procedure : e.g. B00001

Important

The Absolute Precedence Rule : When both listing and exclusion procedures are active on a sales document type, Material Exclusion always overrides Material Listing . If material MAT-A is maintained on the customer's active listing (positive list) but is also entered in their exclusion record (negative list), the system strictly rejects the order line item.

Free Goods Processing (Transaction VBN1 / VBN2)

Free Goods represent commercial trade bonuses where free merchandise is granted to a customer upon reaching a qualifying purchase threshold. Free goods are powered by the Condition Technique using condition type NA00 and procedure NA0001 .

  • Inclusive Bonus vs. Exclusive Bonus Customer Orders 10 Units
  • │
  • ┌───────────────────────┴───────────────────────┐
  • ▼ ▼
  • INCLUSIVE BONUS (Pay for 9) EXCLUSIVE BONUS (Get 1 Free)
  • │ │
  • 10 Units Delivered Total 11 Units Delivered Total
  • │ │
  • Main Item: 9 Units (TAN, charged) Main Item: 10 Units of Material A (TAN)
  • Sub-Item: 1 Unit (TANN, free) Sub-Item: 1 Unit of Material B (TANN)
  • Billed for: 9 Units Billed for: 10 Units of Material A
  • 1. Inclusive Bonus ("Buy 10, Pay for 9")

Mechanics : The free quantity is part of the ordered quantity .

Example from the official course : The customer orders 100 pieces of M1 and 10 of them are free. The system reduces the main item to 90 pieces (charged) and adds a free-of-charge sub-item for 10 pieces with the main item as higher-level item.

System Implementation : Main item TAN for the charged quantity, sub-item TANN (usage FREE ) for the free quantity.

2. Exclusive Bonus ("Buy 100, Get 10 Free")

Mechanics : The free quantity is delivered in addition to the ordered quantity.

Example from the official course : The customer orders 100 pieces of M1 and receives 10 additional pieces free of charge. The main item stays at 100 pieces (charged), and a sub-item for 10 free pieces is added. The free goods can be the same product or a different product.

System Implementation : Main item TAN , free sub-item TANN .

Sub-Item Category Determination for Free Goods

When an exclusive free-goods sub-item is generated, the system determines its item category via transaction VOV4 : Sales Doc Type (OR) + Item Cat Group (NORM) + Usage (FREE) + Higher-Level Cat (TAN) = Item Category TANN \text{Sales Doc Type (OR)} + \text{Item Cat Group (NORM)} + \text{Usage (FREE)} + \text{Higher-Level Cat (TAN)} = \text{Item Category TANN} Sales Doc Type (OR) + Item Cat Group (NORM) + Usage (FREE) + Higher-Level Cat (TAN) = Item Category TANN

Item Category TANN Characteristics :

Pricing: Active, but evaluates condition type R100 (100% free-goods discount), yielding a net financial value of $0.00.

Billing: The free goods item is copied into the billing document as an item free of charge (zero net value).

Logistics Relevance: Fully relevant for delivery creation , warehouse picking , and Post Goods Issue (PGI) to update inventory valuation and COGS.

Comparison of Assortment & Substitution Basic Functions

Function Transaction Condition Type Primary Objective Failure Outcome

Material Determination VB11 A001 Exchange entered material for substitute product Material replaced silently or selection dialog opened

Material Listing VB01 A001 Enforce positive list of authorized products Order line rejected with hard error if not listed

Material Exclusion VB01 B001 Enforce negative list of forbidden products Order line rejected with hard error if excluded

Free Goods VBN1 NA00 Provide promotional bonus quantities Standard pricing applied without bonus

Loading diagram... Material Assortment, Determination, and Free Goods Decision Tree