topic Re: structure! in Application Development and Automation Discussions

structure!

Former Member — Tue, 23 Jan 2007 04:52:23 GMT

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

Re: structure!

Former Member — Tue, 23 Jan 2007 04:56:23 GMT

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

Regards,

Aravind

Re: structure!

Former Member — Tue, 23 Jan 2007 04:56:34 GMT

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'.

Re: structure!

Former Member — Tue, 23 Jan 2007 05:00:23 GMT

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

Re: structure!

Former Member — Tue, 23 Jan 2007 05:00:55 GMT

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.