Help with Stock report

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Post Reply
Posts: 146
Joined: Mon Jul 23, 2012 8:02 am

Help with Stock report

Post by rpinxt » Tue Dec 20, 2016 9:31 am

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?

Posts: 1955
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: Help with Stock report

Post by Gothmog » Wed Dec 21, 2016 5:34 am

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.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67

Post Reply