Skip to Content
author's profile photo Former Member
Former Member

Bin Counting report

Hi Friends,

Need a small advice from you. I am trying to build a report that gives the list of bins not counted within a date range.

Logic: Pull the list of bins for which no Inventory record exists with in the date rane( Last inventory date) . But, The tables LINV, LAGP does not get populated if the Inventory record field is values.

Please advise.


Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Aug 22, 2008 at 05:29 PM


    If you only want to get the list of the bins for which no inventory document was created why are you trying to use LINV-LAGP?

    I think LAGP should be enough.

    Using table LAGP I defined a date range and I also set that I want the rcords outside this range. Records with 00.00.0000. were also provided by SAP.

    Please try it (SE16+LAGP instead of building a report)

    If you want to use several tables in your query please take care of the joint type. Maybe 'left outer joint' will solve your problem.



    Add comment
    10|10000 characters needed characters exceeded