Performmance in ADRC and KNA1 Data Fetching

[Former Member]

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

[Former Member]

create Index for the table KNA1, with the below fields then fetch the data. It improves the performance.

MANDT

KUNNR

ADRNR

[Former Member]

Hi,

I have created also secondary index, but not working.

Any other option ?

Thanks

naresh

[Former Member]

Hi Kumar,

There will be more entries in adrc when compare to kna1 table. first you neeed to fetch customer details from kna1 either using indexing or not. then match adress number with adrc table.

and also use the customer account group field kna1-ktokd to restrict the no of entries.

Kna1 table won't make much performance issue.

Regards,

Ravi.

[GauthamV]

Performance related queries are to be posted here.

[Former Member]

Hi:

You need to search the funciton module for it and use it.

Regards

Shashi

[Former Member]

while selecting entries from a table for all entries

u should check

1)sy-subrc

2)and the itab[] is not initial

becoz when the internal table is initial it will fetch all the data from the table for which u r using for all entries

[former_member555112]

Hi,

You can use the FM ADDRESS_INTO_PRINTFORM to get the address from the address number.

Regards,

Ankur Parab

[Former Member]

Hi,

Once you get bthe address no access table ADRV with ADDRNUMBER = required address no & APPL_TABLE = 'KNA1' and APPL_FIELD = 'ADRNR' this will return a unique record. You will get the customer codes form field APPL_KEY.

I hope this helps,

Regards

Raju chitale