I need to create a query with sales invoice number, material code, sales price, quantity, amt in local currency.
The problem right now is the list displays all material document including that the outbound delivery was cancelled. Thus, if the user did outbound delivery followed by cancelling outbound and redoing outbound delivery, 3 duplicated information with different material document number is displayed.
So, the solution I am thinking about is to link the delivery document number in VBRP and MKPF. However, the system doesn't allow me to do that.
Currently I am using VBRK, VBRP, MSEG, and MKPF for the tables.
Any suggestions welcomed.