please explain select query.

[Former Member]

Hi all ,

The viqmel table is getting filtered by 180 days of notification date(Qmdat)  but when i try to filter in the viqmel table for 180 days

the value is different from select query and viqmel,

viqmel is containing all values but this select query is filtering some values, what is the logic behind the query.

ENHANCEMENT-SECTION     sel_meld_stand_02 SPOTS es_riqmel20.

     SELECT (g_selfields_tab) FROM (g_viewname)     " g_viewname  is viqmel table

             INTO CORRESPONDING FIELDS OF TABLE lt_viqmel_iflos

                           WHERE qmnum IN qmnum

                           AND   iwerk IN iwerk

                           AND   tplnr IN strno

                           AND   swerk IN swerk

                           AND   kostl IN kostl

                           AND   abckz IN abckz

                           AND   gsber IN gsber

                           AND   anlnr IN anlnr

                           AND   stort IN stort

                           AND   msgrp IN msgrp

                           AND   eqfnr IN eqfnr

                           AND   beber IN beber

                           AND   ingrp IN ingrp

                           AND   equnr IN equnr

                           AND   matnr IN matnr

                           AND   serialnr IN serialnr

                           AND   deviceid IN deviceid

                           AND   bautl IN bautl

                           AND   msaus IN msaus

                           AND   ausvn IN ausvn

                           AND   ausbs IN ausbs

                           AND   auztv IN auztv

                           AND   auztb IN auztb

                           AND   btpln IN btpln

                           AND   bequi IN bequi

                           AND   auswk IN auswk

                           AND   verfv IN verfv

                           AND   verfn IN verfn

                           AND   verfm IN verfm

                           AND   anlzv IN anlzv

                           AND   anlzn IN anlzn

                           AND   anlze IN anlze

                           AND   inspk IN inspk

                           AND   datan IN datan

                           AND   qmart IN qmart

                           AND   bukrs IN bukrs

                           AND   priok IN priok

                           AND   ernam IN ernam

                           AND   erdat IN erdat

                           AND   aenam IN aenam

                           AND   aedat IN aedat

                           AND   mzeit IN mzeit

                           AND   qmnam IN qmnam

                           AND   strmn IN strmn

                           AND   ltrmn IN ltrmn

                           AND   aufnr IN aufnr

                           AND   kunum IN kunum

                           AND   vbeln IN vbeln

                           AND   kdauf IN kdauf

                           AND   kdpos IN kdpos

                           AND   bstnk IN bstnk

                           AND   bstdk IN bstdk

                           AND   qmdab IN qmdab

                           AND   bezdt IN bezdt

                           AND   rbnr  IN rbnr

                           AND   qmdat IN gr_date

                           AND ( kzloesch = space OR

                                 kzloesch IS NULL )

                           AND   qmart IN i_qmart

                           AND   vkorg IN vkorg

                           AND   vtweg IN vtweg

                           AND   spart IN spart

                           AND   auszt IN i_auszt

                           AND   arbpl IN i_arbpl

                           AND   qmgrp IN qmgrp

                           AND   qmcod IN qmcod

                           AND   warpl IN warpl

                           AND   wapos IN wapos

                           AND   owner IN i_owner

                           AND   phase IN gr_phase

                           AND   uii   IN gr_uii.           "EHP603 IUID

END-ENHANCEMENT-SECTION.

[Former Member]

Hello,

why need all those fields on the select statement?

if you have the value of qmnum that's all what u need, because it is key field on the table.

No need those extra fields, check it.

write this:

     SELECT (g_selfields_tab) FROM (g_viewname)     " g_viewname  is viqmel table

             INTO CORRESPONDING FIELDS OF TABLE lt_viqmel_iflos

                           WHERE qmnum IN qmnum.

Regards

[Former Member]

Hi Miguel,

thanks for your response.

the value is getting from viqmel table using notification date (qmdat field)

but when i am checking the table entries are more but the values that i am getting is less in numbers

the query you can find it in riqmel20 (iw22) transaction.

[Former Member]

Hi Vinay ,

Use only those field on which u want the value not all the fields .....

you can use only key fields as well.....

These types of select queries often degrades the performance.

Hope this will help ....

Regards,

AKS

[Former Member]

Thanks Amith for your replay.