topic Re: select statement problem? in Application Development and Automation Discussions

select statement problem?

Former Member — Thu, 12 Apr 2007 11:46:06 GMT

hi,

may i know if the select statement can work if can satisfy in the where? i check the tablex entry for where clause and it is correct but i do not know why no data collected.

any reason?

thanks

internal table it_tab with fields below

fielda

fieldb

fieldc

fieldd

fielde

select fieldb fieldc fieldd into corresponding fields of wa_tab

from tablex

where ......

if sy-subrc = 0

select single aa bb into (wa_tab-fieldd , wa_tab-fielde) where ....

concatenate wa_tab-fieldb wa_tab-fieldc to wa_tab-fielda.

collect wa_tab to it_tab.

endif.

endselect.

Re: select statement problem?

Former Member — Thu, 12 Apr 2007 11:49:24 GMT

could u paste your where clause code here !!!

regards,

sai ramesh

Re: select statement problem?

Former Member — Thu, 12 Apr 2007 11:51:41 GMT

Use Like That

Select A B C from XYZ into wa_xyz where xxxxxxxxxx.

endselect.

if sy-subrc eq 0.

endif.

if you are fetching one value then use single

declare fields according to the table sequence

Re: select statement problem?

Former Member — Thu, 12 Apr 2007 11:53:05 GMT

Hi El,

In the code u have written here :

select fieldb fieldc fieldd into corresponding fields of wa_tab

from tablex

where ......

if sy-subrc = 0.

In this code, instead of using the internal table it_tab u have used workarea wa_tab.

Only when we use select single , we will be using work area.

Hope this helps you fetch the data.

Regards,

Thasneem

Re: select statement problem?

Former Member — Thu, 12 Apr 2007 11:55:29 GMT

internal table it_tab with fields below

fielda

fieldb

fieldc

fieldd

fielde

select fieldb fieldc fieldd into corresponding fields of wa_tab

from tablex

where ......

if sy-subrc = 0

select single aa bb into (wa_tab-fieldd , wa_tab-fielde) where ....

concatenate wa_tab-fieldb wa_tab-fieldc to wa_tab-fielda.

append wa_tab to it_tab.

endif.

endselect.

u need to append data to internal table....

sort it_tab by fielda fieldb fieldc fieldd.

loop at it_tab.

collect it_tab.

endloop.

Re: select statement problem?

Former Member — Thu, 12 Apr 2007 12:03:42 GMT

hi ramesh,

thanks.

why cannot directly collect?

points awarded