Skip to Content
avatar image
Former Member

Generate sequencenumber for records from Flat-File

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 21, 2004 at 11:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 22, 2004 at 01:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded