Negative where class in BSIS table
While Developing FI report in which we are Calling the BSIS table, Which gets 10 records in the DB table & while executing the Program it gets only 9 records.
IF t_j_1iaccbal IS NOT INITIAL.
SELECT bukrs " Company Code
hkont " General Ledger Account
budat " Posting Date in the Document
blart " Document Type
shkzg " Debit/Credit Indicator
dmbtr " Amount in Local Currency
INTO TABLE t_bsis
FOR ALL ENTRIES IN t_j_1iaccbal
WHERE bukrs = p_bukrs
AND hkont = t_j_1iaccbal-j_1iaccno
AND budat IN p_budat
AND blart not IN ('EX').
ENDIF. " IF t_j_1iaccbal IS NOT INITIAL.
I am Facing Issue while Using the Blart field in Where Clause. If i remove the Blart in where it is Performance Issue.