a month ago
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
a month ago
Hello,
it's a mistake about internal / external format for account ! 🙂
Add zero in from of HKONT field...
a month ago
Thanks. Issue resolved.
I didn't notice the G/L length is 10 char.
a month ago
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
a month ago
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.
4 weeks ago