Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Issue with reading one internal table and passing all records

Gurus,

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.

endloop.

There are atleast three records in it_functab for a object_id, but in the wa_functab only one record is passed.

Please help.

Regards,

Rajesh.

Tags:
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.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question