topic Re: can we replace this SELECT query by more efficient code in Application Development and Automation Discussions

can we replace this SELECT query by more efficient code

Former Member — Fri, 08 Dec 2006 12:52:21 GMT

can we replace this SELECT query by more efficient code ?:-

SELECT * FROM zv7_custord
     INTO TABLE G_T_ZV7_CUSTORD
     WHERE ( SENDER in S_SENDER and
             ORDNUM in S_ORDER  and
             ZDATE   in S_DATE ) OR
           ( SENDER in S_SENDER AND
             STATUS = SPACE )
     ORDER BY IDOCNUM.

Re: can we replace this SELECT query by more efficient code

Former Member — Fri, 08 Dec 2006 12:58:16 GMT

Remove order by addition and use sort on internal table.

SELECT * FROM zv7_custord

INTO TABLE G_T_ZV7_CUSTORD

WHERE ( SENDER in S_SENDER and

ORDNUM in S_ORDER and

ZDATE in S_DATE ) OR

( SENDER in S_SENDER AND

STATUS = SPACE ).

sort g_t_zv7_custord by idocnum.

Regards,

Ravi

Re: can we replace this SELECT query by more efficient code

Former Member — Fri, 08 Dec 2006 12:59:17 GMT

hI,

HERE WITH OUT SPECIFYING * YOU can use the fields names directly.

because it will fetch all the data including mandt so it will get performance problem.

SELECT * FROM zv7_custord

INTO <b>CORREPONDING FIELDS OF</b> TABLE G_T_ZV7_CUSTORD

WHERE ( SENDER in S_SENDER and

ORDNUM in S_ORDER and

ZDATE in S_DATE ) OR

( SENDER in S_SENDER AND

STATUS = SPACE )

ORDER BY IDOCNUM.

Message was edited by:

Purshothaman P

Re: can we replace this SELECT query by more efficient code

Former Member — Fri, 08 Dec 2006 13:00:32 GMT

Hi ,

Using into corresponding fields , does not help the cause of performace enhancement.

Regards

Arun

Re: can we replace this SELECT query by more efficient code

Former Member — Fri, 08 Dec 2006 13:07:42 GMT

U can leave ORDER BY option and sort the table by yourself and try to split the query:

SELECT * FROM zv7_custord
     INTO TABLE G_T_ZV7_CUSTORD
     WHERE  SENDER in S_SENDER and
                   ORDNUM in S_ORDER  and
                   ZDATE   in S_DATE .

SELECT * FROM zv7_custord
     APPENDING TABLE G_T_ZV7_CUSTORD
     WHERE  SENDER in S_SENDER        and
                   NOT ORDNUM in S_ORDER  and
                   NOT ZDATE   in S_DATE       and
                   STATUS = SPACE

SELECT * FROM zv7_custord
     INTO TABLE G_T_ZV7_CUSTORD
     WHERE  SENDER in S_SENDER and
                   ORDNUM in S_ORDER  and
                   ZDATE   in S_DATE .

SELECT * FROM zv7_custord
     APPENDING TABLE G_T_ZV7_CUSTORD
     WHERE  SENDER in S_SENDER        and
                   STATUS = SPACE.

* Sort the table key fields
SORT G_T_ZV7_CUSTORD BY <KEY1> <KEY2> .....
DELETE ADJACENT DUPLICATES FROM G_T_ZV7_CUSTORD COMPARING <KEY1> .....

Max