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, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA 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

SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table

Meetup Sunumu 1 meetup

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