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

Symptom

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

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

But if queried 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.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

Netweaver based systems

Product

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

Keywords

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.