Performance issue with table BDDCPV

[Former Member]

Hi All,

I am facing the performance issue with table BDCPV.

The below code has written in standard include LBD01F03 which is taking lot of time execute.

select * from bdcpv
into corresponding fields of table pto_change_pointers
where mestype eq pi_message_type
and process eq pi_processed_flag
and cretime in pti_creation_time
and acttime in pti_activation_time
and cdobjcl in pti_cd_object_class
order by cpident.

I have observed that only one record exit in table BDCPV with mentioned where condition but it took more than 30 mins to execute .

I am executing the SE38->RBDMIDOC and entering the message type /SAPSLL/PRCMAT_SLL. the above metioned query is getting called and taking more time.

Could you please let me how to improve the performance. i hope we can not create indexes for BDCPV.

Regards,

sateesh