Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.