Guideline Performance Initial Download from SAP for Utility into SAP CRM

[friedrich_keller]

Hello,

Please find below a link (valid for 10 weeks) to the document Guideline Performance Initial Download from SAP for Utilities into SAP CRM. The document is also published in the SAP Service Market Place at http://service.sap.com/utilities. Then choose Technical Information Center - Migration.

The purpose of the document is to give guidelines as well as to share experience for an efficient and high performance execution of an initial download from an SAP for Utilities system to an SAP CRM system, such as:

- Configuration of the initial download

- Ensure optimum performance for the initial download of the relevant business objects

- Avoid unnecessary business data being downloaded

- Monitoring of the initial download and taking corrective actions in case of problems

- Handle errors occurring during the initial download of business objects

- Minimize performance bottlenecks

The document explains the setup and configuration of the SAP for Utilities and SAP CRM systems only if necessary for the understanding of the solution of a described performance problem. This document does not cover the performance optimization of the delta down- and upload and the synchronization download.

The document has the following structure:

Chapter 1 describes the basics of an initial download

Chapter 2 describes how to plan and execute tests to achieve an acceptable performance

Chapter 3 describes the most important technical activities to prepare the involved systems

Chapter 4 describes the most important functional activities to prepare the involved system

Chapter 5 describes how to perform an initial download

Chapter 6 describes measures to improve the performance of an initial download

Chapter 7 provides a list of important repository tables

Chapter 8 contains a list of important SAP Notes related to initial download

I'd highly appreciate your valuable feedback on this document.

Kind regards,

Fritz

Edited by: William Eastman on Feb 17, 2011 2:34 PM

[former_member920902 · Accepted solution]

Hi Fritz,

I'm missing one important information (for the moment): For the initial load of the business agreements it is necessary to deactivate the scenario buffering in table T77OMATTR, otherwise the update process of table indx uses most of the work processes.

Thanks.

Alexander Schiffer

[friedrich_keller]

Hello Alexander,

Thank you for your feedback.

I am not sure I understand your recommendation (deactivate the scenario buffering). Do you mind adding some more details, such as

(1) on which system did you monitor the described behavor (update process of table indx uses most of the work processes)

(2) on which system the change should be implemented

(3) what exact kind of change should be implemented

Thanks & kind regards,

Fritz

[former_member920902]

Hi Fritz,

sorry for the late late reply but I didn't notice your answer.

Here are my answers:

(1) I monitored the behaviour on the CRM system, CRM 7.0, SP5

(2) The change should be implemented in the CRM system

(3) Deactivate buffering for scenarios marketing, sale and service via SM30 and table T770MATTR.

By doing this the initial load of 3.2 million business agreements took around 2 hours, with activated scenario buffering I was at least ten times slower.

After the initial load you have to activate the buffering again.

Interesting to know would be why the scenario buffering only affects the initial load of business agreements and no other object. As far as I know the scenario buffering is relevant for the organizational management.

Regards

Alexander

[shahidulalam_siddique]

Hi Fritz,

I was late viewing the document. Is it possible to get that document?

Regards,

Shahid

[william_eastman]

Shahid:

The original posting has the link to the location on the service marketplace and the link is in the sticky thread at the top of the forum.

regards,

bill.