Page 1 of 1

Help with Stock report

Posted: Tue Dec 20, 2016 9:31 am
by rpinxt
Ok, we have stock with and stock without batch.

Now I made a report based on general stock tables and if there was a batch then take the Q from MCHB otherwise take it from MARD.
Worked fine and comparing it to standard report looked also promising.

However one of the differences turned out to be consignment stock.
Thought it would be easy to get this is from MSKU table.

However where MCHB and MARD have MATNR/WERKS/CHARG/LGORT does MSKU have to storage location (LGORT).

So for the special stock lines I now have double entries (ie 13 because 1 material shows 13 times in MARD).
Instead of 5 consignment units it shows 65 units.

Anyway to fix this?

Re: Help with Stock report

Posted: Wed Dec 21, 2016 5:34 am
by Gothmog
The consignement stock is not in any storage location - it's at the customer's.
You could add the entries of MSKU to your internal table with an empty storage location, I guess.

But if you're looking for an easy table join in a query, well... not so easy, you'll have to code.