topic Re: Generating unique key in Application Development and Automation Discussions

Generating unique key

Former Member — Thu, 26 Oct 2006 10:18:12 GMT

Hi all,

How can we create a unique key of 8 characters long using BUKRS(4), BELNR(10) and GJAHR(4)?

Thanks in advance.

Poorna

Re: Generating unique key

Former Member — Thu, 26 Oct 2006 10:20:09 GMT

you can.. but your requirement is vague..explain clearly.

regards,

Sandeep Josyula

Re: Generating unique key

FredericGirod — Thu, 26 Oct 2006 10:20:17 GMT

create a table with the 3 fields in key and add a number range.

BUKRS (X)

BELNR (X)

GJAHR (X)

Value

to add the value of Value go to transaction SNRO.

Fred

Re: Generating unique key

Former Member — Thu, 26 Oct 2006 10:26:09 GMT

Can you please brief as why do you need the unique key and how long would you keep the data for because the solution would more or less depend on that.

Re: Generating unique key

Former Member — Thu, 26 Oct 2006 10:32:16 GMT

Hi Fred,

Thanks for replying.

Firstly let me explain my questions properly for all.

I want to create a unique key of 8 charecters long using BUKRS, BELNR and GJAHR in BKPF table.

I'll be using this unique while downloading BKPF data to two different files. I'll be using this 8 characters long unique key as reference in these two files which is sent to legacy system for further processing.

Hope i'm clear with my question.

Fred can you please explain more about SNRO transaction and how i can create number range using these three fields.

Thanks in advance

Poorna

Re: Generating unique key

FredericGirod — Thu, 26 Oct 2006 10:37:29 GMT

The SNRO transaction will generate a unique value.

You will need to make a link between this value and the 3 fields. To create this link I propose to create a table.

You will need a user-exit / Badi to set the value into the tabel BKPF. In this user-exit, add the code to ask a new value of the range number using function : NUMBER_GET_NEXT.

Create the entry in the Zxxxx table. And replace the value into the BKPF table.

SNRO:

set an object name ZKEY_BKPF for ex.

Press create button (blank page)

Add description

set the data element of the field of BKPF

set the size

After this with function NUMBER_GET_NEXT, SAP will propose you the next free number.

Fred