Performance Issue in ABAP coding

[debdatta_panda]

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

[Former Member]

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

[debdatta_panda]

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

[hiriyappa_myageri]

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.

[Former Member]

Hi,

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

Regards,

Klaus

[debdatta_panda]

Hi,

    Not updated VBAP-AUFNR field..

[debdatta_panda]

Hi,

    Can you please tell me elaborately..

[Former Member]

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