Wednesday, February 4, 2009

Note 766827 - Composite SAP note: Performance SCM 4.0

Note 766827 - Composite SAP note: Performance SCM 4.0

Summary

Symptom

Performance problems with an SCM APO 4.0 installation

Other terms

SAP APO, performance, runtime, response performance, index, statistics

Reason and Prerequisites

This is a composite SAP note that refers to additional notes containing descriptions, corrections, proposals and improvements that can help to improve the performance of an SCM APO 4.0 system.

Solution

Select the notes that are relevant for your scenarios and before installing them, check whether these are valid for your system environment as regards your Support Package version.

Header Data



Release Status:Released for Customer
Released on:23.08.2004 14:36:57
Master Language:German
Priority:Correction with medium priority
Category:Performance
Primary Component:SCM-APO-MD Master Data

Affected Releases

Software
Component
Release
From
Release
To
Release
And
subsequent
SCM
400
400
400

Related Notes




821044 - Drill down in SNP planning book too slow

812709 - Composite SAP note: Performance of SNP in SCM 4.1

764687 - Composite SAP Note, performance during statistics update

753137 - Composite SAP note: Performance in SNP for SCM 4.0

731583 - Perf VS: Reading VS alerts without optimization profile

728328 - Performance when fixing/unfixing operations

725489 - MaxDB performance analysis tools

708136 - iSeries: No monitor data in ST06

705394 - Performance enhancement for Inventory Monitor

703353 - Nonsensical times with /SAPAPO/OM_PERFORMANCE

701309 - Performance Price - $ tiers not calculating

701077 - FAQ 2: PS Period End Closing

700599 - DB6:Dependency between query performance and InfoCube Layout

670973 - Corrections for Planning Board

661034 - BAdI method enhancement for AHT

652634 - FOR ALL ENTRIES performance with Microsoft SQL Server

650839 - Hiding the test guid with /SAPAPO/OM_*GET_ALL modules

650449 - Collective note for GATP Performance in SCM 4.0

650115 - Reading forecast schedule lines for OrderIDs

647075 - Restrictions for SAP Mobile Asset Management 2.0

631485 - Improving dataloader performance

629473 - Interactive planning: High GUI runtimes

627180 - Planning Engine: Error in performance log

625755 - Performance in TP/VS: using new shipment structure

625253 - Incorrect requirements, lock error, short dump, performance

621180 - Performance Warning should be popup after selection

619188 - FAQ: Oracle wait events

618868 - FAQ: Oracle performance

608636 - SQL Server 2000 does not maintain Performance Counter values

608577 - Composite SAP note for CIF-performance in SCM 4.0

607428 - Product planning table - FAQs

603388 - LOC: Deactivating the change management for address data

596263 - CJ20N: consulting note: performance in the Project Builder

573905 - Performance problems during the BP search

572060 - Options in the Oracle database during archiving

566527 - Composite SAP Note for DP performance in APO 3.1

561547 - Planning file entry is cancelled despite shortage

548624 - FAQ: Performance Monitors, R/3 Syslog, System Availability

547791 - FAQ: Material master performance

546262 - DB6:Administration & Performance on SAP BW, SAP SCM, SAP SEM

519014 - Handling Planning Version Management.

515376 - Missing or incorrect values in the ST04 initial screen

505897 - Performance overview - consolidation

503657 - Index note for Pricing related issues in Mobile Sales

501156 - DP90/DP95: Composite SAP Note for performance notes

500063 - Overview of performance notes for the Alert Monitor

495821 - Remaining consistent views

485018 - Info on the Performance of the Optimizer

482494 - Loading data from liveCache: Performance optimization

454553 - APO COM object or liveCache performance problems

446168 - Earned Value Component Overview

426563 - CTP: Settings, system behavior and performance (docu)

420602 - Composite SAP Note for CIF performance in APO 3.10

420601 - Composite SAP Note for CIF performance in APO 3.0A

420600 - Composite SAP Note for R/3 Plug-In performance

420594 - Composite SAP Note for DP performance in APO 3.0A

420493 - Collective note: Cost center assessment performance COPA

419173 - Collective note 'IS-IS-CD performance'

417539 - CRM Mobile Client: Performance MSSQL

398041 - INFO: CO-OM/IM-Content (BW)

390016 - DB2/390: BW: Database settings and performance

388198 - ITS performance problems - Monitors and log files

374502 - DB6: DB2 UDB - BW Performance - Overview of notes

356801 - Performance problems based on a wrong optimizer decision

354080 - Note collection for Oracle performance problems

350439 - CS tracing - Performance for order history poor

