Skip to Content
0
Former Member
Jun 02, 2009 at 09:58 AM

Fetching materials on basis of Division creating perfomance problem

38 Views

Hi Experts,

i am fetching Data from three table like

select a~matnr a~extwg
b~charg b~werks b~clabs b~cspem b~cinsm
c~vfdat
from mara as a join mchb as b
on a~matnr = b~matnr join mch1 as c on b~matnr = c~matnr  and b~charg = c~charg
into table  itab_main
where  a~spart = p_spart and b~werks = p_werks
and b~lgort = 'FG01' . 

it is creating perfomance problem

so my questin is 'is there any index table for mara ?(like vrpma for vbak)'

so we can get all the material on base of division fast.

Regards,

Alpesh

Edited by: Alpesh on Jun 2, 2009 3:56 PM