topic Re: function module to read bkpf table in Application Development and Automation Discussions

function module to read bkpf table

Former Member — Thu, 06 Nov 2008 10:59:00 GMT

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 ?

Re: function module to read bkpf table

Former Member — Thu, 06 Nov 2008 11:06:47 GMT

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

Re: function module to read bkpf table

Former Member — Thu, 06 Nov 2008 11:08:47 GMT

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

Re: function module to read bkpf table

Former Member — Thu, 15 Jan 2009 04:02:25 GMT

Thanks guru