Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Time Characteristic in a query

I have an InfoObject called Time (0Time) which I want to include in a query. The object is part of my InfoProvider. The time is given in hours what I want to do is group the time so that I have three values represent morning afternoon and evening. How can I do this? Thanks

replied

In the rows part of the query designer, right click on the word Rows and select New Structure. In the Structure you see right click and select new Selection. Here make the selection by including 0TIME(drag and drop from left hand box). Right click 0TIME in the right hand side and Restrict. Restrict with values, like 00:00:01 to 12:00:00 (for Morning). Clcik OK. Change the description of the Selection to Say "Morning" and click OK. You can repeat by creating new selections for Afternoon and Evening.

You can save the structure and use it across multiple queries if reqd.

Hope this helps...

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question