This website is not affiliated with, sponsored by, or approved by SAP AG.

SAP Query - Date Table

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

SAP Query - Date Table

Postby Brahio » Tue Oct 20, 2015 8:10 am

Hi
Checking if anyone has done this or can advise on an angle to get this. I simply want to create some summary queries (SQ02/SQ01) where the main table is a list of unique dates. I'm going to write some code in SQ02 to summarize specific subtotals for each day, but I need to have a date as a basis. Is there a standard table that just lists out dates from the factory calendar (or similar)? I just need a table with a list of unique dates.

My example query output after in my selection 10/1/15 through 10/05/2105:

Date Total_POs Total_Deliveries Total_EDI_FAILURE etc
10/1/15 1700 990 6
10/2/15 17055 920 0
10/3/15 7023 940 33
.......etc

So I need a date as a basis
Thanks
Brahio
Brahio
 
Posts: 113
Joined: Wed Oct 30, 2002 11:09 am

Return to ABAP

Who is online

Users browsing this forum: No registered users and 9 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.