Skip to Content
avatar image
Former Member

Link between Material document and Physical inventory document in Warehouse Management

Hi,

I am developing one report for Physical inventory in SAP warehouse Management, I am trying to link between Material document generated from Physical inventory in ware house management.

In LI01 we create a Physical Inventory document, and then count in LI11 and then post the differences in LI21.

When we create a document in Physical inventory , it creates entry in LINK and LINV. When you clear it through LI21, it creates a Material document for the difference qty and amount.

These are saved under IKPF and ISEG.

But common fields are "Material, Plant, Storage location and Batch". however when you create a report with these fields , system will fetch more data. Even you filter with movement type 7* we may end up with many document.

My question is there any link for unique field "IVNUM" to material document or any other unique identifier for physical invetory docuemnt generated through WM to corresponding material document.

Your answer to this will be highly appreciated and acknowledged.

Thanks & Regards

Sudhansu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 31, 2013 at 06:34 PM

    You can plug IVNUM value in MSEG-LGPLA field to get a corresponding IM material document for the WM PID. LGTYP obviously be '999'.


    Hope this helps~

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Eddi,

      Thanks for writing for this post.

      Question is how to link with MSG entry and LINV or LINK.

      LGTYP is "999" in MSEG, and LGPLA is coming some number. What are those number ? Do you have any idea.?

      Again for LGTYP "999" in MSEG the LGTYP in LINV is different .

      requirement is to establish the link.

      If any suggestion , kindly revert.

      Thanks & Regards

      Sudhansu

  • Jan 01, 2014 at 02:30 PM

    Hi Sudhansu

    if i have to write the FS/ TS then i will first pick the unique record (MSEG-MBLNR  & MESG-LGPLA) from the MSEG table for all the movement type. This will provide me the material document number against the WM physical inventry document number and  then i will set the relation of MSEG-MBLNR with ISEG-IVNUM to get the detail of the material batch and qty.

    The above statment is just a thought, if u can share what exactly you want to fetch/ display in your report then we can provide some more information

    Happy New Year 2014

    Cheers

    Manish kumar

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sudhanshu,

      Without knowing the system configuration it is very difficult to tell you what are those number.

      Just a hunch.might be helpful to track what are those number.

      Check the setting Under

      IMG--LE---WM---ACTIVITIES ----Define movement tyoe

      Check what it the setting for source and Destination storage type /bin maintainted for Movment type 711/712

      Cheers

      Manish

  • Jan 02, 2014 at 12:19 PM

    I actually think you cannot get a 100% relation

    It depends pretty much on your customizing for the movement types, whether you are using dynamic coordinates or fixed coordinates.

    Only in case you use dynamic coordinates and those are defined as storage bin, then you can achieve it as explained above.

    But there are usually much more differences posted via the difference storage type 999, it is not only a physical inventory.

    You can as well have differences from normal TOs, where you found a difference while picking.

    and the customizing in OMLX is different from the setting for the 711 - 718 movement types regarding the coordinate. In any case you would not find an inventory document in table ISEG for such differences  which are posted as well with 711-718 movement types in inventory management.

    Add comment
    10|10000 characters needed characters exceeded