structure!

[Former Member]

I have defined three structure in se11.......

and in se38 when i was doing prog i defined three itab....... corresponding to that structure.

Now I need to write select stament based on that three itab. .......

How I will write that select statement.....

Plz help...

Thanks......

[Former Member]

You cannot do select from a structure. There has to be a table.

Regards,

Aravind

[Former Member]

if u want to fetch the data from 3database tables individually then do liek this -

tables: dbtab1,dbtab2,dbtab3.

data begin of itab.

include structure dbtab1.

data end of itab.

data begin of itab1.

include structure dbtab2.

data end of itab1.

data begin of itab2.

include structure dbtab3.

data end of itab2.

select * from dbtab1 into table itab up to 20 rows where field1 = '123'.

select * from dbtab2 into table itab1 up to 20 rows where field1 = '123'.

select * from dbtab3 into table itab2 up to 20 rows where field1 = '123'.

[Former Member]

sorry i cannot get you properly from structure how can you fetch the data ? it does ot contain data. you can fetch the data from views or tables.

please tell us what is your exact requirement.

regards

shiba dutta

[Former Member]

Hello Chang,

You created a structure not a table. There should me a table for u to select data . You cant select data from a structure. Create a table in Se11 then define Internal table like that table in SE38 then you can select the data from the table. Use Select * or select corresponding fields form the table into the internal table.

Regards,

Priyanka.