topic Re: table in Application Development and Automation Discussions

table

Former Member — Tue, 15 Apr 2008 20:32:30 GMT

Hello,

can any body send me sample code for....

i have some (5) common fields from different 4 data base tables. I want to built internal table which includes this 5 common fields for further processing.

thanks.

Re: table

b_deterd2 — Tue, 15 Apr 2008 20:37:51 GMT

Hi,


Types: begin of ty_data.
types: custfield1 type ...
types: custfield2....
etc...
Types: end of ty_data.

*then create your itab based on the type
Data: itab type table of ty_data.

Regards,

Bert

Re: table

Former Member — Tue, 15 Apr 2008 20:46:34 GMT

Hi Rani,

Suppose that the common fields are a,b,c,d,e. Then declare a internal table like this:

Data: Begin of itab occurs 0,

a type a,

b type b,

c type c,

d type d,

e type e,

End of itab.

It will fulfill your requirement.

Regards,

AMK.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 15, 2008 4:50 PM

Re: table

Former Member — Tue, 15 Apr 2008 21:23:34 GMT

hello ,

Thanks for reply.

But my problem is my x ,y fields is in 1 data base table .

y,z,a,b fields in 2nd DB table.

I want all field a,b,x,y,z in my internal table .

So i want to know how data can be stored in itab.

should i use join?

if yes how?

Thanks again.

Re: table

Sm1tje — Tue, 15 Apr 2008 21:28:30 GMT

using a join would be a possibility.

select (list all fields you want in same order as in internal table like this table1-fieldx

table1-fieldy

table2-fieldz

from table1 inner join

table2 on table1_{fieldx = table2}fieldx

into (corresponding fields of) table itab

where .....

Use F1 help on select for better understanding of INNER JOIN.