topic Re: Query Error in Application Development and Automation Discussions

Query Error

Former Member — Thu, 31 Jan 2008 03:39:05 GMT

Hi Experts

I have used the following query, but its performance is very bad, what could be the reason, pls advise me.

IF i_afpo[] IS not INITIAL.

sort i_afpo by aufnr.

delete adjacent duplicates from i_afpo comparing aufnr.

SELECT AUFNR

BUDAT

ISDD

WERKS

SMENG

ARBID

RUECK

RMZHL

VORNR

LTXA1

GRUND

STOKZ

STZHL

AENAM

AUERU

EXNAM

AUFPL

APLZL

ISM01

ILE01

ANZMA

RMNGA

XMNGA

extid

stzhl

GMEIN

LMNGA FROM AFRU

INTO TABLE i_AFRU

FOR ALL ENTRIES IN i_afpo

WHERE aufnr EQ i_afpo-aufnr AND

BUDAT IN ZDAT AND

ISDD IN ZEDAT AND

GRUND IN ZLINE AND

WERKS IN ZPL.

ENDIF.

Thanks in advance.

Regards

Rajaram

Re: Query Error

Former Member — Thu, 31 Jan 2008 03:42:11 GMT

Hi,

place this code before if statement and try

sort i_afpo by aufnr.

delete adjacent duplicates from i_afpo comparing aufnr.

Regards

Re: Query Error

Former Member — Thu, 31 Jan 2008 04:12:48 GMT

still its not working fine yar.,

Re: Query Error

former_member156446 — Thu, 31 Jan 2008 04:18:01 GMT

Hi Rajaram


sort i_afpo by aufnr.
delete adjacent duplicates from i_afpo comparing aufnr.

IF i_afpo[] IS not INITIAL.

SELECT AUFNR BUDAT ISDD WERKS SMENG ARBID RUECK
RMZHL VORNR LTXA1 GRUND STOKZ STZHL AENAM AUERU
EXNAM AUFPL APLZL ISM01 ILE01 ANZMA RMNGA XMNGA
extid  stzhl GMEIN LMNGA 
FROM AFRU
INTO TABLE i_AFRU
FOR ALL ENTRIES IN i_afpo
WHERE aufnr EQ i_afpo-aufnr AND
BUDAT IN ZDAT AND
ISDD IN ZEDAT AND
GRUND IN ZLINE AND
WERKS IN ZPL.
ENDIF.

in i_afpo try to get RUECK RMZHL and the change the condition as

....
...
..
LMNGA FROM AFRU
INTO TABLE i_AFRU
FOR ALL ENTRIES IN i_afpo
WHERE aufnr EQ i_afpo-aufnr AND
RUECK  EQ i_afpo-RUECK and 
RMZHL  EQ i_afpo-RMZHL and  
BUDAT IN ZDAT AND
ISDD IN ZEDAT AND
GRUND IN ZLINE AND
WERKS IN ZPL.
ENDIF.

if its not possible its okay for ur query to take long time.. becoz ur not using any of the key fields from the table....

when ever you pick and option to use a table.. u need to make sure you have some key field with u....

Re: Query Error

Former Member — Thu, 31 Jan 2008 04:55:46 GMT

If poosible, try to use inner join istead of for all entries. Inner Join should improve your perfomance.

Re: Query Error

Former Member — Thu, 31 Jan 2008 05:01:48 GMT

Hi,

I usally look for index in that table.If index exist i will give the where option in the index order

For eg: if the index is BUADT WERKS AUFNR

i will give the where option like BUDAT = ' ' and WERKS ' ' and aufnr = ' '.

The other way is give the where condition in the order of the table

in your query you can try in this order

..................where BUDAT IN ZDAT AND

WERKS IN ZPL AND

GRUND IN ZLINE AND

SDD IN ZEDAT AND

ufnr EQ i_afpo-aufnr.

better create a index ....

Regards,

karthik

Re: Query Error

Former Member — Thu, 31 Jan 2008 05:13:07 GMT

You are correct, i tied like u said, but RUECK,RMZHL fields in Not available in AFPO table.

Its available in AFKO Table, But value is not available in that table.

What can i do, pls advice me.

Re: Query Error

former_member156446 — Thu, 31 Jan 2008 05:20:18 GMT

Functional consultants are there to help us when we are stuck with such sort of issues.. if you have one, get him..

RUECK data element CO_RUECK

RMZHL data element CO_RMZHL

hit a where used list with the data element and see what other tables have this .. and find out if anything you can use of those list... you will get a very big list.. all the best..

Award points if helpful.