Skip to Content
0

Performance issue with table BDDCPV

May 28, 2017 at 08:23 AM

26

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers