Getting number range interval for document type

[suresh_kumar53]

Hi All,

My requirement is to display number range interval for any docnument type in SD.

I will elaborate my req. clearly.

We can see document type of SD in TVAK table. If we give document type for ex. ZOR the we will see number range internal assignment (NUMKI). The complete number range we can search through transaction VN01 through NUMKI value. But I didnt get any table to relate NUMKI or Sales document type and internal number range.

Please help me in searching database table to relate Document type or NUMKI and internal number range.

Regards,

Suresh.

[former_member212653]

Check out table NRIV, it stores the number range interval.

[Former Member]

Relation is as below:

TVAK --> AUART = "Sales Document Type"
NRIV --> OBJECT = "RV_BELEG" and
         NRRANGENR = TVAK-NUMKI

Alternatively you can use FM: NUMBER_GET_INFO with the Number Range Number and Object to extract Intervals.

Regards

Eswar

[suresh_kumar53]

HI Eswar,

Your answer exactly suits for my requirement. Thank you.

Please give me the clarifcations for below

Whether object RV_BELEG suits for all Salses document types?

What is the object for Delivery(data base table TVLK) and Billing (table TVFK)?

And where we can get the objects for Sales/Delivery/Billing documents?

Regards,

Suresh Kumar.

[Former Member]

Note that number range object for all SD Documents(Sales/Delivery/Billing) is RV_BELEG.

~Eswar