Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All.
I need to build a calendar to resemble the SAP Posting Periods as follows :
SAP Calendar is in the format bellow :
Fiscal Year Variant | Year | Calendar Month | Calendar Day | Posting Period | Year Shift |
----------------------------------------------------------------------------------------------------------------------------
Z1 | 2014 | 1 | 22 | 1 | 0 |
Z1 | 2014 | 2 | 21 | 2 | 0 |
Z1 | 2014 | 3 | 24 | 3 | 0 |
Z1 | 2014 | 4 | 23 | 4 | 0 |
.
.
.
Z1 | 2014 | 12 | 22 | 1 2 | +1 | Year change
Z1 | 2015 | 1 | 23 | 1 | 0 |
Z1 | 2015 | 2 | 23 | 2 | 0 |
and so on.
I am trying to build a Calendar as follows :
fYear | Posting Per | Date | Month | |
---|---|---|---|---|
2013 | 1 | 23 Dec 2013 (period starts on 23 Dec 2013) | Dec | |
2014 | 1 | 01 Jan 2014 | Jan | |
2104 | 1 | 02 Jan 2014 | Jan | |
............ | ........... | .............................. | .......... | |
2014 | 2 | 23 Jan 2014 (new posting period starts) | Jan | |
2014 | 2 | 24 Jan 2014 | Jan | |
2014 | 2 | 25 Jan 2014 | Jan | |
........ | ........... | ..................... | ......... | |
2014 | 2 | 21 Feb 2014 (Posting period ends) | Feb | |
2014 | 3 | 22 Feb 2014 | Feb | |
2014 | 3 | 23 Feb 2014 | Feb | |
......... | ................. | ............................... | ......... | |
2014 | 12 | 22 Dec 2014 | Dec | |
2014 | 1 | 23 Dec 2014 (New Posting period starts) | Dec | |
......... | ................ | ........................................ | ||
2015 | 1 | 01 Jan 2015 (year change) | Jan | |
2015 | 1 | 02 Jan 2015 | Jan | |
Has anyone done anything similar ? Thanks in advance.
Load the calendar from SAP if possible. If that's not an option then create the calendar in an excel file and then load the excel file into qlikview. You will waste a lot more time if you're trying to create a script to generate such a calendar.
Hi Gysbert.
The SAP Table provides different data. I need to build the Calendar to reflect the different Posting Periods and Year Change. I found a script that calculates Pay Periods but still different from what I'm trying to achieve.
The Excel option is viable but with a lot of data entry.
Maybe like attached qvw.
Thanks Gilbert. It is getting closer. The only problem remaining is that the first posting period starts on the 23 Dec 2013 and ends on the 22 Jan 2014 and this period is flagged as PP 1.
No problem Shimano. The PP 1 is new to me. I didn't see that mentioned anywhere in your post. Can your explain what you expect?
PP 1 is the Posting Period (12 in total for each fiscal year. The hard part is that as you can see, the first posting period starts on the 23 Dec 2013 and finishes on the 22 of Jan 2014. Same happens when changing year from 2014 to 2015.
So you want the string 'PP' in front of the period numbers?