cancel
Showing results for 
Search instead for 
Did you mean: 

Generate sequencenumber for records from Flat-File

Former Member
0 Kudos

Hi everybody,

I have to load a flat file into PSA and want to have a sequencenumber for each record in the PSA. In the new formula editor with BW 3.0B is no function to do something like that. So it seems I have to write a little ABAP-Routine in the transfer rule. Has anybody done something similar?

Kind regards,

Hansjörg

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Tushar

I have to guarantee the uniqueness of the key in the ODS object. The sequence number is a part of the compound key of the ODS object. From the source system i have sometimes '000000' in the sequence number. In this case I want to use the number from the PSA.

The question has been answered anyway. I have found in the ABAP routine in the transfer rule the variable RECORD_NO which is sufficent for me.

Kind regards,

Hansjörg

Former Member
0 Kudos

Hansjörg

when data is stored in PSA, BW generates a sequential no and saves it with the data.

why do you want the sequential nuber ?

Tushar