Skip to Content

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

sapdbsdf - How to manipulate BSIS_WHERE?

Hi all,

The following code is from system program sapdbsdf which runs when calling FBLxN.

Since the "GJAHR IN SD_GJAHR" is commented, the select results in bad performance (sequential read).

When turning system debugging on and setting BSIS_WHERE = 'GJAHR = '2010' the

performance is becoming much better. Does anyone have dealt with this or

found a method to access BSIS_WHERE variable programmatically? (No exit/badi/enhancement

seem to exist)

Best regards,


*  3 Variante: Variante 1 + 2 sind gleichzeitig gewuenscht             *
      if SD_OPOPT eq 'X' and SD_APOPT eq 'X'.
        select (BSIS_FIELDS) from BSIS into corresponding fields of BSIS
                           where BUKRS eq SAVE_BUKRS
                           and   HKONT eq SAVE_SAKNR
*                      AND   GJAHR IN SD_GJAHR
                           and   BUDAT in SD_BUDAT
                           and   BUDAT le SD_STIDA
                           and   ZUONR in SD_ZUONR
                           and   GSBER in SD_GSBER
*                      and   blart in sd_blart          "<<<< au40
                           and   VBUND in SD_VBUND
                           and   BSCHL in SD_BSCHL
                           and   KOSTL in SD_KOSTL
                           and   WERKS in SD_WERKS
                           and   SHKZG in SD_SHKZG
                           and   (BSIS_WHERE).

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