Symptom
- The SELECT SINGLE or SELECT UP TO 1 ROWS does not return the data in the desired order. For example, there are 1+ rows which meet the SELECT condition but the SELECT does not return the desired order.
- The SELECT returns the dataset with unexpected sequence. The issue may start to happen after upgrade/migration.eg.
Read more...
Environment
- SAP Netweaver release independent.
- ABAP System.
Product
Keywords
OPEN SQL, data sequence, up to 1 rows, SELECT SINGLE, sort, order by, upgrade, migration , KBA , BC-ABA-LA , Syntax, Compiler, Runtime , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , HAN-DB , SAP HANA Database , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-ORA , Oracle , BC-DB-SDB , MaxDB , BC-DB-DBI , DB Independent Database Interface , BC-DB-DB4 , DB2 for AS/400 , BC-DB-DB2 , DB2 for z/OS , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-DB-HDB , Use HAN-DB*. Here CCMS, Porting, DB Interface issues only , BC-ABA-LA-EPC , Extended Program Check (SLIN), Code Vulnerability Analyzer , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.