334837 - Performance problems with SAPGUI for Java on Unix

331535 - Runtime capacity evaluation

327494 - Configuration Parameters for SQL Server 2000

307077 - iSeries: Performance optimization for BW systems

306576 - COMPOSITE NOTE: performance overheads

304250 - Performance during summarization

213546 - HPR collective note: POS inbound

206690 - Overview Note: CO Assessments - Performance Related

203845 - Performance of mySAP.com Workplace

203075 - Capacity Planning: summary of performance notes

153560 - CATS: Collective note on performance

152877 - Impact of adding a container to a tablespace

147634 - DB6: Tips and tricks for creating DB2 tablespaces

142644 - DART performance problems

127642 - RSCOLL00: Tuning COLLECTOR_FOR_PERFORMANCEMONITOR

118743 - Collective note performance in SD

114930 - Performance improvement when copying recipes

101113 - AS/400: Analysis of performance problems

83562 - Performance in results analysis of sales orders

71595 - @1B@Search help for notes regarding routings

64001 - INFCFGCHECK: Detailed messages of single checks

60233 - Oracle rollback segments, more information.

36677 - Structure of components for customer messages

23278 - MD01, MDBT: Performance during MRP run

23234 - Backup of large databases with BRBACKUP

Note 566527 - Composite SAP Note for DP performance in APO 3.1

Note 566527 - Composite SAP Note for DP performance in APO 3.1

Summary

Symptom

Performance problems occur in SAP APO Demand Planning.

Other terms

Performance, Demand Planning

Reason and Prerequisites


This is a composite SAP Note with references to more notes, that contain descriptions, corrections, proposals and improvements which can contribute to the improvement of the performance of an SAP-APO system 3.0 or 3.1.

@1D@ This Note is not updated anymore. Due to its
scope it was converted in a more user-friendly format.
Use the following link and use the current document
on the SAP Service Marketplace.
http://service.sap.com/~form/sapnet?_FRAME=CONTAINER&_OBJECT
=011000358700002439142002

Or the path
http://service.sap.com/scm -> mySAP SCM Technology
-> Performance and Configuration


The document which opens contains a macro which you ought to confirm in the beginning to be able to use the selection options optimally.

Solution


Select the notes relevant for your scenarios and check prior to the implementation, whether they are valid for your system environment concerning your support package status.


Collection of the performance-relevant notes for APO FCS 3.1

Support Package independent:
512184 Background processing: Periodically delete job log
426806 Memory/performance problems during data extraction
549184 FAQ: What is important for extraction
546079 FAQ: Background jobs in Demand Planning
378509 Oracle DB parameter setting for APO
540571 Collective consulting note for data extraction in
521639 Generation of DB alerts in the background
512184 Background processing: Job log periodic
503363 Use and administration of fixed aggregates in the
519014 Processing of the planning version administration
403050 DP 3.0 consulting: Release of DP to SNP
398726 DP 3.0: Planning book/data view performance
428102 Performance: Loading planning area version
357789 APO 3.0 consulting: Horizons forecast and planning folder
458131 BW reporting in APO systems
458077 For all entries: Performance problems in APO Demand

SP14

591248 Performance improvement when excluding PPM read.
576150 Performance Problems After Running a Drilldown Macro

SP13
575150 Modification of promotion reporting, nodes are not expanded Nodes become ex
576071 Performance improvement during extraction of data
573816 Improvement of performance during planning consumption
566930 CBF performance when selecting values
552240 Performance improvement with use of

SP12
558820 Long runtime in planning planned indep.
558709 Addition of the note 529663
564316 Small improvements life cycle profile assignment

SP11
555136 Performance problem during realignment
556098 Performance improvement about reading the shipping calendar
551862 Improved performance for consumption in the CIF
generat.
of characteristics combinations from IC
549136 After deletion of note incorrect icon displayed
547901 Initialization of DP BOM relation:

SP10
537076 Notes for partial selections
522249 Performance realignment of notes
546093 Extraction of InfoCube key figures with APO/BW requests
543015 Performance improvement during plan explosion with CBF
541028 Performance improvement during update II
545598 CBF: performance improvement in BOM explosion

SP9
543275 Performance improvement with location selection
377831 /SAPAPO/T445SELO or /SAPAPO/TSSELORG not compared
537058 Improving performance when navigating in the grid
530504 Improving performance in the grid

