Data Insight User Guides
Number Range – End-to-End Step-by-Step User Guide
This locked guide explains how to use the DDR Number Range utility to check, simulate, and apply number range status adjustments before a controlled SAP data refresh. It helps protect non-production systems from duplicate document numbers, exhausted intervals, posting errors, and inconsistent test execution after replicated data has been loaded.
Purpose of the Number Range Utility
SAP number ranges are used to generate unique identifiers for documents and business objects. Accounting documents, purchase orders, sales orders, material documents, customer records, vendor records, and many custom processes rely on number range objects to control the next available number.
During a DDR refresh, records copied from the source system may contain document numbers that are higher than the current number status in the target system. If the target number status is not checked and adjusted, the target system may later try to create a new document using a number that already exists. This can result in duplicate number conflicts, failed postings, unnecessary test defects, or inconsistent business validation.
Key point: Number Range preparation is not just a technical check. It is a refresh readiness control that helps ensure the target system remains usable after replicated data is loaded.
Access Utilities from the DDR Central Console
From the DDR Central Console, select Utilities from the left-hand navigation menu. Utilities is where shared DDR control functions are maintained, including Pattern, Business Objects, Exclusion, Number Range, and Housekeeping.
The user should start from Utilities because Number Range is a preparation and control function. It supports Data Refresh, Object Refresh, and System Refresh activities by helping confirm that the target system is technically ready before users begin creating new documents after refresh.
Open the Number Range Tab
After Utilities opens, select Number Range from the top navigation bar. This opens the Number Range workspace where users can enter selection criteria, choose the target system, display current status, simulate proposed changes, and apply approved updates.
| Area | What it is used for |
|---|---|
| Number Range Object | Restricts the check to a specific SAP number range object. |
| Number Range | Restricts the check to one or more specific interval numbers. |
| Sub Object | Used where intervals are controlled by company code, plant, sales area, or other organisational values. |
| To Fiscal Year | Used for fiscal-year-dependent intervals. |
| Target System | Defines the SAP target system/client where number range status must be checked and adjusted. |
Display and Review Number Range Results
Click Display to retrieve the matching number range records from the selected target system. DDR presents the result table with the current interval details, current number status, proposed new number status, remaining percentage, and warning percentage.
This result table is the main review point. Before any update is applied, the user should confirm that the selected records are relevant to the refresh, the proposed new number status is sensible, and the target interval still has sufficient remaining capacity.
Understand the Result Table Columns
| Column | Meaning | Why it matters |
|---|---|---|
| Short Text | Business description of the number range object. | Helps users understand what business process the interval belongs to. |
| Object Name | SAP technical number range object name. | Confirms the exact SAP object being checked. |
| Subobject Value | Subdivision of the interval by organisational or process value. | Prevents changing an interval for the wrong company code, plant, or process area. |
| No. Range No. | The interval number. | Identifies which configured interval is being reviewed. |
| From Number and To Number | The lower and upper boundaries of the interval. | Shows the usable range and whether the interval has enough space left. |
| Number Status | Current number status in the target system. | Shows what number the target system currently believes is the latest used number. |
| New Number Status | Proposed number status after DDR calculation. | Shows the value that may need to be applied to prevent duplicate numbering. |
| Remaining Percentage | Remaining available interval capacity. | Helps identify intervals that may be close to exhaustion. |
| Warning Percentage | Threshold used to trigger attention. | Supports proactive control before the interval becomes a business issue. |
Simulate the Number Range Change
Before applying changes, use Simulation. Simulation calculates the proposed new number range status without updating the target system. This allows the user to review the impact safely and confirm whether the proposed adjustment is correct.
Simulation reduces risk because the target number range is not changed until the proposed value has been reviewed.
The proposed values can be reviewed by the refresh owner, SAP functional lead, or basis/security team before the update is applied.
Apply Approved Number Range Updates
After the simulation result has been reviewed and accepted, click Apply to update the target number range status. This should only be performed when the target system, interval, subobject, fiscal year, and proposed new number status have been checked.
Important: Do not apply number range changes blindly. Incorrect updates may affect future document creation in the target system. Always check the selected target system and proposed values before applying changes.
Why Number Range Setup is Required Before Refresh
Stops the target system from generating a number that already exists after source records are copied.
Reduces avoidable test defects caused by posting failures and duplicate document number errors.
Ensures the target system is technically aligned with the refreshed data before users start validation.
Provides a repeatable preparation step that can be included in every DDR refresh runbook.
Recommended DDR Number Range Process
- Open Utilities from the DDR Central Console.
- Select Number Range from the Utilities top bar.
- Select the correct Target System.
- Enter number range object, interval, subobject, and fiscal year filters where required.
- Click Display and review the result table.
- Check current number status, proposed new number status, remaining percentage, and warning percentage.
- Run Simulation first.
- Apply only approved updates.
- Refresh and confirm the updated status before continuing with refresh execution.