Hi,
I am trying to query data from some tables and tyring to figure what is the best way to do it.
types: begin of ty_test,
field1 type num08 ,
field2 type char30,
end of ty_test,
tt_test type standard table of ty_test.
data: t_inp type standard table of tt_test,
t_tbla type standard table of tt_test.
lets consider the table t_inp has 10 entries and based on entries from t_inp I need to get related data from table A
select objid sobid from A
into table t_tbla
for all entries in table t_inp
where field1 = t_inp-field2.
If I do this I get an error saying that to use for all entries it needs to be of the same type and length
I will have to do something similar atleast 3 to 4 times.
Note:- << Removed>> I am trying to avoid using select end select statement.
Thanks
Vick
Added code tags.
Please do not offer rewards
And please use a meaningful subject. Everyone needs programming help.
Edited by: Rob Burbank on Feb 27, 2009 11:08 AM