cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Query Aliases for Parameters

Former Member
0 Kudos
144

I have a query I have built which take the following parameters:

- PeriodOpenDate

- PeriodCloseDate

- Client

- InterestRate

When I execute the query, which simply calls a stored procedure and passes the parameters, I get the following labels for the fields:

- Posting Date

- Posting Date

- BP Code

- BP Code

I want to clean up the labels so they are meaningful, but I am not sure how to proceed. I have seen the thread about creating a User-Defined Table with a map between a fieldname/parameter and a friendly description, but is it possible to just pass a text label to B1 to present or will I have to use a UDT and database query just to get friendly field names?

Thanks in advance,

Rob

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

UDT is needed here. You cannot bypass this if you want to get meaningful names.

Thanks,

Gordon

Answers (1)

Answers (1)

jbrotto
Active Contributor
0 Kudos

in the UI you can hold ctrl button and left click to rename a field in any data window.