on 07-22-2014 9:47 AM
hey all,
i hope you can help me with my requirement:
we're doing a Continuous Inventory and we need a report with all materials in one list, that shows us which material is counted, which is not counted and so on.
is such a report available in SAP?
best regards
christian
Continuous inventory is an inventory method in WM, you distribute the count of all bins over a time span of one fiscal year.
WM inventories are usually focused on bins, not on material. So you are actually completed when you have conducted a count in all bins.
If you want to know which materials have been in that inventories, then you may need to list them from table LINV. You may need another download from table MLGN with all materials in that warehouse, or LQUA with all quants from that warehouse, and then do a VLOOKUP in Excel to know which of those materials was not included in any count.
But you may not find a status update in material master, since the continuous inventory is updating LQUA and LAGP table but not material master tables. Material master is updated in case of inventory management physical inventory.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christian
As far as my experience says we don't have a single report which shows "with all materials in one list, that shows us which material is counted, which is not counted"
I believe the selection screen of LX16 is having few option like "Storage bin that can be counted, only bin not yet counted" however if the requirement is to display in one single report then in my opinion you need to go for custom development.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.