Material Number Ranges and Formatting

Introduction:

The material number in R/3 is technically defined as an eighteen byte, character field.The logic that formats material numbers is contained in a conversion exit and is controlled by configuration tables, number range objects and standard R/3 customer functions. This document first explains how material number ranges are defined and then details a few methods for enhancing the standard functionality.

Contents:

Material Numbers in R/3
Relevant OSS Notes
Material Number Range Object
Assigning Intervals to Material Types

Transaction MMNR
Configuration Tables
Table TNRGT Number Range Groups
Table T134 Material Type Master
Table NRIV Number Range Intervals

Controlling the Format

Transaction OMSL Material Number Format
Table TMCNV
Material Number Domain
Function Group OMCV
Function CONVERSION_EXIT_MATN1_INPUT
Function CONVERSION_EXIT_MATN1_OUTPUT

Custom Output Format Example 1

Business Requirement
Solution
Step 1 Define the Edit Mask via TMCNV Configuration
Step 2 Test the Configuration Change

Custom Output Format Example

Business Requirement
Solution
Step 1 Identify the Standard Customer Function
Step 2 Create the Customer Function INCLUDE
Step 3 Code the Logic
Step 4 Find the Standard Enhancement (SMOD)
Step 5 Create a Project (CMOD)
Step 6 Assign the Enhancement to the Project
Step 7 Activate the Project
Step 8 Test the New Logic

Download Material Number Ranges and Formatting

Leave a Comment