topic Re: To get the material document without using VBFA. in Application Development and Automation Discussions

To get the material document without using VBFA.

Former Member — Fri, 13 Oct 2006 05:37:37 GMT

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.

Re: To get the material document without using VBFA.

Former Member — Fri, 13 Oct 2006 06:27:48 GMT

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

Re: To get the material document without using VBFA.

Former Member — Fri, 13 Oct 2006 07:03:34 GMT

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.

Re: To get the material document without using VBFA.

Former Member — Fri, 13 Oct 2006 13:44:33 GMT

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

Rob

Re: To get the material document without using VBFA.

Former Member — Fri, 13 Oct 2006 14:42:12 GMT

Hi,

use mkpf-xblnr in below logic

SELECT mblnr

mjahr from mkpf

INTO TABLE t_vbfa_mkpf

where xblnr EQ '1234'.

Regards

amole