please explain select query.

Former Member — Wed, 13 Feb 2013 13:39:55 GMT

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.

Re: please explain select query.

Former Member — Wed, 13 Feb 2013 13:48:07 GMT

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

Re: please explain select query.

Former Member — Wed, 13 Feb 2013 14:03:10 GMT

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.

Re: please explain select query.

Former Member — Wed, 13 Feb 2013 14:08:48 GMT

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

Re: please explain select query.

Former Member — Wed, 13 Feb 2013 14:22:33 GMT

Thanks Amith for your replay.

topic Re: please explain select query. in Application Development and Automation Discussions

please explain select query.

Re: please explain select query.

Re: please explain select query.

Re: please explain select query.

Re: please explain select query.