SQL Query

[Former Member]

Hi All,

When I tried to add a GROUP BY token as follows:

GROUP BY T1.UNIQUE_DOC_NAME

where T1 is FCI_PRO_PROJECTS table & UNIQUE_DOC_NAME is project name.

I am getting an error saying:

SQL Exception: ORA-00933: SQL command not properly ended , ANSI-92 SQL State: 42000, Vendor Error Code: 933. ORA-00933: SQL command not properly ended

Can anyone provide me what actually is my mistake in using the GROUP BY token. When I remove the GROUP BY token the query works fine. But we are getting repeated entries for the same PROJECT ID.

Can anyone send me exact QUERY GUIDENCE for SAP SOURCING system. As I am new to this I am facing many problems.

Thanks & Regards,

Harish Sudhakar Pai

Email: harish.sudhakar.pai@accenture.com

[Former Member]

Also can anyone provide me the description of FCI_GET_COMMA_LIST is usage.