topic Re: Select query returning data when AND condition fails in Application Development and Automation Discussions

Select query returning data when AND condition fails

Former Member — Mon, 10 Feb 2014 06:28:50 GMT

Hi All,

The below query should ideally not work when range table : s_blart_final is empty .But somehow its still working and fetching data.

How can I rectify this??

SELECT      rprctr

                rbukrs

                kunnr

                ryear

                poper

                budat

                racct

                docnr

                docln

                blart

                refdocnr

                ksl

                rtcur

                usnam

                matnr

                rassc

                vkbur

                spart

                werks

                msl

                hsl

                tsl

                fkart

                bwtar

                refdocln

                drcrk

     FROM        glpca

     UP TO       2501 ROWS

     INTO TABLE gt_glpca_2k

     FOR ALL ENTRIES IN gt_bukrs_hkont

     WHERE rbukrs EQ gt_bukrs_hkont-bukrs

     AND   racct EQ gt_bukrs_hkont-hkont

     AND rhoart = gc_rhoart

     AND kokrs = gc_kokrs

     AND   ryear IN s_ryear

     AND activ = gc_activ

     AND   poper IN s_poper

     AND rldnr = gc_rldnr

     AND rrcty = gc_rrcty

     AND rvers = gc_rvers

     AND   blart IN s_blart_final

     AND   werks IN s_werks

     AND   matnr IN s_matnr

     AND   vkbur IN s_vkbur

     AND   kunnr IN s_kunnr.

Regards,

Faiz

Re: Select query returning data when AND condition fails

nabheetscn — Mon, 10 Feb 2014 06:32:47 GMT

Why it should not work a blank range is as good as this field is not considered for filtering out the selection.. you are expecting it to pick on values where document type is initial?

Nabheet

Re: Select query returning data when AND condition fails

arivazhagan_sivasamy — Mon, 10 Feb 2014 06:34:27 GMT

Hi Faiz,

If s_blart_final is empty, it will fetch all the values from table glpca corresponding to blart.

If s_blart_final is having any values, it will fetch the corresponding blart from table glpca.

Arivazhagan S

Re: Select query returning data when AND condition fails

Former Member — Mon, 10 Feb 2014 06:40:56 GMT

Hi nabheet,

my requirement is that if this range field :s-blart_final is empty, then the query should fail.

How do I achieve this???

Re: Select query returning data when AND condition fails

nabheetscn — Mon, 10 Feb 2014 06:45:00 GMT

Then simple put a check before the query if S_BLART[] is not initial

Re: Select query returning data when AND condition fails

thangam_perumal — Mon, 10 Feb 2014 06:45:28 GMT

Hi Rahman,

yeah sivasamy correctly said if s_blart_final is empty it will select the all the possible values.

if had any value mean it will select the condition with respect to s_blart_final values.

Regards,

Thangam.P

Re: Select query returning data when AND condition fails

Former Member — Mon, 10 Feb 2014 06:49:15 GMT

Your are using s_blart_final as a range table, so this condition work as an optional check, if value exist in s_blart_final then it will check for the condition otherwise it will skip this condition.

If u want to make s_blart_final mandatory then you have to check it it initial or not before select query..

if s_blart_final[ ] is not initial.

endif.

And you are also using FOR ALL ENTRIES so make sure that gt_bukrs_hkont is not empty.

Re: Select query returning data when AND condition fails

former_member187748 — Mon, 10 Feb 2014 06:59:05 GMT

Hi Faizur,

just write before fetching data to check

IF s_blart_final is not initial.

SELECT ......

ENDIF.

You don't have to worried about it too much.

Re: Select query returning data when AND condition fails

sachin_khedkar — Mon, 10 Feb 2014 07:02:17 GMT

This message was moderated.

Re: Select query returning data when AND condition fails

Former Member — Mon, 10 Feb 2014 07:05:10 GMT

Hi,

Before writing select query u check s_blart_final table is empty or not,

If s_blart_final[] is not initial then proceed other wise exit..

Regards

Abhay Manna.

Re: Select query returning data when AND condition fails

NooruBohra — Mon, 10 Feb 2014 07:50:57 GMT

Hi Rahman,

If s_blart_final is empty then query will fetch the record from database, If you're requirement is that the query should not get executed when s_blart_final is initial then perform a check

IF s_blart_final[ ] is not initial.

Select Query * . . .

ENDIF.

Regards,

Nooruddin