About Automatic Generation of Primary key

[Former Member]

I have created one Z table. Its composite primary keys are vkorg

and Sales Representive Number. I have to assign Sales Representive number

through system. How it should be done?

[Former Member]

If u provide detail scenario.. can able to reach solution.

Regards,

Sujatha.

[nilesh_vakil]

Basically we have different situation.

Here we are creating sales represantative for each area for

our particular business. We are manually assigning salrep_no key.

with vkorg as composite primary key. Many time user forgets the last no.

I wanted the functionality by which if in the screen user adds vkorg and name of sales rep and address its salesrep no will be automatically created.

[Former Member]

You can create Number range objects for that table field.

tcode : SNRO

Regards

Rusidar

[nilesh_vakil]

Thanks for your wonderful answer Rusidar .

I have created number range object but please

can anyone tell me how to use it in table?

[Former Member]

Hi,

In your Z table tick the Both Fields VKORG and SALRP(Sales Rep) as Key fields.

And assign TVKO as check table for VKORG field and Similarly assign KNA1 table as check table for SALRP field by assgning ZTable-SALRP =KNA1-KUNNR.

But you have to check that this Partner Function(PARW) SALESREPRESENTATIVE has been already defined in the SD and check whether any values exists for this entry in KNVP table and KNA1 .

Regards,

Anji

[nilesh_vakil]

Ya thanks i got answer