function module to read bkpf table

[Former Member]

Hello everybody ,

i want to read BKPF table but their is lot's of record in table BKPF .

i used select query , now report is taking time .

i want to reduce performance time .

is their anyway to read BKPF table so that report will take less time ?

or is their any function module available ?

[Former Member]

Hi,

There are function modules (FAGL_GET_BKPF) to read values from BKPF.. but they can read single values at a time....

According to me Make the SELECT statement with conditions to match all the key fields of BKPF table (BUKRS, BELNR, GJAHR.)

And maintain the order of fields according to database. this will greatly reduce time...

and also do not use INTO CORRESPONDING FIELDS OF..

[Former Member]

Hi,

As BKPF table is transparant table use key fields in where clause or create a secondary index based on u r where clause and use it to reduce the runtime.

Regards,

Nandha

[Former Member]

Thanks guru