on 07-21-2009 7:28 AM
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....
Give Lessthan or equal to option for 0Calday varialble.
It will work.
Guru.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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....
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.