Skip to Content
0
Former Member
Jan 14, 2008 at 01:50 PM

Urgent: Regarding Inner join relation b/w MSEG, MKPF, MARA and MAKT

1342 Views

I have written o code like below for inner join. However, The program has take much more time to give out put. Could any one please correct the below inner join statement. Its very urgent.

Thanks for your help.

SELECT mseg~mblnr

mseg~matnr

mseg~werks

mseg~charg

mseg~lifnr

mseg~bualt

mseg~erfmg

mseg~ebeln

mseg~ebelp

mkpf~budat

mara~zzshelf_life

makt~maktx

FROM mseg

INNER JOIN mkpf

ON mkpfmblnr EQ msegmblnr

INNER JOIN mara

ON msegmatnr EQ maramatnr

INNER JOIN makt

ON maramatnr EQ maktmatnr

INTO TABLE gt_mat_doc

WHERE mseg~matnr IN s_matnr

AND mseg~werks IN s_werks

AND mseg~lifnr IN s_lifnr

AND mseg~bwart EQ p_bwart

AND ( msegebeln NE ' ' AND msegebeln IN s_ebeln )

AND mkpf~budat IN s_budat

AND mara~mtart IN s_mtart

AND makt~spras EQ sy-langu.