Skip to Content
0
Former Member
May 15, 2008 at 02:31 PM

How Can I reconstruct the SQL

28 Views

Hi Gurus,

We are using SAP DB + 46C on Unix machine, I used to run the following SQL command on SAP DB directly , how can I reconstruct the same SQL to work in ABAP report.

SELECT SRTFD, COUNT(*), MAX(SRTF2) FROM INDX

WHERE RELID = 'SD'

GROUP BY SRTFD

HAVING COUNT(*)=1

AND MAX(SRTF2) != 0.