Hi All,
I have an internal table i_catsdb (having catsdb data).
It is defined like this:
counter
refcounter
pernr
creation_date (.... some other fields...and then)
status
Hours
<b>Now, i know that there will around 10,000 records in this internal table. This internal table is sorted on field counter.</b>
My task is to, make the hours negative based on refcounter and pernr...
for eg: If records in i_catsdb are like,
counter Ref Counter Pernr Hours status
1 100001 9.0 60
2 1 100001 8.0 60
3 2 100001 8.5 60
4 3 100001 8.2 30
then i should get the following records in i_catsdb.
counter Ref Counter Pernr Hours status
1 100001 9.0 60
2 1 100001 8.0 60
3 2 100001 8.5 60
4 3 100001 8.2 30
1 100001 -9.0 60
2 100001 -8.0 60
3 100001 -8.5 60
(In total 7 records)
Now the question is, which among the below options is opimimal in terms of performance?
Option 1: (<b>My Choice</b>) Have another internal(say i_temp) with same fields of i_catsdb (but, have pernr and counter as key fields,sorted on the same).
Loop on i_catsdb, read i_temp with pernr and counter = i_catsdb-ref_counter, and negate the hours, clear refcounter and take the record as new record into i_catsdb.
Option 2: loop on i_catdb, try reading the same internal table with pernr and counter = ref_counter, negate hours, clear ref_counter and insert as new row in i_catsdb.
Though, its a lengthy question.... i want to be more clear.
Regards,
Raj
