topic Re: syntax query in Application Development and Automation Discussions

syntax query

Former Member — Mon, 28 Jul 2008 10:38:37 GMT

hi all,

is the following syntax valid.

select * from dbtab for all entries of it_tab.

im running a batch program. i just want to check if my entries in my internal table are present in my dbtab.

so that i dont insert my dbtab for those corresponding entries

i strictly want to avoid looping on the it_tab.

please correct me if wrong also give alternative if any

Re: syntax query

Former Member — Mon, 28 Jul 2008 10:40:54 GMT

hiii

no this is not a valid syntax

select * from dbtab for all entries of it_tab.

you should use it like below

select * from dbtab for all entries IN it_tab where field1 = field1-it_itab.

regards

twinkal

Re: syntax query

Former Member — Mon, 28 Jul 2008 10:40:59 GMT

Hi,

You should use a where condition for the select which is common to both database and internal table.

By this query you get the data which are common in internal table and database. the remaining data which are in database will not be selected.

is this what u need?

Re: syntax query

Former Member — Mon, 28 Jul 2008 10:42:35 GMT

hi,

If i have understood your question correctly do this way ..


if not it_tab[] is initial.
 select * from dbtab into table it_data for all entries in it_tab
              where field1 = it_tab-field1 and
                       field2 = it_tab-field2.
endif.

Regards,

Santosh

Re: syntax query

Former Member — Mon, 28 Jul 2008 10:44:46 GMT

hi,

You need to give atleast one selection criteria field. Like this,

SELECT * FROM vbap

INTO CORRESPONDING FIELDS OF TABLE t_vbap

FOR ALL ENTRIES IN t_vbak

WHERE vbeln = t_vbak-vbeln.

Re: syntax query

Former Member — Mon, 28 Jul 2008 10:46:09 GMT

if by that query i get the entries which are common that means i should not append my itab.(using sy-subrc)

else i should .

but how do i seggregate between the entries which are present in dbtab and the entries which are not.

Re: syntax query

Former Member — Mon, 28 Jul 2008 10:48:29 GMT

by this select query you get the entries which are there in the internal table only.

Re: syntax query

Former Member — Mon, 28 Jul 2008 10:52:05 GMT

thank you all for helping me out