Skip to Content
0

ABAP SAP open sql group by date ( month , day or year )

May 03, 2017 at 02:44 PM

183

avatar image
Former Member

Hey sap community,

i'm selecting a date with a select options filter in a

certain period for example between the 01.01.2017 and the 17.06.2017.

after the select im looping the timestamp into the ET_entityset.

the thing is i want to kinda group the dates for instance i want to group all dates selectet at january and february which means i want to group the dates after day, month, and year..

i thought about smth like a count or so ? because after that i need the number of the dates selectet grouped by month or day or year.

but i dont have any clue how to realize that in terms of coding it in ABAP.

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

1 Answer

avatar image
Former Member May 05, 2017 at 01:45 PM
0

can you explain with one example please to understand better?

Share
10 |10000 characters needed characters left characters exceeded