SAP Knowledge Base Article - Preview

2836607 - DataSource Transactional Data 0FI_GL_14 extractor is very slow - SAP BW on SAP ASE


SAP Business Warehouse (BW) Delta extractor 0FI_GL_14 is very slow on SAP ASE database.

Corresponding slow sql query is:

SELECT "A" ."RYEAR" ,"A" ."DOCNR" ,"A" ."RLDNR" ,"A" ."RBUKRS" ,"A" ."DOCLN" ,"A" ."ACTIV" ,"A" ."RTCUR" ,"A" ."RUNIT" ,"A" ."AWTYP" ,"A" ."RRCTY" ,"A" ."RVERS" ,"A" ."LOGSYS" ,"A" ."RACCT" ,"A" ."COST_ELEM" ,"A" ."RCNTR" ,"A" ."PRCTR" ,"A" ."RFAREA" ,"A" ."KOKRS" ,"A" ."SCNTR" ,"A" ."PPRCTR" ,"A" ."SFAREA" ,"A" ."TSL" ,"A" ."HSL" ,"A" ."KSL" ,"A" ."OSL" ,"A" ."MSL" ,"A" ."WSL" ,"A" ."DRCRK" ,"A" ."POPER" ,"A" ."RWCUR" ,"A" ."GJAHR" ,"A" ."BUDAT" ,"A" ."BELNR" ,"A" ."BUZEI" ,"A" ."BSCHL" ,"A" ."BSTAT" ,"A" ."TIMESTAMP" ,"B" ."BUKRS" ,"B" ."BLART" ,"B" ."BLDAT" ,"B" ."MONAT" ,"B" ."CPUDT" ,"B" ."XBLNR" ,"B" ."WAERS" ,"B" ."GLVOR" ,"B" ."AWKEY" ,"B" ."FIKRS" ,"B" ."HWAER" ,"B" ."HWAE2" ,"B" ."HWAE3" ,"B" ."AWSYS" ,"B" ."LDGRP" ,"B" ."KURSF" FROM "FAGLFLEXA" "A" INNER JOIN "BKPF" "B" ON "B" ."BUKRS" = "A" ."RBUKRS" AND "B" ."BELNR" = "A" ."BELNR" AND "B" ."GJAHR" = "A" ."GJAHR" AND "B" ."MANDT" = "A" ."RCLNT" WHERE "A" ."BUDAT" BETWEEN ? AND ? AND "A" ."RLDNR" = ? AND "A" ."RCLNT" = ? AND "B" ."MANDT" = ? /* R3:SAPLFAGL_ITEMS_SELECT_BW:618 T:FAGLFLEXA M:200 */

Per ST12 sql trace, Cursor commands on BKPF, FAGLFLEXA: OPEN and FETCH are the slowest



  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions


SAP NetWeaver 7.5


0FI_GL_14, BW,  FAGLFLEXA, "Delta extractor", slow, performance, cursor, fetch, intelligent index scan, intelligent_index_scan , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.