SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




Install SAP Free


ATC Check: Select Single is Possibly not Unique


In a SELECT SINGLE command executed on a CDS View object gave me following error on ABAP Test Cockpit ATC check results: SELECT SINGLE is possibly not unique.

In my developer group we periodically run ATC checks and while trying to clear my list of ATC result list, I saw this entry.

ATC Check SELECT SINGLE is possibly not unique

In fact the parametric CDS view returns single row because of all parameters used in filtering the data for CDS view cover all parameters of the database table key fields

I believe since I did not use Key Field annotations within the CDS View definition, the ATC check cannot resolve the mapping and displays this ATC error "SELECT SINGLE is possibly not unique"

For ABAP programmers, it is possible to supress the ATC error using pseudo comment CI_NOORDER as follows

select single author
into @data(lv_author)
from /bsh4/som_tools_tadir(
 p_pgmid = 'R3TR'
 , p_object = 'PROG'
 , p_objname = @sy-cprog
). "#EC CI_NOORDER





SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table








Copyright © 2004 - 2018 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems