Performance issue

[ashok_kumar24]

Hi Experts,

I am facing a performance problem in developing a custom report.

I am selecting billing documents from VBRK and then retrieving the corresponding accounting documents. It is taking a lot of time while retrieving the accounting documents. Sometimes I am getting a Timed out message and report is not getting executed.

Is there any function module or any other table to get the accounting document for a billing document to solve this performance issue.

Thanks

AK

[Former Member]

Hi Ashok,

Are you using VBELN field in where class ? since that is the primary key we should use to avoid performance issue, if you could not able to give then try to use at least secondary index.

regards,

• Dj

reward for all useful answers.

[Former Member]

Hi,

Yes take the Object no in vbrk and verify with COSS and COSP or get the entries from GLPCA table.

Or Using the GL account no, vbeln u can fetch the values in bsis table also

Regards,

Nandha

Reward if it helps

[Former Member]

hi accounting related function modules

J_3RF_CHECK_PROFTAX_ACTIVE Check if profit tax accounting solution is active

KSPC Master data cost centers+profit centers

CHOISE_INTERVAL Master data maintenance for cost center accounting and profit center

MBLG Access routines to accounting documents

BELEGKOPF_LESEN Access routine for accounting document headers

BELEGPOSITION_LESEN Retrieve items of an accounting document

N026 IS-H: Enter RF Data in R/2 From R/3

ISH_INSERT_FINANCE_R2 IS-H: Transfers invoices (SD) to financial accounting (RF/R2)

NE00 IS-H: User Exits

ISH_USER_EXIT_DEBI IS-H: Determines user exit to fill financial accounting data

OIU_COMMON E&P Common Functions

OIURV_INV_CURR_ACCOUNTING_DATE Calculates the current accounting month minus the offset for Inventor

RPHI Cluster Directory (High Level-Functions)

CD_PAYROLL_RETRO Determines the retroactive accounting date for a specified payroll re

WNM0 Methods for Rebate Arrangement

MM_ARRANG_METHOD_SETTLEMENT Settlement accounting w. regard to reb. arrangements ("settlement" me

FIAA_FIND_FKBER_TO_KOSTL Cost-of-sales accounting: Determine functional area from cost center

FIAA_UKV_ACTIV Check for active cost-of-sales accounting

CMACFEE9 Events Used In Student Accounting

CMAC_SAMPLE_P903 Tax generation in student accounting

F033 Link to Optical Archive

CONFIRM_FI_DOCUMENT Confirmation of file accounting document

FIPI Internal FI Posting Interface

POSTING_INTERFACE_START Initial information for internal accounting interface

FMFG_BLCORE Budgetary Ledger Core

FM_BL_CALL_ACC_INTERFACE Calls the accounting interface in own task to check results

GMRRB GM: Resour-related Billing

GM_RRB_GRANT2ACCIT Move grant to accounting doc items

HROV HR-PSG: PS pension recipient (D)

HR_VERSORGUNG_PRUEFEN_HB HR-PSG: Check RA accounting for surviving dependent against pension hol

HRPIQ00AC Interface to student accounting

HRIQCA_FEE_CALCULATION Fee calculation - student accounting

HRPIQ00ACINFO Read student information for pricing

HRIQ_READ_SUBSTITUTED_SESSION Read substituted session in student accounting

HRPIQ00CUSTOMIZINGCHECK Customizing check Function Modules

HRIQ_CHK_ACCOUNT_CUSTOMIZING Check the Necessray customizing for fee calculation/accounting

HRPIQ00FACHG Write and Eveluate change pointer for CM

HRIQ_INFTY_CHANGE_PROT Obsolete: Write change pointer for student accounting

HRUPBS01 HRMS PBS Payroll functions

HR_PRINT_10_DNRCT Table DNRCT: Differences for nonresident retroactive accounting

HR_PRINT_10_DNRCT_HEAD Table DNRCT: Differences for nonresident retroactive accounting

J1AX SD for Argentina: Posting to FI

J_1A_ACC_DOCULIST_CREATE customer accounting document invoice list (DO NOT USE!!!)

J_1A_ACC_DOCUMENT_CREATE Revenue account determination and customer accounting document

J3RFTAX_TAXOBJSEL Tax object selection

J_3RF_CHECK_PROFTAX_ACTIVE Check if profit tax accounting solution is active

KSPC Master data cost centers+profit centers

CHOISE_INTERVAL Master data maintenance for cost center accounting and profit center

MBLG Access routines to accounting documents

BELEGKOPF_LESEN Access routine for accounting document headers

EXIT_SAPLJ1AX_001 User-exit transfer to accounting header line

EXIT_SAPLJ1AX_002 User-exit transfer to accounting A/R line

EXIT_SAPLJ1AX_003 User-exit transfer to accounting cash clearin

EXIT_SAPLJ1AX_004 User-exit transfer to accounting G/L line

EXIT_SAPLJ1AX_005 User-exit transfer to accounting reserves

EXIT_SAPLJ1AX_006 User-exit transfer to accounting tax line

regards

ravish

<b>plz dont forget to reward points if helpful</b>

[Former Member]

The problem may be the way you are reading BKPF. Could you post your code for this?

It can happen that people add too many fields to the WHERE clause and confuse the query optimiser as to which index to use.

[Former Member]

You have to select agains BKPF using both AWTYP and AWKEY.

Rob