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
Development resources, articles, tutorials, code samples, tools and downloads for SAP HANA and ABAP, HANA Database, SQLScript, SAP UI5, Screen Personas, Web Dynpro, Workflow

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 z_som_tools_tadir(
 p_pgmid = 'R3TR'
 , p_object = 'PROG'
 , p_objname = @sy-cprog


Install SAP Free
CRM Companies List
Web Based CRM Software

Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.