Skip to Content
0

How to make Selection Criteria in SAP

Mar 06 at 08:00 AM

24

avatar image
Former Member

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 =>

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Johan Hakkesteegt Mar 06 at 08:36 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 06 at 10:07 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded