Ansicht
Dokumentation

RFBNUM00N - Gaps in Document Number Assignment

RFBNUM00N - Gaps in Document Number Assignment

RFUMSV00 - Advance Return for Tax on Sales/Purchases   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.
SAP E-Book

Description

You can use this report to find gaps in the document number assignment across several ledgers.
The system also recognizes and documents document numbers that have been assigned more than once in an interval.
Processing takes place at the level of company code, number range, and fiscal year. If you specify the document type as a selection criterion, the program determines the relevant number range automatically.

Caution

  • This report does not consider number ranges determined separately for the general ledger view.
    This affects documents for non-leading ledgers where, within a company code, the fiscal year variant is different to the fiscal year variant of the leading ledger of the company code. In this case, the document number of the entry view (BELNR) does not correspond to the document number of the general ledger view (DOCNR).

Requirements

Restriction Company Code
The report processes any intervals of company codes. Unless you make an entry, all company codes in the system are selected.

Restriction Number Range/Document Type

  • Number range and document type
    Unless you make entries in the Number Range and Document Type fields , all number ranges avalable for the company codes in question are selected.
  • Number range
    The report processes any intervals of number ranges.
    If you make entries in the input fields for the number ranges, all number ranges defined for the company codes in question are selected.
    The validity of a number range is checked by using the T003 and FAGL_BELNR_LD tables. An exception here is the number ranges X1, X2, and X3.
  • Document type.
    The report processes any intervals of document types.
    If you use the input fields for the document type, the number ranges defined for the document types in question are selected in accordance with tables T003 and FAGL_BELNR_LD.
  • Number ranges with alphanumeric value intervals are ignored.

Restriction Fiscal Year
You have to specify exactly one fiscal year. If the number ranges are defined across several fiscal years, the output of the report always refers to the defined interval of fiscal years containing the fiscal year entered.

Example:

The current number levels exist:

NrRge (To) Year From To Status
19 2016 1900000000 1999999999 1900000506
19 2018 1900000000 1999999999 1900001234
19 2019 1900000000 1999999999 1900000789

You run the program with the following settings:

Entries on Selection Screen Checks Carried Out
Number range 19, fiscal year 2016 To 2016
Number range 19, fiscal year 2017 From 2017 to 2018
Number range 19, fiscal year 2018 From 2017 to 2018
Number range 19, fiscal year 2019 From 2019 to 2019

All of the documents in the number range interval specified are selected and the system checks for gaps and for document numbers that have been assigned more than once.

Document Numbers Assigned More Than Once

Based on the example above, the following documents could appear in the database:

Document No. Fiscal Year
1900000666 2017
1900000666 2018

The unique numbers in the database are due to the differentiation according to fiscal year.
However the document number appears more than once in the number range interval.
(Possible cause: Incorrect maintenance of number ranges)

Output

A list of missing numbers and document numbers assigned more than once is created.






General Material Data   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 5764 Date: 20240520 Time: 113852     sap01-206 ( 62 ms )