on 06-16-2015 4:11 PM
Hi,
I have a real time DSO using one key figure, one time characteristic and 2 data fields.
The data fields are a characteristic and a key figure. I select the option to use the characteristic as key figure.
The aggregation level is,
The FOX code used in planning function to change the values is,
ZFISCPER TYPE 0FISCPER.
DATA ZFISCPER2 TYPE 0FISCPER.
DATA ZCOMPC TYPE ZCOMPCODE.
DATA ZCOMPC2 TYPE ZCOMPCODE.
DATA ZFISCVAR TYPE 0FISCVARNT.
DATA K_SITEFLAG TYPE F.
CLEAR K_SITEFLAG.
*Formula variable to capture Flag value
K_SITEFLAG = VARV(ZVAR_SITEFLAG).
*Fiscal Variant
ZFISCVAR = Z1.
*Fiscal period selected
ZFISCPER = VARV(ZVAR_PREVFPER).
*Site selected in Dashboard
ZCOMPC = VARV(ZVAR_CC_INP).
FOREACH ZFISCPER2, ZCOMPC2.
IF ZFISCPER2 = ZFISCPER AND ZCOMPC2 = ZCOMPC.
{1KYF_0BBP_FLAG,ZFISCPER,ZFISCVAR,ZCOMPC} = K_SITEFLAG.
{0NUMDAY,ZFISCPER,ZFISCVAR,ZCOMPC} = K_SITEFLAG.
ENDIF.
ENDFOR.
The filter is restricted by the variables,
0FISCPER Fiscal year / period @QQ\QIncluded Variable Value@ var:ZVAR_PREVFPER
0FISCVARNT Fiscal year variant @20\QSelect: Equal to@ Z1
ZCOMPCODE Company code @QQ\QIncluded Variable Value@ var:ZVAR_CC_INP
The data set is,
When I test the planning sequence for period 005.2015 and company code 1100, it shows the following,
I am unable to understand how the Indicator(0bbp_flag) column is fetching the value 3.
I think it is aggregating the data in a different way than the key figure as it is a characteristic used as a key figure.
The key figure is working as expected and always saving the new value entered using the formula variable.
But, the characteristic is causing and error and short dump related to SID not found with the above design.
Thanks for any hints to solve the issue.
Raja.
Hi Raja,
the feature 'characteristics as key figures' is only supported in some planning function types, cf.
Planning Functions - Planning Business Data with BW Integrated Planning - SAP Library
The reason is that the characteristics are exposed as artificial key figures (characteristics are represented as SID) and thus all kind of computations with this artificial key figures make no sense. FOX is not supported here.
Regards,
Gregor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.