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]

In addition to the above mentioned I found that while using the GROUP BY token for other test query the same worked fine but for the query which business is asking for where we have lots of joins & filters I am facing this issue. Please help me out in this.

Thanks in advance.

[Former Member]

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