TELL ME THE SOLUTION

[Former Member]

SELECT A_{VBELN A}AUDAT A_{VTWEG A}KUNNR B_{POSNR B}MATNR B~KWMENG

B~WAERK

B_{KZWI1 B}KZWI2 B_{KZWI3 B}WERKS B_{PRODH B}CUOBJ

INTO CORRESPONDING FIELDS OF TABLE HEADER

FROM VBAK AS A INNER JOIN VBAP AS B ON A_{VBELN = B}VBELN

INNER JOIN VBUP AS C ON B_{VBELN = C}VBELN

AND B_{POSNR = C}POSNR

WHERE A~VBTYP = 'C'

AND A~VBELN IN VBELN

AND A~AUDAT IN AUDAT

AND B~ABGRU EQ SPACE

AND B~WERKS = PLANT

AND C~GBSTA IN (' ', 'A', 'B').

I WANT TO ANALYZE THIS SELECT STMT AND WANT TO CHAGE FOR BETTER PERFORMANCE

[Former Member]

SELECT A_{VBELN A}AUDAT A_{VTWEG A}KUNNR B_{POSNR B}MATNR B~KWMENG

B~WAERK

B_{KZWI1 B}KZWI2 B_{KZWI3 B}WERKS B_{PRODH B}CUOBJ

INTO CORRESPONDING FIELDS OF TABLE HEADER

FROM VBAK AS A INNER JOIN VBAP AS B ON A_{VBELN = B}VBELN

INNER JOIN VBUP AS C ON B_{VBELN = C}VBELN

AND B_{POSNR = C}POSNR

WHERE A~VBTYP = 'C'

AND A~VBELN IN VBELN

AND A~AUDAT IN AUDAT

AND B~ABGRU EQ SPACE

AND B~WERKS = PLANT

AND C~GBSTA IN (' ', 'A', 'B').

I WANT TO ANALYZE THIS SELECT STMT AND WANT TO CHAGE FOR BETTER PERFORMANCE

[Former Member]

Hi,

For checking the performance: run the below transactions:

ST05 and ST30; you can analyse the data base trace....

Reward if useful

Regards

Shiva

[Former Member]

use se30 and press tips and tricks

use ure select statement and analyze there

for better performance avoid inner joins and use for all entries

Reward IF...............

Regards

Anbu

[Former Member]

Hi,

Are you passing VBELN and AUDAT to the select, i mean they are not empty?

Since u r usign VBUP jus to filter out the data, if the select is not very efficient( i doubt!) try to do it after the select. just check the values C~GBSTA IN (' ', 'A', 'B'), how many records it will fetch.

regards,

madhu

[Former Member]

use ST05 as mentioned in the other questions:

SELECT ....
     INTO CORRESPONDING FIELDS OF TABLE HEADER
     FROM VBAK AS A 
     INNER JOIN VBAP AS B 
     ON A~VBELN = B~VBELN
     INNER JOIN VBUP AS C
     ON B~VBELN = C~VBELN
     AND B~POSNR = C~POSNR
    WHERE A~VBTYP = 'C'
   AND A~VBELN IN VBELN
   AND A~AUDAT IN AUDAT
   AND B~ABGRU EQ SPACE
  AND B~WERKS = PLANT
  AND C~GBSTA IN (' ', 'A', 'B').

check the details (first button) what is really passed to the database, IN Clauses.

VBAK:

MANDT

VBELN

VBAP and VBUP

MANDT

VBELN

POSNR

If this IN Clause A~VBELN IN VBELN is really filled, then it should work fine.

If not, then you have to analyse carefully. It is really a use case?

Siegfried