on 01-07-2015 4:52 AM
Hi All,
I have a department variable which is having values like #, cargo , it, etc....
But client is asking that when he is doing f4 on department variable it should not show the '#' value.
In Master data and info provider we are having # value for department.
Kindly suggest how to resolve this.
Thanks,
Naveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nanda,
Thanks for your help.
In document the code is related to fiscperiod, that to they are showing pervious year data as same as I checked your code related to GLaccount, I am quite not understand the code...
But in my scenario while executing the query(RSRT) user should select dept manually here I am using Dept as infoobject which should n't show the # value in the variable screen, I am not good in abap code so kindly give me the code based on that I can copy and paste it.
So kindly provide the code for me.
Cube data
Dept Count
# 10
cargo 15
it 16
fire 20
Thanks,
Naveen
Hi Naveen,
Please check below code, you may need small change.
DATA: l_s_range LIKE LINE OF c_t_range.
TYPES: BEGIN OF ty_dept,
Dept TYPE /bic/oidept,
Count TYPE /bic/oiCount,
END OF ty_dept.
DATA: t_Dept TYPE STANDARD TABLE OF ty_dept,
w_Dept TYPE ty_dept.
CASE i_vnam.
WHEN 'variable tech name'.
CLEAR : c_t_range, l_s_range.
SELECT /bic/Dept /bic/Count FROM /bic/Pdept
INTO TABLE t_Dept WHERE
/bic/Dept ne space and
objvers = 'A'.
IF sy-subrc EQ 0.
SORT t_Dept BY dept.
LOOP AT t_Dept INTO w_dept.
l_s_range-iobjnm = i_iobjnm.
l_s_range-sign = 'I'.
l_s_range-option = 'EQ'.
l_s_range-low = w_dept-dept.
APPEND l_s_range TO c_t_range.
l_s_range-iobjnm = 'Count' .
l_s_range-sign = 'I'.
l_s_range-option = 'EQ'.
l_s_range-low = w_dept-Count.
APPEND l_s_range TO c_t_range.
ENDLOOP.
CLEAR: t_dept.
ENDIF.
ENDCASE.
Thank you,
Nanda
Hi,
There are some serious reasons for not changing anything !!!.
# sign is a standard way in SAP BW for displaying not assigned values.
Changing this can cause some misunderstandings while filtering or analysing displayed data.
All in all I think that teaching the user how to deal with # sign will be the best option.
Regards, Leszek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Naveen,
you can convince that this is the standard behavior and blank values are shown as # in BEx. One other option I can think of is to create auth object and give values of department other than #.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Naveen,
There are 2 ways 2 resolve this:
1. If user doesn't want to see # entries at all, then better to delete at Infoprovider level.
2. If it is for a particular report to avoid # entries, then in your manual entry variable "exclude #" i.e "<> (not equal to) #" in BEx Query designer.
Hope it helps.
Thanks,
Shreya J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.