Skip to Content
avatar image
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 empty...no values.

Please advise.

Sanjay

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2008 at 05:29 PM

    Hi,

    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.

    BR

    Csaba

    Add comment
    10|10000 characters needed characters exceeded