Skip to Content
0
Former Member
Oct 13, 2006 at 05:37 AM

To get the material document without using VBFA.

67 Views

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 avbeln = bmblnr

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.