Select - MKPF x MSEG

Hi!

I'm with a problem in a selection of mkpf and mseg tables. I need to select some period of MKPF (i'm using the field budat) and after, select the MSEG table (of some materials).

I tried many diferent commands such as "Inner join" and "for all entries". In the case of "for all entries", the program blocked the mseg table many times and in the case of "inner join", the cost wasn't very good ... I had the help of a DBA Oracle, too. But when I wrote the command in ABAP, the execution was terrible !!!!

Somebody in this forum have the same problem any time? Do you know something to help me?

The command that I'm testing now is (after the help of the DBA Oracle):

SELECT a_{mblnr b}mjahr b_{zeile b}matnr b_{werks b}lgort b_{charg b}shkzg b~menge

INTO CORRESPONDING FIELDS OF TABLE t_mseg

FROM mkpf AS a

INNER JOIN mseg AS b ON a_{mblnr = b}mblnr AND

a_{mjahr = b}mjahr

WHERE a~budat IN r_bldat AND

b~matnr IN r_matnr AND

b~werks = l_centro.