topic Storage bin range. in Application Development and Automation Discussions

Storage bin range.

Former Member — Tue, 21 Aug 2007 13:23:59 GMT

Hi, everybody, How can i do to obtein the range of storage bin locations, if i have the from storage and the to storage? Regards.

Re: Storage bin range.

former_member194669 — Tue, 21 Aug 2007 13:45:13 GMT

Hi,

Check for fm BAPI_WHSE_STOCK_GET_LIST

aRs

Re: Storage bin range.

Former Member — Tue, 21 Aug 2007 14:32:22 GMT

But i dont have the material, the only data that i have is the lgpla start and lgpla end and i need all the storage bin between them. Regards.

Re: Storage bin range.

Pawan_Kesari — Tue, 21 Aug 2007 14:35:05 GMT

select from table LAGP for given storage location bin

Re: Storage bin range.

Former Member — Tue, 21 Aug 2007 14:41:47 GMT

I dont know how with a starter lgpla and end lgpla i can obtein all the storage locations between them. I find the t343 table but i dont know how to use it.

Re: Storage bin range.

Pawan_Kesari — Tue, 21 Aug 2007 14:51:41 GMT

please try this code ... just replace the value 'TEST1' and 'TEST3' with you start storage location bin and end storage location bin


REPORT zpwtest .

TYPES : BEGIN OF ty_strg,
        lgpla TYPE lagp-lgpla,
      END OF ty_strg.

DATA :  it_strg TYPE TABLE OF ty_strg ,
        wa_strg TYPE ty_strg          .

RANGES : r_lgpla FOR lagp-lgpla .

DATA : from_bin TYPE lagp-lgpla VALUE 'TEST1' ,
       to_bin   TYPE lagp-lgpla VALUE 'TEST3' .

START-OF-SELECTION .

  r_lgpla-sign = 'I' .
  r_lgpla-option = 'BT' .
  r_lgpla-low = from_bin .
  r_lgpla-high = to_bin .
  APPEND r_lgpla .

  SELECT lgpla
    INTO TABLE it_strg
    FROM lagp
   WHERE lgpla IN r_lgpla .

  LOOP AT it_strg INTO wa_strg .
    WRITE : / wa_strg-lgpla .
  ENDLOOP.

Message was edited by:

Pawan Kesari

Re: Storage bin range.

Former Member — Tue, 21 Aug 2007 15:10:52 GMT

Sorry but my knowledge in WM is poor. With this query i obtein the storage bin between the start and end storage bin, but are they the storage bins that i have to visit in a fisic inventory count if have they give me the star storage bin and the end storage bin?

Re: Storage bin range.

Former Member — Mon, 29 Sep 2008 14:39:19 GMT

Answered