topic Re: Getting number range interval for document type in Application Development and Automation Discussions

Getting number range interval for document type

suresh_kumar53 — Sun, 21 Sep 2008 13:56:53 GMT

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.

Re: Getting number range interval for document type

Former Member — Sun, 21 Sep 2008 17:38:00 GMT

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

Re: Getting number range interval for document type

Former Member — Mon, 22 Sep 2008 02:34:23 GMT

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

Re: Getting number range interval for document type

suresh_kumar53 — Mon, 22 Sep 2008 12:21:54 GMT

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.

Re: Getting number range interval for document type

Former Member — Tue, 23 Sep 2008 01:41:55 GMT

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

~Eswar