To get the material document without using VBFA.

[Former Member]

I have the following query but this is creating some performance issue since VBFA table is very huge.

SELECT b~mblnr

b~mjahr

INTO TABLE t_vbfa_mkpf

FROM vbfa AS a

INNER JOIN mkpf AS b

ON a_{vbeln = b}mblnr

WHERE vbelv EQ '1234'

AND vbtyp_n EQ 'R'

AND vbtyp_v EQ 'T'.

Can somebody suggest an alternate way to get the Material Document Number & Material Document Year.

[Former Member]

You might add the fiscal year to the join condition, but other than that, I don't see any problem.

Rob

[Former Member]

Hi

One more way is to go directly to MKPF with key XBLNR = '1234' i.e delivery number, maybe restricting with document type and if any possible other conditions.

Am not sure if this is really going to help you.

Kind Regards

Eswar

[Former Member]

I think that querying MKPF by XBLNR in not a good idea. The table is not indexed on this feild.

The MKPF table has more than 5 million entries.

[Former Member]

You might add the fiscal year to the join condition, but other than that, I don't see any problem.

Rob

[Former Member]

Hi,

use mkpf-xblnr in below logic

SELECT mblnr

mjahr from mkpf

INTO TABLE t_vbfa_mkpf

where xblnr EQ '1234'.

Regards

amole