topic Performance Issue in ABAP coding in Application Development and Automation Discussions

Performance Issue in ABAP coding

debdatta_panda — Fri, 05 Sep 2014 06:32:00 GMT

Hi Experts,

I am facing performance issue when fetch the data from view IAOM_CRM_AUFK.My perspective to fetch the internal order from that table by passing the OBJECT_ID which is not the primary key..Also the field IHREZ is not the primary key of table VBKD..

My code is under....

select EXT_OBJECT_ID

AUFNR

OBJECT_ID

into table IT_EXAT

from IAOM_CRM_AUFK

client specified

for all entries in IT_VBKD

where OBJECT_ID = IT_VBKD-IHREZ.

Please give the wayout by which I can fetch lot of data without performance issue..

Re: Performance Issue in ABAP coding

Former Member — Fri, 05 Sep 2014 06:48:19 GMT

Hi,

are you sure you're accessing with the right fields?

OBJECT_ID is of domain CRM_OBJECT_ID_CO with type CHAR length 10 and conversion exit ALPHA, while IHREZ is of domain TEXT12 with LOWER CASE letters.

This is looking strange to me.

OBJECT_ID is no good access to view IAOM_CRM_AUFK, which is based on access with field EXT_OBJECT_ID. You can't speed it up, although a secondary index of field OBJECT_ID in table IAOM_CRMSRV_EXAT might be an idea.

Regards,

Klaus

Re: Performance Issue in ABAP coding

debdatta_panda — Fri, 05 Sep 2014 07:01:17 GMT

Hi,

I have maintain IHREZ of table VBKD this way.

IHREZ type IAOM_CRM_AUFK-OBJECT_ID,

I know that OBJECT_ID is no good access to view IAOM_CRM_AUFK..But I have no way..Because I have got IHREZ from VBKD table which only match with the field OBJECT_ID of view IAOM_CRM_AUFK...

I have to fetch internal order no. on the basis of Sales order no..Forr this reason First I have put Sales order no in VBKD table and get IHREZ and then put IHREZ in the field OBJECT_ID of view IAOM_CRM_AUFK..then I have got AUFNR which is internal order..

Please give me the way which will enhance my coding execution speed..

Re: Performance Issue in ABAP coding

hiriyappa_myageri — Fri, 05 Sep 2014 07:10:35 GMT

if you are using non primary key fields in your for all entries statement means ..it will take long time.

Better u can write separate select query for both. do some delete operations in loop based on ur vbkd table.

Re: Performance Issue in ABAP coding

Former Member — Fri, 05 Sep 2014 07:10:56 GMT

Hi,

please check, if there is a connection between sales order and internal order in field VBAP-AUFNR.

Regards,

Klaus

Re: Performance Issue in ABAP coding

debdatta_panda — Fri, 05 Sep 2014 07:55:54 GMT

Hi,

Not updated VBAP-AUFNR field..

Re: Performance Issue in ABAP coding

debdatta_panda — Fri, 05 Sep 2014 07:57:07 GMT

Hi,

Can you please tell me elaborately..

Re: Performance Issue in ABAP coding

Former Member — Fri, 05 Sep 2014 08:29:56 GMT

Hi,

can you please check, if there is a connection in table AUFK like

You may need a Z-Index for this access too like

Regards,

Klaus