Skip to Content

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

calculating YearToDate , 0calquarter from fiscal year/period

Hi

I need to get the data for YearToDate . I need extract the data from a custom table.

And this table contains Fiscal year and fiscal period.

So how can i get the "Year To Date" based on fiscal year and fiscal period.

And how can i get the 0calquarter from fiscal year/period.

please let me know

kumar

Former Member
Former Member replied

You can try this:

Option1:

first derive Calmonth from fiscal period using formula: FISCPER_CALMONTH Calculate Calendar Month from Fiscal Period (PPP -> YYYYMM)

From period, derive quater. OR.

Option2: Usally 01, 02, 03 periods falls into quater1, 04,05,06 in Qtr2....etc.

based some logic also Quater can be derived from Period.

Srini

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