sapdbsdf - How to manipulate BSIS_WHERE?

[former_member848108]

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,

Ozcan.

*----------------------------------------------------------------------*
*  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).

[Former Member]

The SAPDBSDF refers to the LDB "SDF". In LDB, the dynamic where condition get populated from the dynamic field selection. I checked the GJAHR field for BSIS dynamic condition and it does exist. You can populate the GJAHR using the dynamic selection in the selection screen.

[ravi_lanjewar]

Hi,

Did you check what is where condition is apply ? Trace the program using ST05 on which where contition is slow down.

[former_member848108]

Hi Suman,

Thanks for your reply.

Regards,

Ozcan.