Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Negative where class in BSIS table

Hi Experts,

     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.

Code:

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

        FROM bsis

        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.

    


Regards

Mallikanjuna

Tags:
Former Member
replied

Hi,

Try,

Create Ranges for Gl Account,Company code , pass the values to ranges.

pass the ranges in select query using 'IN'.

Hope it helpful,

Regards,

Venkat.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question