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.