Archiving the entries of table BBP_PDVIEW_BUP in EBP 3.0 System

[Former Member]

Hi SRM Gurus,

I want to Archive the entries of table "BBP_PDVIEW_BUP " in EBP 3.0 system. Is there any provision to archive, as our EBP system performance is very slow.

And what are means to improve the performance of EBP system

please help me.

Thanks,

Ramesh

[Former Member]

Hi,

What is your requirement?Can you paste the code whcih you are using to retrieve the entries from this table?

BR,

Disha.

Pls reward points for useful answers.

[Former Member]

Hi Disha,

My requirement is to improve my EBP 3.0 system performance. After thorough investigation we found Millions of entries in the Table BBP_PDVIEW_BUP. Further we want to archive the table entries. What are the means to archive the table entries. Please let me know.

Thanks,

Ramesh

[Former Member]

Hi

<b>Please go through the following SAP OSS Notes, which definitely will help.</b>

<u>Note 981876 BBP_PDH_TRANSFORM_LOCATION - performance problems

Note 868382 SRM Sourcing Cockpit

Note 625344 Status change not possible because follow-on docs exist

Note 840028 EBP 3.5-5.0: Performance improvement for scorecard monitor

Note 721358 Perfomance improvements for list displays

Note 650592 Performance improvements in list displays

Note 766354 Name formatting for requester in sourcing cockpit

Note 696854 BBP_BW_SC_SELECT_1: Vendor / Preferred vendor

Note 726168 search for contracts does not work with multicompany scen.

Note 711277 Documents found in which the searched partner is deleted

Note 375330 Performance problems BBPPU99 - Collective note

Note 501921 Search for confirmations/invoices according to PO number

Note 568781 Performance improvement of search modules (GetList)

Note 585844 Search also takes deleted partners into account

Note 460000 Incorrect selection of shopping baskets

Note 514218 - EBP 3.0-3.5: Maximum number of hits in local SC reporting

Note 511181 Unprocessed exception when sourcing cockpit is called up

Note 501048 Dump SAPSQL_STMNT_TOO_LARGE with search for purchase order</u>

Regards

- Atul

[Former Member]

Hi Atul,

Could you please confirm whether the table entries of EBP 3.0 can be Archived or not. If yes What are the notes to implement.

Thanks,

Ramesh

[Former Member]

Hi

<u>I don't think is posible to archive entries, since this a Database view; not a datbase table.</u>

For more details, please raise an OSS Message with SAP on this at the earliest.

Do let me know.

Regards

- Atul

[Former Member]

Hi Atul,

Could you pl guide me what are archiving objects available in EBP 3.0 system. And send me some links to refer the archiving procedure. I have not done so far. Can we do archiving underlying table entries for the table view. Pl help.

Thanks and Regards,

Ramesh

[Former Member]

Hi Ramesh,

Please go through the link below. hope this help you.

http://help.sap.com/saphelp_srm50/helpdata/en/7e/c8df3b6ac34b44e10000000a114084/frameset.htm

Cheers

Iftekhar Alam

[Former Member]

Hi Ifthekhar,

Can I get Help Documentation link for EBP 3.0( SRM 1.0). Pl help me.

Regards,

Ramesh

[Former Member]

Hi

<u>You can look for the transaction - <b>SARA</b> in the EBP 3.0 system.</u>

<b>Please go through this link for EBP 3.0 details for Archiving -></b>

<u>http://help.sap.com/saphelp_srm30/helpdata/en/15/c9df3b6ac34b44e10000000a114084/frameset.htm</u>

Hope this will definitely help.

Regards

- Atul