3259792 - Tcode FBL1N have query performance issue base - SAP ASE for Business Suite

t-code FBL1N is very slow on newly-installed SAP NetWeaver systems on SAP ASE database 

Slowness is observed for certain Company Codes, when the variant has single Company Codes as filter criteria. For ranges of Company Codes, the search is quick.

ST05/ST12 SQL Trace shows the slowest query to be:

SELECT DISTINCT "MANDT" ,"BUKRS" ,"LIFNR" ,"UMSKS" ,"UMSKZ" ,"AUGDT" ,"AUGBL" ,"ZUONR" ,"GJAHR" ,"BELNR" ,"BUZEI" ,"BUDAT" ,"BLDAT" ,"CPUDT" ,"WAERS" ,"XBLNR" ,"BLART" ,"MONAT" ,"BSCHL" ,"ZUMSK" ,"SHKZG" ,"GSBER" ,"MWSKZ" ,"DMBTR" ,"WRBTR" ,"MWSTS" ,"WMWST" ,"BDIFF" ,"BDIF2" ,"SGTXT" ,"PROJN" ,"AUFNR" ,"ANLN1" ,"ANLN2" ,"EBELN" ,"EBELP" ,"SAKNR" ,"HKONT" ,"FKONT" ,"FILKD" ,"ZFBDT" ,"ZTERM" ,"ZBD1T" ,"ZBD2T" ,"ZBD3T" ,"ZBD1P" ,"ZBD2P" ,"SKFBT" ,"SKNTO" ,"WSKTO" ,"ZLSCH" ,"ZLSPR" ,"ZBFIX" ,"HBKID" ,"BVTYP" ,"REBZG" ,"REBZJ" ,"REBZZ" ,"SAMNR" ,"ZOLLT" ,"ZOLLD" ,"LZBKZ" ,"LANDL" ,"DIEKZ" ,"MANSP" ,"MSCHL" ,"MADAT" ,"MANST" ,"MABER" ,"XNETB" ,"XANET" ,"XCPDD" ,"XESRD" ,"XZAHL" ,"MWSK1" ,"DMBT1" ,"WRBT1" ,"MWSK2" ,"DMBT2" ,"WRBT2" ,"MWSK3" ,"DMBT3" ,"WRBT3" ,"QSSKZ" ,"QSSHB" ,"QBSHB" ,"BSTAT" ,"ANFBN" ,"ANFBJ" ,"ANFBU" ,"VBUND" ,"REBZT" ,"STCEG" ,"EGBLD" ,"EGLLD" ,"QSZNR" ,"QSFBT" ,"XINVE" ,"PROJK" ,"FIPOS" ,"NPLNR" ,"AUFPL" ,"APLZL" ,"XEGDR" ,"DMBE2" ,"DMBE3" ,"DMB21" ,"DMB22" ,"DMB23" ,"DMB31" ,"DMB32" ,"DMB33" ,"MWST2" ,"MWST3" ,"SKNT2" ,"SKNT3" ,"BDIF3" ,"XRAGL" ,"RSTGR" ,"UZAWE" ,"KOSTL" ,"LNRAN" ,"XSTOV" ,"KZBTR" ,"XREF1" ,"XREF2" ,"XARCH" ,"PSWSL" ,"PSWBT" ,"IMKEY" ,"ZEKKN" ,"FISTL" ,"GEBER" ,"DABRZ" ,"XNEGP" ,"EMPFB" ,"PRCTR" ,"XREF3" ,"DTWS1" ,"DTWS2" ,"DTWS3" ,"DTWS4" ,"XPYPR" ,"KIDNO" ,"PYCUR" ,"PYAMT" ,"BUPLA" ,"SECCO" ,"PPDIFF" ,"PPDIF2" ,"PPDIF3" ,"PENLC1" ,"PENLC2" ,"PENLC3" ,"PENFC" ,"PENDAYS" ,"PENRC" ,"VERTT" ,"VERTN" ,"VBEWA" ,"KBLNR" ,"KBLPOS" ,"GRANT_NBR" ,"GMVKZ" ,"SRTYPE" ,"LOTKZ" ,"ZINKZ" ,"FKBER" ,"INTRENO" ,"PPRCT" ,"BUZID" ,"AUGGJ" ,"HKTID" ,"BUDGET_PD" ,"KONTT" ,"KONTL" ,"UEBGDAT" ,"VNAME" ,"EGRUP" ,"BTYPE" ,"PROPMANO" ,"INWARDNO_HD" ,"INWARDDT_HD" FROM "BSIK" WHERE "MANDT" = ? AND "LIFNR" IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND "BUKRS" = ? AND "BUDAT" <= ? /* R3:SAPDBKDF:9989 T:BSIK M:010 */

• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP ERP 6.0

FBL1N, BUKRS, BSIK, BSAK, BKPF, slow, "Company Code", query, performance , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem