Skip to Content
avatar image
Former Member

Create New Variable for COPA Drilldown Reports in KE3E

Hi,

How can we create a formula variable for COPA Drill down reports in KE3E? In standard global variables formula variable is not avaiable, I need to create a formula variables like ...from period, to period, last fiscal year and next fiscal year..

While creating report in KE31/KE35 trying create local variables, but it doesn't.

Can any body advise how can we create a new variables for "from period, to period, last fiscal year and next fiscal year.."

Thanks

VS Rao

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 16, 2010 at 08:56 AM

    Hi Rao

    For Period (From &To)

    1. KE3E

    2. Type of Var = Char Value

    Enter variable name, say, ZPERIOD

    Field Name = PERDE

    Replacement type = Entry

    Enter Description

    Parameter/selectop = Selection Option

    For Fiscal Year

    Type of Var = Char Value

    Enter variable name, say, ZGJAHR

    Field Name = GJAHR

    Replacement type = Entry

    Enter Description

    Parameter/selectop = Parameter

    For Next and Last Fiscal Year

    When you define your form in KE34/KE35

    Use the variable ZGJAHR in your report

    In the column for Next Year, Enter "ZGJAHR+1" as the local variable for GJAHR

    In the Column for Last year, Enter "ZGJAHR-1" as the local variable for GJAHR

    Regards

    Ajay M

    Add comment
    10|10000 characters needed characters exceeded