topic Re: read internal table in Application Development and Automation Discussions

read internal table

Former Member — Mon, 22 Sep 2008 10:06:07 GMT

Hi expertz,

i have 2 tables with different structures and 1 field in common

iam reading entries in one table using the common field..but the problem is... this field is not unique so im always reading the same entry..but wanted to read next entry..how can i overcome this problem..

thanks

Re: read internal table

Former Member — Mon, 22 Sep 2008 10:08:47 GMT

Hi,

Please use

LOOP at First Internal table into Workarea1.

Read Table Second Internal table into work area2 where Workarea2-field = workarea1-field.

if sy-subrc eq 0.

endif.

endloop.

regards

jana

Re: read internal table

Former Member — Mon, 22 Sep 2008 10:11:37 GMT

Hi,

this is how i used...but branch is not key ..so it always reading the same

LOOP AT gt_output.

READ TABLE gt_zfitab_payments

ASSIGNING <fs_payments> WITH KEY zbranch = gv_storeno

BINARY SEARCH .

endloop.

reg

Re: read internal table

Former Member — Mon, 22 Sep 2008 10:15:13 GMT

Hi ,

So whenever you read the record check its values with existing records in the table by comparing some fields which you have considered as unique keys while declaring the table and only if the record is different then only use the record or else go for next records.

Thanks

Sudharshan

Re: read internal table

Former Member — Mon, 22 Sep 2008 10:16:02 GMT

Try this


LOOP AT gt_output.

LOOP AT gt_zfitab_payments
ASSIGNING <fs_payments> 
WHERE zbranch = gv_storeno.

endloop.

Re: read internal table

Former Member — Mon, 22 Sep 2008 10:16:36 GMT

Hi ,

If u want to read line of an internal table uniquely , u need to have unique key combination .

U can do like this .

U can create a counter on the 1st internal table at the every change of common field value , so that u can read using the common field and counter.

ex:

sort it2 by <commonfield>.

loop at it2.

v = v + 1.

read table it2 with key <commonfield> = <commnfield> counter = v.

at end of <commonfield>.

clear v.

endat.

endloop.

2nd way :

I dont know wht u want to do after reading , how ever if u want all records with common fields u can loop with respect to common field.

ex:

loop at it2.

loop at it1 where commonfield = it2-commonfield.

endloop.

Hope this helps in solving ur problem.

Regards,

Ramesh

Re: read internal table

Former Member — Mon, 22 Sep 2008 10:16:59 GMT

Hi,

If you are talking about Database Tables, try to use 'Inner join' or 'For all entries'.

If you are talking about internal tables, try to 'SORT' it and use 'DELETE ADJACENT DUPLICATES'.

Regard,

R.Nagarajan.

Re: read internal table

Former Member — Mon, 22 Sep 2008 10:17:49 GMT

Hi,

In that case you need to use nested loop. But use it like this

LOOP AT gt_output.

LOOP AT gt_zfitab_payments WHERE zbranch = gv_storeno.

ENDLOOP.

Regards,

Venkat

Re: read internal table

Former Member — Mon, 22 Sep 2008 10:24:42 GMT

Hi,

sort before loop based on branch field.

Sort gt_output by zbranch.

LOOP AT gt_output.

READ TABLE gt_zfitab_payments

ASSIGNING <fs_payments> WITH KEY zbranch = gt_output-branch BINARY SEARCH .

endloop.

Hope helps.

If not can you provide test data.

Regards,

Salini.