topic customer ageing in Application Development and Automation Discussions

customer ageing

Former Member — Sat, 18 Apr 2009 04:43:10 GMT

HI Experts,

I have made a report thats based on customer ageing..i have used BSID & BSAD tables in that..since its a ageing report i have to fetch the whole data upto current date..Now 1 more condition has been added into it that i have to check for the reversed documents n if i find any then delete that particular document along wid the document that is reversed..That reversed document in in BKPF table & the field is STBLG..wen i used this table for this particular condition report becomes preety slower..I have tried for all entries & all performance oriented things but nothin would help..Can any expert guides me is there any other way i can find that reversed document without using BKPF table..Or if anyone can send me similar report based on customer ageing then i wud b highly thankful...

Regards,

Raman

Re: customer ageing

Former Member — Sat, 18 Apr 2009 06:11:05 GMT

Hi Raman,

According to me you should use date, year in selection parameter, and you should fetch data maximum for one fiscal year, And try to use fields according to table index in where conditions....

I hope it will help you.....

Re: customer ageing

Former Member — Sat, 18 Apr 2009 06:45:32 GMT

You will have to hit BKPF to get the reversed document (STBLG). But, when you are trying to fetch this document try to pass on the company code and fiscal year (which you can get from BSAD table) along with the document number to the where condition in SELECT statement. That would minimize the time taken to fetch the reversed document.

Re: customer ageing

Former Member — Mon, 01 Jun 2009 05:45:19 GMT

thanks