Skip to Content
author's profile photo
Former Member

Exit Variable for converting 0FISCPER to 0CALMONTH

Hi all

1. My Report is based on a DSO with 0FISCPER , 0FISVARIANT , 0FISCPER3 in the structure.

2. My Fiscal year definition is different from the Calender year

3. My Customer wants to see the report in Calmonth instead of Fiscal year/ period.

Also the Variable input should be asked in terms of 0CALMONTH & not fiscal year/period .

My question is

1. Is this possible to through SAP Exit Variable ?

2. or through some Customer Exit Variable , can anyone help me out here with the ABAP code.

3. Is there any other Possibility other than change in the Transformations which i cannot afford to do .

Best Regards,

Ramesh

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 07:07 PM

    Long term solution :

    Add 0CALMONTH, and date field (yyyymmdd) to your data records to your ODS and reload your ODS to populate those fields with the help of some ABAP codes. That way you don't have to convert every time you run the query and it's more efficient.

    Short term solution is temporary only as you may run into data consolidation / consistency issues because calendar month and fiscal period do not match up in terms of number of days. If you currently don't have a date field (yyyymmmdd) for each of the data records, then you cannot reliably convert from fisc to calendar in order to select the appropriate records for reporting. If you do have the date field in your ODS, then let us know.

    Add comment
    10|10000 characters needed characters exceeded