sy-subrc = 4 for select statement but SE16N have records

I am running following code in ECC and Oracle 12c: 

PARAMETER : p_bupla TYPE bsis-bupla.
SELECT-OPTIONS: s_perio FOR bsis-bldat.
SELECT bukrs hkont bldat gjahr belnr budat xblnr bupla gsber
FROM bsis INTO TABLE it_bsis
WHERE bukrs = ‘1000’ AND hkont = ‘25002050’ AND bupla = p_bupla
AND ( bldat le s_perio-high AND bldat ge s_perio-low ).

In debugging  we are no value in it_bsis and  Sy-subrc = 4, sy-msgid = SF ,   sy-msgno = 616

SE16N with same input criteria, we are getting 3 records:

Amitesh_0-1711623993095.png

Checked with different input values and getting same result.

Looking for help to solve this problem.

Regards

 

 

 

 

 

 

Scroll to Top