cancel
Showing results for 
Search instead for 
Did you mean: 

No stock showing in Inventory on date stock report

Former Member
0 Kudos

Hi

I have created a Stock on date query at plant material level using standard cube 0IC_C03

to get stock quantity on posting date i have restricted 0TOTALSTCK

by 0CALDAY variable .

Correct me if any thing wrong to get on date stock.

When i m executing that report for date 20.07.2009 , it shows 0 qty for a given Plant(1001) and a given material(ABC)

where MB5B report in R/3 with same date show sum stock qty.

again i executed the report with 17.07.2009 , on which the material(ABC) was lastly transacted for that given plant(1001)

for this date i m able to match the qty with MB5B.

Then i check sum other stock report which is at 0CALMONTH level wen executed with 07.2009 shows correct qty.

Now my question is y it is showing 0 qty wen the stock is there in it ? is query definition not proper to get stock on date ?

Thanks and regards,

Sonal....

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Give Lessthan or equal to option for 0Calday varialble.

It will work.

Guru.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi all thanks for ur replies

i was able to resolve the issue using RSDV by maintaining the validity slice for the new plant todate as 31.12.9999

Former Member
0 Kudos

Have you followed the correct steps while loading to 0IC_C03 ?

Are you using 2LIS_03_BX foe Stock Initialization?

Are compressions are done properly?

If you are using BI 7.0 ,then DTP execution for loading 2LIS_03_BX data,

you have to go with Extraction mode as InItial Non Cumulative....

Former Member
0 Kudos

Hi Sujatha,

yes, we are following correct steps to load 0IC_C03

and also doing compression proper as given in How to doc for Inventory management

As per my understand the issue is not with the Cube data as other reports working well for the Same data

but need to correct the query definition as per my requirement to get Stock on a given date..

Need sum inputs on that...

Thanks and regards.

Sonal....

former_member207028
Contributor
0 Kudos

Hi Sonal,

"I have created a Stock on date query at plant material level using standard cube 0IC_C03

to get stock quantity on posting date i have restricted 0TOTALSTCK

by 0CALDAY variable ."

This will restric only values on that particular date, like delta records for that plant on that day.

but need data as on day, so 0TOTALSTCK should not be restricted to date.

in rows, calday, plant materials and in column 0TOTALSTCK.

hope this will give correct results.

Best Regards

Former Member
0 Kudos

Hi

Thanks for ur quick response

If i just place the 0TOTALSTCK in the rows this will fetch stock on date ,that is the stock will be of last date posting date for that material

(correct me if wrong )

But what how should i restrict KF to get the stock for a particular date ?

1 more thing the mismatch is only for a specific plant data thats more confusing .. rest data is correct

Thanks and regards,

Sonal...

Edited by: Sonal Patel on Jul 21, 2009 12:18 PM

Former Member
0 Kudos

You can create offset on calday variable as per your requirement to view the Stock for the no. of days and

place the calday in rows so that you can view the stock for previous days too.

former_member207028
Contributor
0 Kudos

Hi,

No need to restict.

in rows, calday, plant, materials

in column 0TOTALSTCK.

for 2 days data will look like this.

19/07/2009 -- 1001 -- 011235 --- 256 KG

20/07/2009 -- 1001 -- 011235 --- 280 KG

stock as on 19 in MB5B, after recipts and issue is 256 KG.

stock as on 20 th in MB5B, after recipts and issue is 280 KG.

based on issues and recipts, data will be added to total stock.

yes, stock will be last date posting date. as on today we can validate data till yesterday.

one more thing for plant whose values are not matching, did to drill down stock type and stock category and check data.

use RWBE t-code also for validation.

Best Regards.

Former Member
0 Kudos

Hi ,

But if the definition is incorrect then y its showing correct values for other plants

the material is also not transacted for another plants since a month

then also is showing correct qty

with date Restriction on 0TOTALSTCK

1 thing i got to knew that this plant is newly added... is any configuration need to be done when new plants are added in data loading

I have also checked SAP_REFPOINT_COMPLETE but no inconsistency found ?

I checked RSDV for validity and found that plant 1001 has validity till 17.07.2009

How can i modify it ? do i need to reconstruct the cube data ?

Edited by: Sonal Patel on Jul 21, 2009 2:29 PM