Skip to Content

Conversion routine to convert Fiscal calendar date to Normal Calendar date

Hello Everyone,

There is a requirement to upload sales history from a file to BW.

In the sales history file, all the calendar date are fiscal calendar date. It needs to be converted to normal calendar date during the transfer. Does anyone know how to do it?

Thanks,

Bin

Edited by: Bin Li on Sep 8, 2009 4:56 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Sep 08, 2009 at 04:31 AM

    Hi,

    Can you pls give one example, i.e. current format and required format.

    Thanks

    Reddy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Bin Li

      Hi,

      Get the fiscal calendar date from the file. Using the date calculate the first day of that corresponding period. For this you can use the function module 'FIRST_DAY_IN_PERIOD_GET'.

      Then with the first date of the period add the value in the datefield of your data to it which will give you the result.

      For example, if your record has 20090504 fiscal calendar date.

      Period - 005 and Year - 2009.

      If First day of 5th period of 2009 - 20090503.

      If you add 3 to '20090503' you will get the fourth day of the period in normal date.

      data: firstday type sy-datum,

      nthday type sy-datum,

      day(2) type i,

      result type sy-datum.

      day = nthday+6(2).

      result = firstday + day - 1.

      Hope this helps you.

      Regards,

      Akhan

  • author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2009 at 06:59 AM

    hi Bin

    Use FM "G_POSTING_DATE_OF_PERIOD_GET" and pass parameter Fiscal Date and Fiscal Variant ( e: g V3 ) and you will get the corresponding Calender date. this FM available in your BW also.

    Or in SE#& search for the FM in BI.

    Regards,

    Souman

    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.