customer ageing

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

thanks