Following is my select single query
SELECT SINGLE *
WHERE mprn_from LE iv_pod_id
AND mprn_to GE iv_pod_id.
mprn_from and mprn_to is of type NUMC, length 10
iv_pod_id is of type CHAR, length 50
Value in iv_pod_id is '120000043221967'. This is not present in z_table. When we check using se16 and put the value in mprn_from and mprn_to, obviously it is truncated to 1200000432 becuase the field length is 10, and no records are selected when we press F8.
But when the above select single statement is executed, sy-subrc = 0 is returned. Some random value from Z-table is selected. I have no idea why this is happening.