2008 Jun 24 7:50 AM
hi,
i have a report which i have to performance tune.
the report is using above function module (CHANGEDOCUMENT_READ_HEADERS) and passes a single objectid which is fetched from EKKO-eblen.
so, this function module continuously accesses the cdpos and cdhdr tables for all of EKKO entries causing a performance problem.
is there any alternative by which i can process multiple EBLEN at one go?
is there any function module which does the same?
can i replace the functioning of this function module by a select query on respective tables?
2008 Jun 24 7:55 AM
hi
refer to this link
http://help.sap.com/saphelp_nw04/helpdata/en/2a/fa01dd493111d182b70000e829fbfe/frameset.htm
Reward points if usefull
Cheers
Snehi
2008 Jun 24 8:04 AM
Hi,
The FM CHANGEDOCUMENT_READ_HEADERS reads the change document numbers, with the associated header information, for a particular change document object. Passing only the object ID would naturally result in huge execution times. You need to pass the object class also along with this.
Or else you can make use of CDHDR and CDPOS tables directly using a select query to get the same information.
The object class OBJECTCLAS has to be passed as 'EINKBELEG' for Purchase orders. And the object id OBJECTID has to be the purchase order number.The TABNAME field has to contain the table name (EKKO in the case of purchase orders). The retrieval would be faster in this way.
Thanks.