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

No stock showing in Inventory on date stock report

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....

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2009 at 10:08 AM

    Give Lessthan or equal to option for 0Calday varialble.

    It will work.

    Guru.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 21, 2009 at 06:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Daya Sagar Dasari

      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

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2009 at 06:44 AM

    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....

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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....

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2009 at 10:12 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.