cancel
Showing results for 
Search instead for 
Did you mean: 

Indian Calendar Day & Year

Former Member
0 Kudos

Hi,

I'm working for an Indian client whose calendar year is from April<Previous Year> to Mar<Current Year>. Now in reports, I've below two requirements:

1. Display Calendar Day as DD.MM.YYYY instead of default 0CALDAY settings (i.e. MM/DD/YYYY).

2. In a report, I want to summarize Qty figure as per indian calendar e.g. if User runs report for last three years (i.e. for 2008, 2009 and 2010), then the report should summarize as per below:

a. April.2007 to Mar.2008

b. April.2008 to Mar.2009

c. April.2009 to Mar.2010

How can I achieve above two requirements.

Regards,

Vikrant.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Date format is a user specific settings, it can be changed using transaction SU3 by each user and this will apply to BEx queries too

For second problem, you can use the standard objects combination 0FISCVARNT & 0FISCYEAR,

The Fiscal year variant (0FISCVARNT) value should be a constant value of 'V3' (April - March)

Add these two Infoobjects to the underlying info provider and just map the calday or calmonth to 0FISCYEAR.

For 0FISCVARNT, use a constant value of V3 (April - March)

Hope it helps

Uday Pothireddy

Former Member
0 Kudos

Uday,

I'm basically working on Inventory Cube (0IC_C03) which doesn't have 0FISCVARNT, but has other time characteristics like 0CALDAY, 0CALMONTH, 0CALYEAR.

Do you think adding 0FISCVARNT and assigning a constant value V3 will solve the requirement?

Do I need to to include 0FISCVARNT in query design also? Or will the query summarize automatically (for records Apr to Mar) if I don't include it in query design? Do let me know.

Regards,

Vikrant.

Former Member
0 Kudos

Add 0FISCYEAR and 0FISCVARNT both to the cube.

Map 0CALDAY to 0FISCYEAR and assign a constant value of V3 to 0FISCVARNT in the transformation.

If calday is between April 01, 2010 till March 31, 2011, the 0FISCYEAR will be populated with value of 2011

You do not have to add 0FISCVARNT to the report.

When ever you want reporting from April - March, use 0FISCYEAR as selection, that should be sufficient.

Check in table T009T if V3 actually represents April - March or not.

Hope it was helpful!

Former Member
0 Kudos

Thanks Uday,

It has been resolved. I've assigned points.

Answers (2)

Answers (2)

Former Member
0 Kudos

If a custom fisca year and variant are not available as a solution, consider creating a BW Hierarchy based on 0CALMONTH or 0CALDAY.

This solution works well if you have to deal with multiple Calendars - Internal fiscal, government fiscal, or big customer's calendar.

John Hawk

umesh_pednekar
Active Participant
0 Kudos

Hi Vikrant

The Calendar Day can be changed through a custom variable which you need to populate through an ABAP code. the input for the variable would be the date in the MMDDYYYY format and the output would be derived through the routine (i.e. customer exit) as required.

For the 3 years data, do you have 0calyear in your info provider. If yes, then it would be easy for you to display the report with the key figure attached to the characteristics with value (variables) current year, current year-1 , current year-2. (you will be creating a new selection for these key figures). If you do not have calendar year in your info provider then you may have to use calendar year/month or fiscal year/period , however, the past periods will be again derived by passing values from the current year fiscal period (i.e. Apr 2010 - MAr 2011) to calculate previous fiscal year periods (again through a customer exit).

Cheers

Umesh