This website is not affiliated with, sponsored by, or approved by SAP AG.

Help with Stock report

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Help with Stock report

Postby 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: 146
Joined: Mon Jul 23, 2012 8:02 am

Re: Help with Stock report

Postby 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
Posts: 1945
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Return to ABAP

Who is online

Users browsing this forum: Majestic-12 [Bot] and 14 guests

This website is not affiliated with, sponsored by, or approved by SAP AG.