Making select statement efficient

[Former Member]

Can any one suggest how to make this below statement efficient? It is taking quite a long time to run, wht could be the reasons.

SELECT pbim_{bedae pbim}versb pbim_{pbdnr pbim}matnr pbim~werks

pbed_{pdatu pbed}plnmg pbed~meins

pbed~aenam

FROM pbim

INNER JOIN pbed ON pbed_{bdzei = pbim}bdzei

INTO TABLE I_IDEMAND

WHERE pbim~werks IN wa_plantsel

AND EXISTS ( SELECT matnr FROM mara

WHERE matnr = pbim~matnr

AND lvorm = '' )

AND EXISTS ( SELECT matnr FROM marc

WHERE marc_{matnr = pbim}matnr

AND marc_{werks = pbim}werks

AND marc~lvorm = '' )

AND pbim~vervs = 'X'

AND pbed~plnmg > 0 .

[Former Member]

first break the Join ,

first get MATNR from MARA+MARC , then go for Planning data.

Regards

Prabhu

[Former Member]

Hi,

1. First of all the sequence of fields in select query for PBIM & PBED table should be same as database table.

2. First select the data from mara & marc the fetch data from pbim.

This should solve ur performnace problem .

Regards

Kapil

[Former Member]

hi

good

use CORRESPONDIG FIELDS OF TABLE statement and see the difference.

thanks

mrutyun