on 2006 Apr 03 5:56 PM
Hi Guys,
Am i right if i say, The Non-cumulative key figure '0VALSTCKVAL - Value of valuated stock' is calculated from '0ISSVS_VAL - Value issued from valuated stock' and '0RECVS_VAL - Value Received into Valuated Stock' at query run-time.
If so, on what basis (any formula) is the 0VALSTCKVAL calculated?
Regards
Hi George,
Didnt get your question exactly.
Isnt the formula 'Difference of Value Issued and Value Received' as you have already stated?
You will need to check how value issued and value received are being calculated in the source system.
cheers,
Vishvesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Closing an old question.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The Non-cumulative key figure '0VALSTCKVAL - Value of valuated stock' is calculated from '0ISSVS_VAL - Value issued from valuated stock' and '0RECVS_VAL - Value Received into Valuated Stock' at the time of Compression.
So If there in no compression for the request then the value is calculated at the time of query execution.
With rgds,
Anil Kumar Sharma .P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Guys,
Thanks for the response. I understand that the non-cumulative key figure is calculated at query run time.
What i am not aware is if there is any formula for calculating 0VALSTCKVAL from the 2 cumulative key figures -
1. '0RECVS_VAL - Value Received into Valuated Stock'
2. '0ISSVS_VAL - Value issued from valuated stock'
What exactly is the formula for calculating the non-cumulative key figure.
Regards
Hi,
0VALSTCKVAL is also a Non cumulative KF.
0RECVS_VAL is the 'Inflow' object for 0VALSTCKVAL
0ISSVS_VAL is the ;'Outflow' Object for 0VALSTCKVAL
<i>I understand that the non-cumulative key figure is calculated at query run time.</i>
This is not true in all cases, this is true only if there is any request which is not yet compressed.
With rgds,
Anil Kumar Sharma .P
Hi,
Yes, you are right. If all requests in the inventory cube are not yet compressed, then the 'stock value' will be evaluated at the time of query execution.
If all requests in the inventory cube are compressed, then the 'stock value' is already available in the cube.
Inflow and Outflow:
http://help.sap.com/saphelp_nw04/helpdata/en/82/f2dc37f0f12313e10000009b38f8cf/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/80/1a62dee07211d2acb80000e829fbfe/frameset.htm
With rgds,
Anil Kumar Sharma .P
Hi Anil,
Can you clarify your point?
<i>Yes, you are right. If all requests in the inventory cube are not yet compressed, then the 'stock value' will be evaluated at the time of query execution.
If all requests in the inventory cube are compressed, then the 'stock value' is already available in the cube.</i>
I was of the assumption that when all the requests in the inventory cube ARE COMPRESSED, then 'stock value' will be evaluated at the time of query consumption.
Because, in our inventory cube, there are few COMPRESSED REQUESTS and i cannot see any column for 'stock value' (0VALSTCKVAL) in the contents of the cube.
Regards
Message was edited by: George Smith
Hi,
Those Kf are not available in the Cube content.But still I feel the stock values are stored some where in the BW system only.
SAP says:
<i>Technically, non-cumulatives are stored using a marker for the current time (current non-cumulative) and the storage of non-cumulative changes, or inflows and outflows. The current, valid end non-cumulative (to 12.31.9999) is stored in the marker. You can determine the current non-cumulative or the non-cumulative at a particular point in time. You can do this from the current, end non-cumulative and the non-cumulative changes and/or the inflows and outflows.
Queries for the current non-cumulative can be answered very quickly, since the current non-cumulative is created as a directly accessible value. There is only one marker for each combination of characteristic values that is always updated when the non-cumulative InfoCube (InfoCube that includes the non-cumulative key figures) is compressed. So that access to queries is as quick as possible, compress the non-cumulative InfoCubes regularly. (See Compressing InfoCubes) to keep the marker as current as possible.</i>
The above para says,if we do compression ( of all requests) then there is no need of calculating <i>Stock</i> at the time of query execution.
i.e some where in the BW the value of Stock is stored.
http://help.sap.com/saphelp_nw04/helpdata/en/80/1a62dee07211d2acb80000e829fbfe/frameset.htm
With rgds,
Anil Kumar Sharma .P
Hallo anil.
I am done with the kompression of all the datasources ie BX, BF and UM as per HOW TO INVENTORY doc.
as per your last reply <i>" if we do compression ( of all requests) then there is no need of calculating Stock at the time of query execution."</i>
so now i dont need to do any kalculation on my own using the Non cumulative KF <i>0CPTOTSTOBU (Last Valuated Stock Total/BUn)</i>
inflow <i>0CPTSTREBU (Receipts to Valuated Stock Total / BUn)</i> and outflow <i>0CPTSTISBU (Issues from Valuated Stock Total / BUn')</i>
Now in report when i use KF 0CPTOTSTOBU(noncumulative), 0CPTSTREBU (inflow) and 0CPTSTISBU (outflow)
my result is -10KG, BLANK and BLANK respectively
Is there anything I am doing wrong.
I want to kalkulate the opening and closing stock value. could you pls tell me howto get these? I am bit konfused with the concept!!!!
Inputs plssssss......
User | Count |
---|---|
79 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.