Skip to Content

Folks, this blog basically talks about fiscal year mainatatnce for week periods..

In our day to day activities, we might have come across cases where the posting of the last dates of any fiscal year (eg: December 31 2011) fall into 53rd week as the Calendar Week is maintained till Friday.

In 2011, we have 31 days in the month of December, however the last date was falling on a Saturday, so in order to overcome this challenge we have two options

1) Either for 2011 Fiscal year we have to maintain an extra 1 week just for 1 day.

Or

2) We need to add the remaining 1 day to Next Year’s 1st week.

Here the configuration should be to maintain the remaining 1 day in the present year with Year shift relative to the current year field.

And the same needs to be replicated to BW by Transferring the Global Settings in RSA1.

Through this blog, I am trying to explain above scenario both in R/3 and BW systems. How exactly it has to be configure/maintain.

Step1:

We need to check some entries in table T009B in R\3 system.

GO TO TCODE-SE16

Find the table T009B and click on Contents

Untitled 1.jpg

The 31st day should be maintained with a posting period 001 and ,Year shift relative to the current year field as +1 in table T009B. (Shown below)

Untitled 2.jpg

The above information is available in R/3 Side go and transfer GLOBAL SETTING in BI.

Before transferring the global settings in BI the table T009B entries like this for 31st Dec they don’t have any information so system will not allow the data for 31st Dec.

Untitled 3.jpg

Step 2:

GOTO  BI

TCODE –RSA1

Modeling –> Source Systems –> Select your source system connection (R/3) –> Select your client –> Right click –> select Transfer Global settings.

Untitled 4.jpg

After transfering global settings in BI the table entries like this. now we can load data for 31st Dec also.

Untitled 5.jpg

Now we can load the data for 31st Dec also.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply