Storage bin report

[Former Member]

End of the last shift, the warehouse shift manager wants following report to transfer remaining stock from floating storage bin to assigned storage bin if the material has, to keep the maximun floating bin available for next day picking...........

=> List of floating bins having no open transfer order and available stock in that bin + assigned storage bin if that material has in material master (MM03 warehouse management 2 view) and stock available in assigned storage bin + Maximum bin quantity (MM03 warehouse management 2 view)

Please suggest solution.

Regards,

Ashish

[csaba_szommer]

Hi,

It not totally clear what you want, but you are likely to have to go to development...

Following data tables may be used:

LAGP (storage bin):

- LAGP-SKZSE, LAGP_SKZSI --> show whether there are open TO for the bin

- LAGP-LGEWI --> capacity of storage bin

- LAGP_RKAPV --> available capacity of storage bin

- LAGP-MGEWI --> eweight of materials in storage bin

LQUA (quant)

- LQUA-SKZSE, LQUA_SKZSI --> show whether there are open TO for the quant

- etc

MLGN (material master, warehouse level)

MLGT (material master storage type level)

You may face some difficulties:

- if you use SUM --> number of SU may be limited for one bin (so, capacity is one thing and this is another, additionally)

- fixed bin: you may define fixed bin for several storage types --> are you going to display all of them? Based on what?

- etc

Regards,

Csaba

Edited by: Csaba Szommer on Mar 6, 2010 1:46 PM