Skip to Content
avatar image
Former Member

How to make Selection Criteria in SAP

I have created query in SAP. There are some selection criteria. One of them is Date Column. This query show me same column name 2 times when I execute this query. I want to display same column with different caption. For example Date Column { Date From and Date To }

---------------------------------------------------------------------------

SELECT T0.firstName, T0.lastName, T0.termDate FROM OHEM T0 WHERE T0.termDate between '[%0]' and '[%1]'

>>>>>>> Result :

Query - Selection Criteria

Termination Date =>

Termination Date =>

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 06 at 08:36 AM

    Hi,

    There is no way to rename the parameter, but you can use this syntax to distinguish them:

    WHERE T0.termDate >= '[%0]' and T0.termDate <= '[%1]'

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06 at 10:07 AM

    I have checked it before, Thank you for spending your time

    Add comment
    10|10000 characters needed characters exceeded