1. SAP Glossary
  2. Upgrade - General
  3. substitution table


What is 'substitution table' in SAP BC-UPG - Upgrade - General?


substitution table - Overview

  • Component: BC-UPG

  • Component Name: Upgrade - General

  • Description: A table that is replaced in the database with a new version during a repository switch upgrade. The substitution tables include most of the R/3 Repository.


substitution table - Details


  • Key Concepts: A substitution table is a feature of the SAP system that allows users to define a set of values that can be used to replace other values in the system. This is useful for tasks such as data cleansing, where users can define a set of values that should be replaced with a single value. For example, if a user wants to replace all instances of “ABC” with “XYZ”, they can create a substitution table to do so.
    How to use it: Substitution tables are created in the SAP system using the transaction code SM30. Once created, they can be used in various transactions and programs. For example, when creating a new material master record, users can select the substitution table they want to use from the drop-down list. The system will then automatically replace any values that match those in the substitution table with the new value.
    Tips & Tricks: When creating a substitution table, it is important to ensure that all of the values are correctly entered. If any of the values are incorrect, it could lead to incorrect data being entered into the system. It is also important to ensure that all of the values are unique; if two or more values are identical, then only one of them will be replaced.
    Related Information: Substitution tables are part of the

    Already have an account? Login here!





substitution table - Related SAP Terms

Rating
ERPlingo's SAP support assistant is amazing. Saves me countless hours trying to solve complex SAP issues myself. It's a real game changer!
Rate 1
Thomas Michael
SAP Consultant, Author & Speaker