on 2007 Jul 18 1:06 PM
Hi All
I am having problem here i have cteated a text variable on 0company with replacement, its not showing the name or key on the output when i run the qury it showing &ztxtvatc& so what might be the problem........pls can anybody tell me the solution for this and iam working on BI7.0, New version.
Thanks in advance
Srinivas
Hi,
Do you have 0COMPANY in the drilldown of you report?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello ,
You can go for the option of Text variable with customer exit and get the value from master data of the company code provided if you have any user input variable for example business unit etc.
for any given user input variable get the corressponding value of the company code from the master data of company code and populate in to the customer exit variable value.
hope it is clear,
assign points if useful
hi
here is the code
WHEN 'ZTXTCOMP'
IF I_STEP = 2.
LOOP AT I_T_VAR_RANGE INTO LOC_VAR_RANGE WHERE VNAM = 'ZCOMPANY'.
CLEAR L_S_RANGE.
L_S_RANGE-LOW = LOC_VAR_RANGE_LOW.
L_S_RANGE-SIGN = 'I'.
L_S_RANGE-OPT = 'EQ'.
APPEND L_S_RANGE TO E_T_RANGE
END LOOP
END IF
i have some other case statements so i didt put endcase okay
let me know how to get the data from master table.
thanks in advance
sriram
Hello ,
You can try this code, sorry if i am wrong,
DATA: l_value(10) TYPE c,
l_s_comp LIKE /BI0/TCOMPANY,
l_t_comp LIKE /BI0/TCOMPANY OCCURS 0.
WHEN 'ZTXTCOMP'
IF i_step = 2.
LOOP AT i_t_var_range INTO loc_var_range
WHERE vnam = ZCOMPANY'.
SELECT * FROM /BI0/TCOMPANY
INTO l_t_comp
WHERE /BI0/OICOMPANY = i_vnam.
LOOP AT l_t_comp INTO l_s_comp
CLEAR l_s_range.
l_s_range-low = l_s_comp-RSTXTMD.
L_S_RANGE-SIGN = 'I'.
L_S_RANGE-OPT = 'EQ'.
APPEND L_S_RANGE TO E_T_RANGE
END LOOP.
EXIT.
END LOOP.
END IF.
hope it helps,
assign points if useful
Hi,
Is company code restricted with Variable ?? I think it should be restricted with variable . Also is it the case that &ztxtvatc& is written manually ?? It should be added from the list .
Hope that helps.
Regards
Mr Kapadia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
It got lot of data, and i have created it form the edit RKF's editor, i didt write it i selected it from the list. it is replacement variable i have checked lot of things for that, i have 0copmany is restricted in filter with variable so is that effecting it or wat else be the problem...!
Thanks
Sriram
Hello ,
What do you want to display , is it the column heading ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
Pls check that you have saved and activated the query
Regards,
Sangeetha.A
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.