Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

DATEPART issue ERROR 328 invalid name of function or procedure

former_member668981
Member

‎03-30-2020 6:18 AM

0 Kudos

capturar.pngHi Gusy,

I am new here, and also I just have started to create quries and programing in SAP.

Recentely my company installed the SAP Business One, and then I would like to take some reports and some follow up.

For example I would like to monitoring the amount of money recieved in each quarter, for that I have created the query below.

SELECT sum(T0."DocTotal"), DATEPART(month, T0."DocDate") 

FROM ORDR T0 

GROUP BY DATEPART(Month, T0."DocDate")

Thank you so much, I am watching a courser from SQL Server, I really don't know if is 100% suitable for SAP SQL.
If you have a better course, please let me know

  • SAP Managed Tags:
  • SQL
Preview file
13 KB
0 REPLIES 0