Number Range Buffering

Basic Introduction to NRIV

The document number is assigned in chronologically ascending order based on the table NRIV. For this, the table NRIV is locked until the application (LUW) is terminated by either a COMMIT WORK or ROLLBACK (OSS Note 639754). Another application cannot take a document number during this time.

The update is called by the COMMIT WORK and the document number is assigned permanently. In the case of a rollback, the document number that was just used is not assigned and is available for the next posting in NRIV again. This lock guarantees a choronologically ascending assignment of the document number without gaps.

However, the lock causes a serialization in the table NRIV, which can seriously impair the system performance (OSS Note 678501). There are performance problems in particular in the case of parallel batch processes, as the lock is held for a very long time.
There are two solutions for this:

  • No parallel processing
  • Buffering of the number range object RF_BELEG. (Be careful doing this as in many countries document numbers must remain consecutive and depending on the buffer used (see below) a number range buffer may cause the document numbers to be assigned with gaps.)

Want more info? Read Oss notes – Note 179224, Note 599157, Note 840901

Leave a Reply