Issue with reading one internal table and passing all records
I have a situation where I have to read an internal table ITAB with a key. Now ITAB can have multiple values for the same key, so I want to pass all the records found in ITAB for that key in other internal table.
DATA: BEGIN OF it_functab OCCURS 0,
OBJECT_ID type SDOK_PHID,
FUNC_LOC TYPE TPLNR,
END OF it_functab.
DATA: wa_functab like it_functab occurs 0 with header line.
sort it_functab by object_id.
loop at it_proctab.
READ table it_functab into wa_functab with key object_id = it_proctab-object_id binary search transproting all fields.
There are atleast three records in it_functab for a object_id, but in the wa_functab only one record is passed.
Joyjit Ghosh replied
As u mentioned earlier in ur 2nd table u have 3 records which are matching the 1st table key..if this is the case then I donot think it is aperformance issue but say u have lot of records which are matching with the a key of the outer table then u can use parallel cursor technique to improve the performance.