performance over join..

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[ThomasZloch]

> 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

[Former Member]

Hi,

Use for all entries rather than join.

Tks,

Krishna...

[ThomasZloch]

> Use for all entries rather than join.

How exactly would that help?