on 09-15-2016 11:44 AM
Hello Experts,
Recently I was asked to find some ways to determine number of days in a fiscal month when the data view is in fiscal weeks.
Not sure what to do ?
I am looking for some option like Fiscal_Bdate(),Fiscal_Edate() but still I am confused.
Regards,
Prabhat
Hi Prabhat
Please try BUCKET_DAYS() function.I suggest refer standard Macro Book: 9AEXAMPLES View( MacroExamples) provided by SAP. In addition you may also want to look at the usage of these macro functions - DATE(), BUCKET_WDAYS(), CALENDAR_WDAYS(). Also refer below screenshot taken from above macrobook.
I know I am not solving the issue, but trying to give some pointers. Hope this will help.
Thank you
Satish Waghmare
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Ken.
Those are the functions which can help to do so but Yes, it is important you are using the right periodicity in the dataview.
Prabhat - Please throw some light on the rationale behind this requirement? Why would you need to determine number of days in Fiscal Month when you are in a dataview with Fiscal week periodicity?
Thank you
Satish Waghmare
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.