SAP Standard BEx Variable for YTD

[tnecnivo]

Hi BI gurus,

We are currently creating a query that need to show YTD.

The query will have the user to enter the Fiscal Period they want.

And from the fiscal period, the variables will calculate from start of the fiscal year until the month the user entered.

Have any SAP Standard Variables cater for this?

Many thanks,

Vince

[tnecnivo · Accepted solution]

Found it,

The Standard BEx Variable to get YTD:-

• 0I_BA104 (Cumulated Up To Period (SAP Exit for 0P_FPER)

Create a Selection, and use <(0I_BA104) > to get current YTD.

[former_member182467 · Accepted solution]

Vincent, I could not find 0i_BA104 but found 0I_BA107. Can you please suggest. this variable has this description.

Cumulated Up To End of Prior Year (SAP Exit for 0P_FPER)

Thanks

DR

[tnecnivo · Accepted solution]

Hi Daniel,

If you cannot find 0i_BA104, you need to activate it from BI Content.

[anshu_lilhori]

Hi,

Kindly check the below link for your requirement.

http://scn.sap.com/people/durgesh.gandewar/blog/2012/02/14/financial-reporting-in-bi-over-various-ti...

I think there is no standard variable available to calculate the same,if it had been there then all the experts would have been using it instead of writing that lengthy codes.

Hope that helps.

Regards,

AL

[ravi_chandra3]

Hi

I think there is no such standard SAP variables , you have to write the customer exit to get your requirement.

There is a function module which will get the fiscal year period and from that you can get your requirement.

Regards,

RC

[tnecnivo]

Hi Ravi,

That's what I thought, but is there any way to do YTD without customization by using Fiscal Year/Period?

Thanks alot

[ravi_chandra3]

Hi

In your case , the user has to pass the fiscal period and based on that you have to get the starting of that fiscal year to till  that fiscal period . Is it what your requirement ?

You can get this simply by using the customer exit .

below is the pseudo code :

data wa1 like line of e_t_range.

data wa2 like line of i_t_var_range.

"read the data from i_t_var_range and store it into one variable.

" use the function module to get the fiscal year and store the first period in one variable(let's say var1).

wa1-low = var1.

wa1-high = var2.

wa1-opt = 'BT'.

wa1-sign = 'I'.

APPEND WA1 TO E_T_RANGE.

endif.

Hope you got it,

Regards,

RC

[tnecnivo]

Hi Ravi,

Thanks for the codes, I think I got it, thanks for that.

But, just to ask, currently there are no SAP Standard Variables for getting YTD at all?

Not even using other Time characteristics?

Thanks

[ravi_chandra3]

Hi vincent ,

I think there is no such standard sap variables to satisfy that requirement.

Instead you can use that code .

Regards,
RC