topic Re: using 3 internal table how we will create join in Application Development and Automation Discussions

using 3 internal table how we will create join

Former Member — Fri, 22 Feb 2008 10:15:56 GMT

how we will make join by takin data from 3 internal table , plz tell me in details?

Former Member — Fri, 22 Feb 2008 10:27:59 GMT

Loop at the table which is having items or multiple entries

read the second table based on loop value

read the third table based on the first or second table

Modify the first table add the required fields to first field to have them in one

regards

Shiva

Former Member — Fri, 22 Feb 2008 10:34:13 GMT

plz tell me bya an example, can we use for all entries here?

Former Member — Fri, 22 Feb 2008 10:45:02 GMT

Hi,

How can you use For all entires when the data is in itab

if you want to get the related data from database table then use For all entires

Regards

Shiva

Former Member — Fri, 22 Feb 2008 16:25:17 GMT

assume that 3 itabs have a common fld1

and we r joining all3 into 4th , itab4

loop itab1.

read table itab2 with key fld1 = itab1-flad1.

read table itab3 with key fld1 = itab1-flad1.

move corresponding fields from itab1 to itab4.

move corresponding fields from itab2 to itab2.

move corresponding fields from itab3 to itab2.

append itab4

clear itab1, itab2 itab3, itab4.

endloop

now itab4 contains all the join flds

Reward if useful