Plant wise Invoice number range

[Former Member]

Hi,

I want to have number range plant wise for my billing documents.

I am using userexit_number_range.

can anybody tell me the logic for the same to do this

Rgds

[Former Member]

hi

create a zee table with no range interval , from and to, plant and year if u want it as year specific and also billing type

then ask u r abapper to do the necessary coding like the example below

Use the Exit RV60AFZZ.

FORM USEREXIT_NUMBER_RANGE USING US_RANGE_INTERN.

if (

xvbrk-fkart = 'ZaF3' or xvbrk-fkart = 'ZaF2' )

and xvbrk-vkorg = '1111'.

case xvbrp-werks.

when '1112'.

us_range_intern = 'z1'.

when '1211'.

us_range_intern = 'z2'.

Endif.

ENDFORM.

[Former Member]

Hi, Plant specific number ranges is possible, with ABAP development, for this you have to maintain entries in a Ztable in the Transaction SM30, here you have to maintian number range objects against the plant and billing type. ASk the ABAPER to write in the user exit SAPMV60AFZZ to pick up the number range based on the entries maintained in the Ztable. When ever plant changes the invoice document will be changing accordingly.

Regards,

[Former Member]

Hello

First Create a Z table with the plant sales area ,billing document and the number range to be used

in the exit , take the help of abap consultant and write that based on the data in VBRK strucutre which is filled , check the values forthe entry in z table and to fetch the current number aviloable , which would be in series as u would use a standard number range object for this

Hope this helps

Thanks

akasha

[Former Member]

But what logic i shud put in the user exit to pass values of my z table to which table??

Rgds

[Lakshmipathi]

The logic may be in VF01, once the delivery reference is entered and executed, system should in the background check the preceding document datas in Table LIPS and Field WERKS and based on the field, number range should be assigned.

thanks

G. Lakshmipathi

[Former Member]

Thanks

But my problem is i want number range 1-10000 for all the plants.

I mean when i create a invoice in Plant 1000 i will get no. as 1

similarly for plant 2000 i will agian get no. as 1 and not the number 2 which happens in std.

How to do this in logic

Rgds

[Former Member]

hi

I f in u r process if u create a excise invoice it will be based on plant basis only as per series groups

suppose if in u r company there are 2 plants with 2 excise registrations and 2 series groups

\

then as per ur requirement the numbers as 1 will come

[Former Member]

Yes in excise inv. its plant wise that i know yaar.

I am asking abt. no. ranges of commercial billing docs. that i want plant wise

RGDS

[Lakshmipathi]

You have to create a zee table (say ZINV_NUMRANGE) in which, have the combination of Plant, Billing Type and Object in SM30

Let us assume, with the above combination your case is

1000 (Plant)

ZAFE (Billing Type for Exports)

ZA (Object)

The above combination will have to be maintained for all billing types.

Now go to VN01 and maintain as follows:-

ZA:::00001::::10000

Now create a billing and see how it works.

thanks

G. Lakshmipathi

[Former Member]

if u r requirement is like that what i suggest is

Try to convince the client

First create as many billing types plant wise if u have 2 plants create 2 billing types then create 2 number ranges like

Z1= 12000000001-------12009999999 first 4 digits will be plant code

z2=11000000001----

---

1100999999

and assign this no ranges to u r billing types

like this u can maintian

But as per u r requirement for 2 plant numbers staring with 1 is not possible

[Former Member]

thanks again

but my problem is i have multiple plants but the billing type for all of them is same i.e. zf2

then noe how to use same no. range object that should be independent for all the plants

Means depending on the invices we prepare in the plant the no. range should follow sequentilly and not jump plant wise.

Rgds

[bcrao]

Hi,

Check this option- using copy control- split the Billing doc based on plant.

Chidambaram