topic Re: Select query in Application Development and Automation Discussions

Select query

Former Member — Thu, 31 May 2007 04:13:45 GMT

Hi experts.

I need to select sales order line item based on the selection screen input.

In selection screen Rejection reason is used.

I need to exclude the line item which are having the Rejection reason giving in selection screen.

If the the selection screen input is blank then all the records should be selected even the line item has no rejection reason.

I used the following query. But it doesnt work.

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where waerk ne 'usd' / document currency

and (abgru notin s_abgru or abgru eq ' ').

pls help me to do.

Re: Select query

Former Member — Thu, 31 May 2007 04:17:02 GMT

Hi,

Try this..


select vbeln posnr abgru 
from vbap
into table t_vbap
for all entries in t_vbak
where waerk ne 'usd' / document currency
and ( NOT abgru IN s_abgru ).

Thanks,

Naren

Re: Select query

Former Member — Thu, 31 May 2007 04:18:03 GMT

try this..

you have to mention one field in where condition for the table used in for all entries

if not t_vbak[] is initial.

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where field = t_vbrk-field and

waerk ne 'USD' and

(abgru not in s_abgru[] or abgru eq ' ').

endif.

Re: Select query

Former Member — Thu, 31 May 2007 04:18:30 GMT

Hi,

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where waerk ne 'usd' / document currency

and not abgru IN s_abgru.

when the selct option is blank all the line items will be selected by default..

Regards,

Vidya.

Re: Select query

Former Member — Thu, 31 May 2007 04:21:51 GMT

try this

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where vbeln = t_vbak-vbeln and

waerk ne 'USD'

and not ( abgru in s_abgru or abgru eq ' ' ).

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where vbeln = t_vbak-vbeln and

waerk ne 'USD'

and ( abgru not in s_abgru or abgru eq ' ' ).

reagrds

shiba dutta

Re: Select query

former_member186741 — Thu, 31 May 2007 04:22:23 GMT

select vbeln posnr abgru

from vbap

into table t_vbap

where waerk ne 'USD' and

( abgru not in s_abgru or abgru eq ' ' ).

Re: Select query

Former Member — Thu, 31 May 2007 04:24:33 GMT

hi,

try with this

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where waerk ne 'usd'

and abgru IN s_abgru. [for this you have to declare s_abgru and give value for it].

if helpful reward some points.

with regards,

suresh babu aluri.

Re: Select query

Former Member — Thu, 31 May 2007 04:26:17 GMT

Hi Muru,

Try this

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where vbeln = t_vbak-vbeln and

waerk ne 'USD'

and not ( abgru in s_abgru or abgru eq ' ' ).

Regards,

Line

Re: Select query

Former Member — Thu, 31 May 2007 04:31:23 GMT

Hi,

if s_abgru is not initial.

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where waerk ne 'usd' / document currency and

abgru Ne s_abgru.

else.

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where waerk ne 'usd' / document currency.

endif.

this will solve your problem.

Regards,

Ruchika

reward if useful.

Re: Select query

Former Member — Thu, 31 May 2007 04:32:54 GMT

hi all i tried all things.

But still it is not working.

SELECT VBELN POSNR MATNR ARKTX ABGRU MEINS NETWR KWMENG VRKME ERDAT

ERNAM ERZET

NETPR STCUR

FROM VBAP

INTO TABLE T_VBAP

FOR ALL ENTRIES IN T_VBAK

WHERE VBELN EQ T_VBAK-VBELN

AND KWMENG NE 0

AND WAERK NE 'USD'

AND ( ABGRU NOT IN S_ABGRU OR ABGRU EQ ' ' ). " i i uncomment this line it will work but not correctlyl

AND NOT ( ABGRU IN S_ABGRU ). " // not picking nothing....no records.

Re: Select query

Former Member — Thu, 31 May 2007 04:34:07 GMT

Hi,

if s_abgru is not initial.

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where waerk ne 'usd' / document currency and

not (abgru in s_abgru).

else.

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where waerk ne 'usd' / document currency.

endif.

this will solve your problem.

Regards,

Ruchika

reward if useful.

Re: Select query

Former Member — Thu, 31 May 2007 04:37:25 GMT

what you do is

loop at s_abgru.

s_abgru-sign = 'E'. " Excluding

modify a_sbgru index sy-tabix.

endif.

if not t_vbak[] is initial.

SELECT VBELN POSNR MATNR ARKTX ABGRU MEINS NETWR KWMENG VRKME ERDAT

ERNAM ERZET

NETPR STCUR

FROM VBAP

INTO TABLE T_VBAP

FOR ALL ENTRIES IN T_VBAK

WHERE VBELN EQ T_VBAK-VBELN

AND KWMENG NE 0

AND WAERK NE 'USD'

AND ABGRU IN S_ABGRU . " // not picking nothing....no records

endif.

Re: Select query

Former Member — Thu, 31 May 2007 04:41:39 GMT

check in se11 whether any data is present or not for the where condition you have defined . then check in debug mode what is the sy-subrc value it is returning after the select statement...and put a check

if not t_vbak[] is initial.

select...

endif.

reagrds

shiba dutta

Re: Select query

S0025444845 — Thu, 31 May 2007 04:46:31 GMT

Hi,

use this

select vbeln posnr abgru

from vbap

into table t_vbap

for all entries in t_vbak

where waerk ne 'USD'

and abgru not in s_abgru .

anything in ' ' should be capital

sudha

Re: Select query

Former Member — Thu, 31 May 2007 04:55:10 GMT

HI ALL,

I GOT SOLUTION . Thanks to all.

hi Ruchika Saini i done it from your reply only ya. Thanks a lot.