Enhanced Datasource 0BP_DEF_ADDRESS_ATTR extraction slowness

[Former Member]

Hi,

I faced a performance problem need your help.

I enhanced datasouce 0BP_DEF_ADDRESS_ATTR in ECC side to extract two more fields using user exit. The souce code is below.

But the InfoPackage running is extremely slow in BI side, over 10 hours to complete. Is there anybody can

help me and advise how can I fix this performance problem? I really appreciate your kindly help.

&----Enhancement for NGS NQR by NAWANG 06102009 -

---

&----Declaration -

---

DATA:

l_s_BUS_PARTNER_ADDRESS_BW LIKE BUS_PARTNER_ADDRESS_BW,"BUS_PARTNER_ADDRESS_BW is structure of DataSource 0BP_DEF_ADDRESS_ATTR

lo_bas type ref to cl_hrrcf_address_service.

DATA ps_addressdata type RCF_S_ADDRESSDATA_BP.

DATA ps_telefondata type RCF_S_TELEFONDATA_BP.

DATA ps_faxdata type RCF_S_FAXDATA_BP.

DATA ps_emaildata type RCF_S_EMAILDATA_BP.

DATA l_index type i.

*

&----End of Declaration -

---

CASE i_datasource.

&----

---

Enhancement of 0BP_DEF_ADDRESS_ATTR -

---

WHEN '0BP_DEF_ADDRESS_ATTR'.

LOOP at I_T_DATA INTO l_s_BUS_PARTNER_ADDRESS_BW.

l_index = sy-tabix.

TRY.

call method cl_hrrcf_address_service=>get_instance

exporting

businesspartner = l_s_BUS_PARTNER_ADDRESS_BW-PARTNER

importing

instance = lo_bas.

CATCH CX_HRRCF_ADDRESS_SERVICE .

ENDTRY.

CLEAR:ps_addressdata,ps_telefondata.

if lo_bas is not initial.

call method lo_bas->get_preferred_contact_data

importing

addressdata = ps_addressdata

telefondata = ps_telefondata

faxdata = ps_faxdata

emaildata = ps_emaildata.

endif.

l_s_BUS_PARTNER_ADDRESS_BW-ATYPE = ps_addressdata-CHANNEL.

l_s_BUS_PARTNER_ADDRESS_BW-CTYPE = ps_telefondata-CHANNEL.

MODIFY I_T_DATA FROM l_s_BUS_PARTNER_ADDRESS_BW index l_index.

ENDLOOP.

&----

---

End Enhancement of 0BP_DEF_ADDRESS_ATTR -

---

ENDCASE.

Edited by: Wang Nanshu on Oct 29, 2009 6:52 AM

Edited by: Wang Nanshu on Oct 29, 2009 6:53 AM

Edited by: Wang Nanshu on Oct 29, 2009 6:54 AM

Edited by: Wang Nanshu on Oct 29, 2009 6:56 AM

Edited by: Wang Nanshu on Oct 29, 2009 6:57 AM

Edited by: Wang Nanshu on Oct 29, 2009 6:57 AM

[Former Member · Accepted solution]

Hi,

How the data is showing for the enhanced fields in ECC in transaction code RSA3.

If it takes time, use break point to debug.

Regards

Rama Murthy.

[Former Member · Accepted solution]

The data extraced is right. Just running very slow. I am not sure if I can optimize the source code or create some indexes to improve the perfromance. Any advise?