That being said, while this approach can get you from a particular Manufacturing Order to the related Journal Entry (Entries), it does not support rapid analysis of high transaction volumes.
The following query links Inventory transactions in the Manufacturing Order Activity table MOP10213 to the Journal Entry information contained in the HITB table SEE30303 - obviously HITB must be deployed for this to work. Additionally, only detail transactions posted after the initialization of the HITB tool will be available for linking.
WHEN 34 THEN 'Issue'
WHEN 38 THEN 'Raw Material Relief'
WHEN 39 THEN 'Finished Good Post'
END AS Reason_Code,
WHEN 1 THEN 'IV Transaction'
ELSE 'Not An Inventory Transaction'
END AS Document_Type,
B.QTYBSUOM*B.TRXQTY AS Quantity,
FROM [MOP10213] AS A
LEFT JOIN IV30300 AS B
ON A.IVDOCNBR = B.DOCNUMBR
Left Join SEE30303 as C
on B.DOCNUMBR = C.DOCNUMBR
WHERE A.DOCTYPE = 1ORDER BY A.MANUFACTUREORDER_I, A.IVDOCNBR