SP8
525044 Performance, consistency of key figures (InfoObjects)
528590 Performance improvement when reading charact.
525233 Initialization of DP BOM relation:
529607 Performance of the proportion calculation in DP BOM scenario
529663 Performance with the /SAPAPO/TS_LCM_CONS_CHECK
531611 Performance: Buffering of source/target of
531455 Alert function improvement
530680 Performance improvement proportion calculation with

SP7
515120 Performance of the extraction of InfoCube based
510940 Prod. allocations: /SAPAPO/ATPQ_PAREA_R

SP6
514593 Performance improvement with DP background processing
517457 Performance bei Drill Down in Interactive demand planning
509416 Improving the performance during requirements adjustment
506185 CBF: Generated programs are too large (Part 4)
513632 CBF: Performance of programs generation
512801 Poor performance while selecting values Part II
512586 Performance Improvement when Updating with CBF
516530 Improving performance during update II
514672 Performance improvement in deleting selections
512910 Performance improvement for graphics
512635 Planning areas not displayed in the display
509388 Performance improvement forecast
508757 Prod. allocations: Runtime error DBIF_RSQL_SQL_ERROR
508440 Performance improvement when loading notes

SP5
511196 Long runtime when you access DP mass processing
506106 Poor performance in selecting values
501098 Generation of DB indices for selection/notes table
499212 Performance improvement during calc.
508236 Performance improvement of the Interactive Planning
506731 Poor performance with drill-down with many Dets
505886 Performance improvement with the drilldown
502722 Performance improvement definition LIKE II

SP4
499369 Addition to Note 488020
498630 Performance: Evaluation of characteristic values by macros
452544 Performance improvement in life cycle assignment
500544 Performance with the aggregated reading of data
494523 Performance improvement with Add-BOM function
500406 Performance improvement definition LIKE
500497 Performance improvement when filtering SDP alerts





Header Data



Release Status:Released for Customer
Released on:17.07.2003 08:19:39
Master Language:German
Priority:Recommendations/additional info
Category:Performance
Primary Component:SV-BO Backoffice Service Delivery
Secondary Components:SCM-APO-FCS Demand Planning

Affected Releases

Release-Independent

Related Notes




766827 - Composite SAP note: Performance SCM 4.0

Note 375965 - APO Consulting: Alerts in forecast

Note 375965 - APO Consulting: Alerts in forecast

Summary

Symptom

If you want to set limits for forecast errors, from which alerts should be created, you maintain the diagnosis group in the univariate forecast profile or in the profile for the multiple linear regression. If you do not maintain a value limit for a certain forecast error in the diagnosis group, the value of this forecast error is ignored and alerts are never created. The definition of an alert profile in Transaction /SAPAPO/AMON1 does not influence the generation of alerts in any way. Forecast alerts are always warnings. You can overwrite this default in the Customizing under APO - Alert Monitor - Maintain prioritization of alert types.
In APO 3.0/3.1, you can assign an alert profile for forecast, SDP and TLB to every user. This influences the display in interactive demand planning. We recommend that you carry out this assignment. In the forecast views, you can have the forecast alerts displayed which were created for this planning book and data view. In the main view, you can also see forecast alerts for the version and the selection.
In APO 3.0/3.1, you can also make settings to ensure that already existing alerts are deleted for the current combination of planning book, data view, forecast key figure and planning version before each forecast is made in interactive sales planning. With user parameter /SAPAPO/FCST_ALDE, you can make sure that only the alerts for the current selection are deleted. Please also refer to Note 350065.
Follow the menu path 'Settings' -> 'Assign alert profile' in interactive demand planning. In addition to this, you can make settings for alert profiles by following the menu path 'Demand Planning'-> 'Current Settings' -> 'Assignment of planner to alert profiles'. In APO 3.0/3.1, there is no delete function in batch that would take into account selections directly. If alerts are deleted, always all alerts for the planning book and data view are deleted. If this is not desired, you need to use the delete functions of the Alert Monitor.

As of Release SCM 4.0, you can also control in batch that only the alerts for the selection are deleted before running the forecast. To do this, set the relevant indicator in the activity. In interactive demand planning, the alerts for the selection can now also be displayed in forecast view.

Other terms

/SAPAPO/SDP94, alert, alert profile, forecast

Reason and Prerequisites

Comprehension problems

Solution

Read the Consulting note closely.

Header Data



Release Status:Released for Customer
Released on:31.03.2003 15:04:59
Master Language:German
Priority:Recommendations/additional info
Category:Consulting
Primary Component:SCM-APO-FCS Demand Planning

Affected Releases

Release-Independent

Related Notes




495166 - Tips and Tricks for Handling Alert Monitor

388216 - Collective note consulting forecast

350065 - Consultation: User parameters in forecast environment