SAP Knowledge Base Article - Preview

2510245 - Different Results Between SE16 and SQL Query due to missing leading zero


The check result using SE16 is different from that using SQL Query.

For example, if to search ZBEXH-EXPNR = "801294553" in SE16, the result shows only one entry:


But if to search using SQL query, the result shows two entries:


The check result using SQL Query shows all entries containing search characters, while the check result in SE16 shows the entry with leading zero.



Netweaver based systems


SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0


SE11, SE16,  alpha conversion, Convers. routine, leading zero, missing leading zero, without leading zero , KBA , BC-DWB-UTL-BRR , Repository Browser, Object Navigator , 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.