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

Query on cube 0IC_C03 with Non cumulative & cumulative keyfigure together

Hi

My problem goes like this

Im writing a query on cube 0IC_C03:Material Stocks/Movements (as of 3.0B) with both non cumulated keyfigure (0VALSTCKVAL)& Cumulative keyfigure(0RECVS_VAL) together with characteristics being Plant,calender month & material. All records are shown properly with values if I select for a Plant. But if a I make selection on Material, query returns a row with value for cumulative key figure only. Non cumulative keyfigure doesn't show up.

Any reason for this behaviour?

Thanks & Regards

Padmanabh

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2006 at 04:26 AM

    Padmanabha

    Check the aggregation & cumulative properties of Non-cumulative key figure 0VALSTCKVAL. For this key figure inflow is defined as 0RECVS_VAL(cumulative ) & outflow is defined as 0ISSVS_VAL .

    When you drilldown on Material , maybe this propery is imapacting the display of no-cumulative key figure.

    Hope this helps

    Regards

    Pradip

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2006 at 04:59 AM

    Hi Rao ,

    0VALSTCKVAL is a non cumulative key figure with exeception aggregation as 'Last Value'. Go to the change mode of the cube 0IC_C03 select the menu : Extras

    ->Maintain Non cumulative values -> See if the plant is also characteristic of the validity table . That might be the reason Non cumulative keyfigure doesn't show up if you do not select plant.

    Please refer below link for more information

    http://help.sap.com/saphelp_sem40bw/helpdata/en/02/9a6a1c244411d5b2e30050da4c74dc/content.htm

    Regards,

    Prakash

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      thanks for quick replies.

      Plant is not maintained in the validity table. Also

      if I remove the cumulative keyfigure from the query, selection using material works for non cumulative key figure. Problem exists obly when I have both noncumulative & cumulative together and I make selection on material

      regards

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.