Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member4998
Active Contributor

Hi All


I am explaining how to sort the LOV’s display in the prompts screen.


While running the report Cust ID LOV’s are not display in sort order, As a results user feel difficulty to select the values.

To apply  sort on Cust ID LOV’s -> double click the business layer under local project -> Select the parameters and lists of values tab -> Select the List of values based on custom SQL -> Specify the Name (Cust ID LOV)

Click on the Cust ID LOV and then click on the Edit SQL tab -> Specify the SQL in the editor -> Validate the expression and press OK

Sample Code

SELECT DISTINCT FIELD

FROM

TABLE

ORDER BY 1

Click on the Preview tab and check the results. Lov's are displaying in sort order or not.

Once the LOV’s are display sort order -> Select the Business layer and click on the field: Cust ID –> Click on the advanced -> Select a list of values button, will get pop-up showing all the Custom SQL list of values-> select the Cust ID LOV and press OK.

Save the Business layer and export the universe to repository and then refresh the report and check the LOV’s.


Hope this helpful


Thanks

Sreeni


Labels in this area