Tag Archives: value ranges

  • Beginners Guide To ABAP – Module 2 – Data Dictionary – Create A Table Part 2

    This is a continuation of the previous video here: Create A SAP Table Part 1. Watch that video first.

    Value Ranges

    Next we will take a quick peep at the Value range tab. Now this tab is all about setting valid value ranges for the domain that you are creating. If you set a value range and the user enters a value in a field outside the valid value range that you set up, they will be shown an error message and be requested to enter a valid entry.

    Create A Sap Table - Part 2There are three options to choose from when creating value ranges.

    1. The first is ‘Single Values – This is where you actually enter a list of individual valid values that a user can enter.
    2. The next is ‘Intervals’ – If you have many values but they are all related or in a sequence you can enter the lower limit and the upper limit for each range. For example, a lower limit of 1, an upper limit of 9, and that saves you entering 9 individual single values. This ensures a user can only enter a value that falls within the ranges that you specify.
    3. The last option you have is ‘Value table’ – When you have a large number of possible entries it is quite common to use a Value Table instead of a value range or list of single values. With a value table, you specify a complete valid value table entry list. But please note that if you use this option you must also introduce Foreign Keys to your table to ensure the user’s entries are tested against the values stored in the value table that you create.