Bin Counting report

[Former Member]

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

[csaba_szommer · Accepted solution]

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

[Former Member · Accepted solution]

Hi Csaba,

Thanks for the reply.

I used se16 + LAGP. I put a fate range in the field LAST INVENTORY. Since, no inventory was carried for this bin with in the date range. I go the msg " No table entries found for this key". I did not get any Bin, warehouse no info with inventory field blank. The system is populating the other fields if and only if the inventory record exists with in the date range.

Sanajy

[csaba_szommer · Accepted solution]

Hi,

I am trying to build a report that gives the list of bins not counted within a date range.

1. SE16 + LAGP

2. LAGP-IDATU > 01.01.2008 - 01.08.2008

3. Right mouse click on field 'LAGP-IDATU' > Options > choose 'Outside Range'

4. Lots of bins for which no inventory record exists (I checked in LS03N as well). These records contain 00.00.0000 in LAGP-IDATU

It works fine.

I also checked for records with real date, there was no problem.

Please clarify your question.

Csaba

[Former Member · Accepted solution]

Hi Csaba,

Perfect. Working as I wished for....

Thanks a lot

Sanjay