topic Re: perfromance tuning.. in Application Development and Automation Discussions

perfromance tuning..

Former Member — Mon, 24 Nov 2008 06:31:48 GMT

me using these three select

this taking hell lot of time.. any ways to improve these..

for all entries taking more then tht.. so please dont suggest tht.

its critial issue help me out..

SELECT B_{WERKS A}VBELN B~MATNR

A_{FKDAT A}SPART A_{VTWEG A}ERDAT A~ERZET

B_{VGBEL B}AUBEL

A~FKART "Added by Arun pandey 08/05/2007

B_{NETWR B}FKIMG B~MWSBP

FROM VBRP AS B

JOIN VBRK AS A ON A_{VBELN = B}VBELN INTO TABLE IT_INV

WHERE A~FKART IN S_FKART

AND ( A_{SPART IN S_SPART AND A}SPART 'ST' )

AND A~FKDAT IN S_FKDAT

AND ( A_{VTWEG IN S_VTWEG AND A}VTWEG 'ST' )

AND A~FKSTO 'X'

AND A~KUNAG IN S_CUST

AND B~WERKS = S_WERKS.

SELECT A_{VBELN B}POSNR B_{MATNR B}VGBEL A_{KUNNR A}ERDAT A~ERZET

A_{LFDAT B}LFIMG

FROM LIKP AS A JOIN LIPS AS B ON A_{VBELN = B}VBELN

INTO TABLE IT_DELV

FOR ALL ENTRIES IN IT_INV

WHERE A~VBELN = IT_INV-VGBEL

AND B~MATNR = IT_INV-MATNR.

SELECT A_{VBELN A}BSTNK A_{AUART A}KUNNR

A_{VKBUR A}VKGRP B_{NAME1 B}ORT01

FROM VBAK AS A JOIN KNA1 AS B ON A_{KUNNR = B}KUNNR

INTO TABLE IT_ORDER

FOR ALL ENTRIES IN IT_DELVHEAD

WHERE A~VBELN = IT_DELVHEAD-VGBEL.

Re: perfromance tuning..

GauthamV — Mon, 24 Nov 2008 06:38:43 GMT

hi,

1. try to use as many key fields as possible in select statement.

2. use secondary index for those tables.

also check the statements using different key combinations using se30 or st05 transactions.

Re: perfromance tuning..

Former Member — Mon, 24 Nov 2008 06:43:03 GMT

Hi,

For your query,

Try giving as many primary keys in where condition as possible.

IF still not problem solved then try using indexes.

this will help you out.

Thanks & Regards

Re: perfromance tuning..

Former Member — Mon, 24 Nov 2008 06:43:30 GMT

Hi,

Before using for all entries :

1. Check whether the table is initial or not.

IF NOT IT_INV[] IS INITIAL.
SELECT A~VBELN B~POSNR B~MATNR B~VGBEL A~KUNNR A~ERDAT A~ERZET
A~LFDAT B~LFIMG
FROM LIKP AS A JOIN LIPS AS B ON A~VBELN = B~VBELN
INTO TABLE IT_DELV
FOR ALL ENTRIES IN IT_INV
WHERE A~VBELN = IT_INV-VGBEL
AND B~MATNR = IT_INV-MATNR.
ENDIF.

Thanks & Regards,

Navneeth K.

Re: perfromance tuning..

Former Member — Mon, 24 Nov 2008 06:50:02 GMT

Hi,

before using for all entries

check if not itab[] is intial.

this is mandatory.

Thanks & Regards,

Sudheer

Re: perfromance tuning..

Former Member — Mon, 24 Nov 2008 06:51:14 GMT

Hi,

I encounter the performance issues of extracting SD tables, and I solved the puzzle using FOR ALL ENTRIES statement.

E.g.


* Define driver table from VBRK
SELECT VBELN FKSTO ....
     INTO TABLE TA_VBRK
     FROM VBRK
   WHERE VBELN IN SO_VBELN....

IF SY-SUBRC = 0.

* Extract Item entries based on Driver Table 
SELECT VBELN POSNR  ....
     INTO TABLE TA_VBRP
     FROM VBRP
FOR ALL ENTRIES IN TA_VBRK
   WHERE VBELN = TA_VBRK-VBELN
        AND FKIMG GT 0.

ENDIF.

Hope the above helps.

Regards,

Patrick