cancel
Showing results for 
Search instead for 
Did you mean: 

Text variable is not displaying in the query result

Former Member
0 Kudos
88

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi,

Do you have 0COMPANY in the drilldown of you report?

Former Member
0 Kudos

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

Former Member
0 Kudos

hi

i dont have 0company in drildown coz iam restricting on one particular company so i didt do that do u think it helps, and the same query is working fine in 3.5 its not working in7.0, and writing user exit for that i have try that later afteter this

thanks

Sriram

Former Member
0 Kudos

Hi

can i have the customer exit code psl

i have written the code but its dispalying only the key(value) not the text(label) so how do i get that..i dont know how to select it from 0COMPANY or form ZCOMPANY(variable).

Thanks in advance

Sriram

Former Member
0 Kudos

Hello ,

Is it possible to send the code , so that i can have a look at it and let you know if any modifications needs to be done.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi

Thanks for that, i am bussy with some other stuff,

i will check it and let you know.

i will assign points as well okay

thanks

sriram

Former Member
0 Kudos

Hi

I got an error 'invalid internal table.......!'

probably need to declare an internal table for that data to be stored temp.

i dont have much idea abt it can you please modify the code.

Thanks

Sriram

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi

yes the company code is restricted, and iam displaying this with columns and i added this to RKFs description, the txt variable is Replacement with 0company...so wat might be the problem that iam getting this displayed as it is in the run....!

Thanks

Sriram

Former Member
0 Kudos

Hi,

Is it properly defined ? write properties and process you have selected for creating variable .

Also check if there is any company code data available in infoprovider which you are taking as base for query.

Hope that helps.

Regards

Mr Kapadia

Former Member
0 Kudos

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

former_member188975
Active Contributor
0 Kudos

Try to have 0COMPANY in the drilldown and let us know.

Hope this helps...

Former Member
0 Kudos

Hello ,

What do you want to display , is it the column heading ?

Former Member
0 Kudos

hi,

Pls check that you have saved and activated the query

Regards,

Sangeetha.A