Maintain Fiscal Year Variant – For week periods
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.
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.
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
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)
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.
Modeling –> Source Systems –> Select your source system connection (R/3) –> Select your client –> Right click –> select Transfer Global settings.
After transfering global settings in BI the table entries like this. now we can load data for 31st Dec also.
Now we can load the data for 31st Dec also.