variable with user exit, urgent plz

[Former Member]

Hi friends,

I have a requirement to create a variable with user exit. The variable should be based on

forecast period. And it is based on quarter value. If user enters

jan2007 it have to fetch amount value for jan2007

feb2007 it have to fetch amount value for jan + feb 2007

mar2007 it have to fetch amount value for jan + feb + mar 2007

apr2007 it have to fetch amount value of apr2007

may2007 it have to fetch amount value of apr + may 2007

jun 2007 it have to fetch amount value of apr+may + jun 2007

jul2007 it have to fetch amount value of jul 2007

so on

I hope I gave you some idea. can some one give me the user exit code for this one please... It is an urgent requiremet.

Appreciate your help.

Thanks.

Ravi

[Former Member · Accepted solution]

Ravi,

Just give me the tech names of the variable u r uing and its position in the query design.

[Former Member · Accepted solution]

hi venkat,

The requirement here is, user asked us to create this variable which he can use this

in multiple queries after that. As of now he asked me to put some name GFV111.

The position of this variable is in columns. we are putting the natural accts in rows.

basically this is of a raw query. with this user can use it of his own.

I planning to create this variable on time dimensin.

Time dimension --> create new variable --> variable with processing as user entry.

Please advise me. Thankyou for your response.

Ravi.

[Former Member · Accepted solution]

Ravi,

You can create this varibale on the month IO I think it is 0FISCPER. Well, let this be a user entry variable. Restrict this in a dummy column and hide.

Again before that search for SAP EXIT variable which gets YTD values which would suffice the requirement.

Will give you the code in a short while.

[Former Member · Accepted solution]

you can also do this with formula variables and a big calculated key figure

[Former Member · Accepted solution]

Thankyou venkat, I will wait for you code.

Thankyou william.

Its great help.

Ravi.

[Former Member · Accepted solution]

Ravi,

Can you give me the valies eneterd by the user. I mean some sample data...

Data: itab like i_t_var_range,

mvar(2) type N,

yvar(4) type N,

first_dat type D,

pyvar(4) type N.

WHEN ZKDAT.

IF i_step = 2.

LOOP AT i_t_var_range INTO itab WHERE vnam = 'ZKDAT'.

CLEAR: mvar, yvar, first_dat, pyvar.

mvar = itab-low+4(2).

yvar = itab-low+0(4).

CASE mvar.

WHEN '01' or '02' or '03'.

pyvar = yvar -1.

concatenate pyvar '04' '01' into first_dat.

l_s_range-low = first_dat.

l_s_range-high = itab-low.

l_s_range-sign = 'I'.

l_s_range-opt = 'EQ'.

APPEND l_s_range TO e_t_range.

EXIT.

WHEN Others.

concatenate yvar '04' '01' into first_dat.

l_s_range-low = first_dat.

l_s_range-high = itab-low.

l_s_range-sign = 'I'.

l_s_range-opt = 'EQ'.

APPEND l_s_range TO e_t_range.

EXIT.

ENDCASE.

ENDLOOP.

ENDIF.

Ravi, using this sample code you can make changes relevant to your case. If you can give inputs I asked for I will modify and give it.

[Former Member · Accepted solution]

Thankyou Mr. venkat Ambati.

I appreciate your help. As of now I dont have any data to check it out. I will get back to you once I have any data.

Thanks mr Venkat Devraj, I dont have access to change the cube structure.

Once again thanks,

Ravi.

[Former Member]

Dear Ravi,

what you can do is inset a new characteristic Qtr into your cube and in the update rule you ca write a formula like of the month is jan (01)to mar (03) update with 1, and if the month is apr (04) to Jun (06) update with2 and so on for rest of the qtrs.

Now in the query add a dummy coloum with any key figure and a variable for the SAP variable current month or a user entry varaible for 0FISCPER.

Next create customer exit varaible for the characteristic Qtr. for this you can write the code like if the month is jan (01)to mar (03) update with 1, and if the month is apr (04) to Jun (06) update with2 and so on for rest of the qtrs.

hope the above helps if yes please assign reward points.

Regards

venkata Devaraj

[Former Member]

In BW reports we have the ability to use variables. There are different kinds of variables, and one of the types is those that are processed through an exit. The business content variables of this type are said to be processed by SAP exit, and those that we create use the Customer Exit. This useful if we cannot directly derive the value for a variable, and need to write some code for it.

Take a look at the example and info in this link:

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a56f5e09411d2acb90000e829fbfe/content.htm

There are also some useful documents on Exits in the BW InfoIndex at www.service.sap.com/bw