I am developing a customer consignment stock report.
The problem which i am facing the client requirement is consignment stock with deliveries.
It should match with mb51 stock, the problem is some of material documents are not having deliveries.
Please help me if anybody knows business logic.
I think MKPF, MSEG contains the material documents from all area and so not all the documents will correspond to a outbound delivery.
Also, I think you are talking about customers so it should be outbound delivery.
MSEG will contain lot many other type of material documents as well.
Do other way round.
I think you should rather first select the deliveries from LIKP & LIPS and then try to get the corresponding material document details from MKPF & MSEG.