URGENT: using the row value for getting column value.

[Former Member]

hi......i want to use the row value for getting the column value. ie.

if in the row the year value is 2007 & i said that i want (year in the row) - 1. then in the column value should pick 2006.

if the year is 2008 then column value should be 2007.

how can i read the row value ? pls help.

[Former Member]

Hi,

I think, u can try like this ...

Create two variables: ZCALYEAR ( Userentry / default value , 0calyear, single value, mandatory ) , ZCALYEAR1( User-Exit ).

In include program ZXRSRU01 , under i_step = 2 .

try the following code.

DATA: year1(4) TYPE n.

WHEN 'ZCALYEAR1'.

IF i_step = 2.

CLEAR loc_var_range.

LOOP AT i_t_var_range INTO loc_var_range

WHERE vnam = 'ZCALYEAR'.

year1 = loc_var_range-low(4).

year1 = year1 - 1.

MOVE year1 TO l_s_range-low.

l_s_range-high = loc_var_range-low.

l_s_range-sign = 'I'.

l_s_range-opt = 'EQ'.

APPEND l_s_range TO e_t_range.

EXIT.

ENDLOOP.

ENDIF.

I am not good in ABAP but please check the definitions also.

I have added some additions in coding

Regards,

SRIKANTH

Message was edited by:

KANTH SRI

[Former Member]

Hi,

I hope you need 2007 value against 2008 year.

For this , you take 2 selections in the rows.First selection should has CALYEAR = 2007 and Second selection should has CALYEAR = 2008. Hide first one. And then take Required KF into columns area . Now you will get 32 matrix (rows columns).

Then ,in the cell editor. Replace the cell (3,2) with cell (2,2). That means you are overwriting the 2008 value with 2007 value.

With rgds,

Anil Kumar Sharma .P

[Former Member]

can you please eloborate you requirement

Regards

[Former Member]

HI,

Use Formula Variable with replacement path to get row values to coloum Values.

If it dosent help, explain the scneario in detail.

Best Regards,

Meiy

[Former Member]

Im new to BEx so i dont know how to use formula variable with replacement path. Will u plss explain the procedure????

[Former Member]

Hai

check this link how to create formula variable

http://www.sd-solutions.com/documents/SDS_BW_Replacement%20Path%20Variables.html

i dont know whether this is the solution for ur question but if u explain bit more about the problem that would help us to solve

regards

abi ram

[Former Member]

hi.....could u send me any document which will elaborate more on replacement path & how can i select the row value to get column value.......