on 12-06-2005 1:04 PM
How to use virtual characteristics in MultiCube? Here is the code I implemented but the query is not detecting user exit. I looked at query's tecnical information (rsrt) and there it shows that the query does not have any Virtual Char./Key Figures.
Virtual characteristic name is: SG_RCSSN used in SG_M_RC1 MultiCube. Data providers of MultiCube are InfoCube and ODS. I assigned virtual characteristic to a dimension, and did 'Identifications' ( --> InfoCube) for that characteristic.
PS. I did the same for basic InfoCube and it worked, but for MultiCube did not.
________________
Include ZXRSRU02
________________
DATA: L_S_CHANM TYPE RRKE_S_CHANM.
CASE I_S_RKB1D-INFOCUBE.
when 'SG_M_RC1'. "RCCP
l_s_chanm-mode = rrke_c_mode-read.
l_s_chanm-chanm = 'SG_ASGRP'. append l_s_chanm to e_t_chanm.
l_s_chanm-chanm = 'SG_SELUNT'. append l_s_chanm to e_t_chanm.
l_s_chanm-chanm = 'SG_FDF'. append l_s_chanm to e_t_chanm.
l_s_chanm-chanm = 'SG_SPR'. append l_s_chanm to e_t_chanm.
l_s_chanm-chanm = 'SG_RCSSAG'. append l_s_chanm to e_t_chanm.
l_s_chanm-mode = rrke_c_mode-no_selection.
l_s_chanm-chanm = 'SG_RCSSN'. append l_s_chanm to e_t_chanm.
ENDCASE.
________________
Include LXRSRTOP
________________
data: g_pos_SG_M_RC1_SG_ASGRP type i.
data: g_pos_SG_M_RC1_SG_SELUNT type i.
data: g_pos_SG_M_RC1_SG_FDF type i.
data: g_pos_SG_M_RC1_SG_SPR type i.
data: g_pos_SG_M_RC1_SG_RCSSAG type i.
data: g_pos_SG_M_RC1_0calyear type i.
data: g_pos_SG_M_RC1_SG_RCSSN type i.
________________
Include ZXRSRZZZ
________________
form user_SG_M_RC1 using i_s_rkb1d type rsr_s_rkb1d
changing c_s_data type any.
*tables: /BIC/QSG_RCSAGS.
field-symbols <l_SG_ASGRP>.
field-symbols <l_SG_SELUNT>.
field-symbols <l_SG_FDF>.
field-symbols <l_SG_SPR>.
field-symbols <l_0calyear>.
field-symbols <l_SG_RCSSAG>.
field-symbols <l_SG_RCSSN>.
break-point.
assign component g_pos_SG_M_RC1_SG_ASGRP
of structure c_s_data to <l_SG_ASGRP>.
assign component g_pos_SG_M_RC1_SG_SELUNT
of structure c_s_data to <l_SG_SELUNT>.
assign component g_pos_SG_M_RC1_SG_FDF
of structure c_s_data to <l_SG_FDF>.
assign component g_pos_SG_M_RC1_SG_SPR
of structure c_s_data to <l_SG_SPR>.
assign component 1
of structure c_s_data to <l_0calyear>.
assign component g_pos_SG_M_RC1_SG_RCSSAG
of structure c_s_data to <l_SG_RCSSAG>.
assign component g_pos_SG_M_RC1_SG_RCSSN
of structure c_s_data to <l_SG_RCSSN>.
zyear = <l_0calyear>.
concatenate zyear '0101' into zcalday.
select * from /BIC/QSG_RCSAGS
where /BIC/SG_ASGRP eq <l_SG_ASGRP>
and /BIC/SG_RCSAGS eq <l_SG_RCSSAG>
and /BIC/SG_SELUNT eq <l_SG_SELUNT>
and /BIC/SG_FDF eq <l_SG_FDF>
and /BIC/SG_SPR eq <l_SG_SPR>
and OBJVERS eq 'A'
and /BIC/SG_RCSSN ne ''
and DATETO ge zcalday
and DATEFROM le zcalday.
exit.
endselect.
if sy-subrc eq 0.
<l_SG_RCSSN> = /BIC/QSG_RCSAGS-/BIC/SG_RCSSN.
else.
<l_SG_RCSSN> = <l_SG_RCSSAG>.
endif.
endform.
hi,
do you have the query before without the virtual characteristics ?
try to check if the latest version of zxrsr* is active,
try to deactivate and activate the project (cmod),
rsrt and delete the query cache, and re-generate the query then check again the technical info.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
so your multicube is called 'SG_M_RC1', isn't it?
If yes, I would recommend to run the query in rsrt. Before running it, generate the query.
regards
Siggi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.