Skip to Content
Former Member
Jan 27, 2011 at 10:26 PM

BI7 - Fiscal Week to Calendar Week Conversion


Hello Experts,

i have a requirement to convert Fiscal Week (YYYYWWW) to Calendar Week (YYYYWWW). Source field is from a flat file. My company follows the fiscal variant : Z3 (Fiscal Calendar : July to Jun)

Could any of you please shed some light (Function Module (if any)) to achieve this

Example : Input Field : 2011001 (Fiscal Year : 2011; Fiscal Week 1 represents 1st week in Sep 2010 )

Output should appear as : 2010027 (This is for Week 27 in Calendar Year 2010)

i would much appreciate your time and response