Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to calculate Fiscal Month

Hi Experts,

I have a requirement to calculate the Month and based on that Populate the target element.

Requirement Details:-

1)If the Store open date is Future Date or Blank date than it is a new Store.

2)If the Store Open Date  is falling in the first Monday or  other Monday than it is comp Store till 53 week it is Comp and next week it will change to non comp.

Ex 3rd Aug is Monday so if the store is open on 3rd Aug or any day on or before 31st Aug it will come in Aug Fiscal Month and Calculation of Fiscal Month will start from Aug.

If Store is 1st of Sept but Monday fall in Aug ie 31st Aug so this store will again fall in Aug Fiscal Month.For Sept Fiscal Month to start,it will start from

7th of Sept 2015.Any Store open before 7th Sept,it will fall in Aug Fiscal month.

I want to generate 54 Record from 1 record saying 1-53 week is comp and last Record will carry status as non comp.

Please suggest.

Regards,

Abhinav Verma

Not what you were looking for? View more on this topic or Ask a question