Skip to Content
0
Former Member
Jun 29, 2009 at 04:34 AM

Performmance in ADRC and KNA1 Data Fetching

120 Views

Hi,

In My report,

I have S_FLOOR as secet-option which is type ADRC-FLOOR.

I want to get Addressnumber based on FLOOR from ADRC and Based on ADRESSNUMBER I want to fetch Kunnr, Name1, Name2 etc from KNA1.

But as Addressnumber is not the primary key of KNA1, its taking too much time.

I am using for all entries, then also taking more time.

how can I improve the performance.

I cant fetch KNA1 data first as there is arourd 4 Lacs of record.

Can any body suggest me ?

Thanks

Kumar