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

[Amitesh]

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:

Checked with different input values and getting same result.

Looking for help to solve this problem.

Regards

[stanislaslemaire]

Hello,
it's a mistake about internal / external format for account ! 🙂
Add zero in from of HKONT field...

[Amitesh]

Thanks. Issue resolved.

I didn't notice the G/L length is 10 char.

[BaerbelWinkler]

Hi Amitesh,

can you please add a screenshot of what s_perio contains when the select happens? It might be due to a date formatting issue.

Cheers

Bärbel

[Amitesh]

Issue was with length of HKONT field. It's 10 char while I was giving 8 char value only, as it works in SE16N.

Thanks.

[maalam]

Use leading zeros in hkont.