Skip to Content

formula fiscal year to fiscal year period

Hi

I need to convert fiscal year to fiscal year period.

what formula i need to use.

Regards
Mohan

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Sep 07, 2013 at 08:17 PM

    Hi

    You can't convert fiscalyear into fiscalyear/period only the other way around.

    SUBSTRING(0FISCPER,0,4) in a transformation would give you the year from fiscalperiod

    hope it clarifies

    Martin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2013 at 06:25 AM

    Hi,

    As mentioned by Martin...You cannot get fiscal year period from fiscal year.

    If you have some other requirement where you need to hard code or something like that.

    Please share and confirm.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2013 at 06:50 AM

    Hi Madan,

    From Fiscal year(4 digits) to Fiscal period(7digits) never possible. If you have any other date field along with fiscal year then based on that you can get period and club to fiscal year Look for any other date field(month or day dates) was existing at your data source then with help of abap you can achieve.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2013 at 06:59 AM

    Check if you can use FM DATE_TO_PERIOD_CONVERT .

    Input parameter : Fiscal year variant and SY-DATUM.

    Output parameter : Fiscal year period.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2013 at 03:17 PM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.