topic Re: performance over join.. in Application Development and Automation Discussions

performance over join..

Former Member — Mon, 24 Nov 2008 06:23:12 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: performance over join..

Former Member — Mon, 24 Nov 2008 08:52:05 GMT

Hi,

Your first select statement is not used index.I think others are using index.So, check all select statement are using index or not.Your code good other than index problem.

Re: performance over join..

Former Member — Mon, 24 Nov 2008 09:24:34 GMT

Hi,

Check for not initial condition of internal tables before your select statements which use "For all entries in" , else if its initial, its going to pick up the complete table entries.

Shruthi

Re: performance over join..

ThomasZloch — Mon, 24 Nov 2008 10:06:36 GMT

> AND A~KUNAG IN S_CUST

How selective is S_CUST typically? If only one or few values, try selecting VRKPA by KUNDE etc. and joining VBRK and VBRP.

Thomas

Re: performance over join..

Former Member — Thu, 27 Nov 2008 06:14:18 GMT

Hi,

Use for all entries rather than join.

Tks,

Krishna...

Re: performance over join..

ThomasZloch — Thu, 27 Nov 2008 08:26:16 GMT

> Use for all entries rather than join.

How exactly would that help?