Column Header Description-web Report

[Former Member]

Dear BW friends,

In my query I have 4 key figures in columns. Each key figure is ristricted by a version with a variable with a fixed value.

For eg. Version= ONE,Users want to see the ONE on the above 4 columns of key figures in the web report.It should not display for all columns.

How can I come through it. Is text variable helps. If so please guide me.

[Former Member]

You have to use a text variable of type customer exit.

- create a text variable of type customer exit, with not ready for input option unchecked.

- go to SE38 -> ZXRSRU01.

- insert the below code

- activate the program and project.

- insert this text variable name in the description of your KF.

Code can be something like this

DATA: LOC_VAR_RANGE LIKE RRRANGEEXIT.

DATA: DATA_TEXT LIKE LOC_VAR_RANGE-LOW.

If i_step = 2.

CASE I_VNAM.

WHEN 'your text variable'

LOOP AT I_T_VAR_RANGE INTO LOC_VAR_RANGE

WHERE VNAM = 'variable name on Version'.

if sy-subrc = 0.

DATA_TEXT = LOC_VAR_RANGE-LOW.

else.

DATA_TEXT = ' '.

endif.

CLEAR L_S_RANGE.

L_S_RANGE-LOW = DATA_TEXT.

L_S_RANGE-SIGN = 'I'.

L_S_RANGE-OPT = 'EQ'.

APPEND L_S_RANGE TO E_T_RANGE.

ENDLOOP.

endcase.

endif.

• search forum for more help on creating customer exit vairable

pls assign points if helpful

raj

[Former Member]

Hi Raj,

Thanks for your response. Indeed I have no variable with version. I ristricted all the 4 key figures with the vesion value eg. ONE.

When report displays Users want to see the ONE as a header on above all 4 key figures.

Sudhakr.

[Former Member]

Cant you just change the descripton of the KF to 'One'.

[javier_alvaradorodriguez]

Hello Sudhakar.

Just create a text variale of type replacement/path with characterictic for version and use it in all columns.

Regards.

[Former Member]

Hi Raj,

If I change the Key Figure desc, the I may confuse for all the KFs.

All four key figures are ristricted with Version ONE. Ultimately Users want to see the ONE as a header above the all four KFs (Columns)

Please

sudhakar

[Former Member]

Hi

If I do that the version text is displayed on every column. But I want to diplay once for all KFs.

thanks,

sudhakar

[javier_alvaradorodriguez]

Hello Sudhakar.

Now I understand better your problem. I think the only way you have to solve this is using the Table interface. You should do something like colspan="4" for the first header and then hide the next tree column´s header with the comment sentence. You should look for the "How to hide columns in Web templates" it may help you.

Regards,

javier.