Negative where class in BSIS table

[Former Member]

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

[hitesh_gabani · Accepted solution]

Hi,

p_budat is what type?

I mean it is parameter that you pass from selection screen.

Regards,

Hitesh

[Former Member · Accepted solution]

Hi,

p_budat is a select-option.

p_budat-sign = I

p_budat-option = BT

p_budat-low  = 20130501

p_budat-high = 20130531

But concern is getting, with blart type posting as ne 'EX'.

[Former Member · Accepted solution]

Hi Kranthi,

I have tested as you suggsted, but still the same problem persisting. Thank you.

[VenkatRamesh_V · Accepted solution]

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.

[Former Member · Accepted solution]

Hi Venkat,

It's working fine. Thank you for the input.

[kiran_k8 · Accepted solution]

Negative where class in BSIS table

should be

Negative where clause in BSIS table

[kranthi_kiran5]

Hi,

   I Too Got the Similar Issue.

   Create a range for Blart and Pass it to the Selection query where Clause.

    The Range data can be filled as Below

     SIGN      = 'I'

     OPTION = 'NE'

      LOW     = 'EX'

Regards

Kranthi Kiran

[VenkatRamesh_V]

Hi,

TRY with  Creating secondary Index FOR NON key fields.

Hope it helpful,

Regards,

Venkat

[Former Member]

Hi,

already there is an Secondary Index, which is provided by standard SAP. i.e F15 Schnittstelle

But still the same problem persist.

WHERE bukrs = p_bukrs

            AND blart not IN ('EX')

            AND hkont = t_j_1iaccbal-j_1iaccno

            AND budat IN p_budat.

            .