Select Query issue when fetching Serial Number

Hi Experts,

Recently facing one issue from Select Query.

I have developed the one Z-table, It contains the fields for material,serial No etc then data elements are referred standard only

Table for Both developments and production systems are contains same data based on this table i have done the Z-program, If i execute the report when passing serial no in where condition development is working fine (sy-subrc = 0) but production system reflects

sy-subrc as 4.

I cant guess the reason for this. Kindly anyone help me out to resolve this issue.

Regards,

Thangam Perumal