Solution : https://service.sap.com/sap/support/notes/436687 (SAP Service marketplace login required)
Summary :
This SAP Note addresses performance issues during APO - R/3 integration, providing insights on problem identification and solutions. Performance problems generally involve inefficient database access, where an SQL trace can be useful for diagnosis. Issues such as inappropriate full table scans and inadequate table statistics in CIF mapping tables significantly impact performance. The CIF application log can also degrade performance due to excessive log entries; regular cleanup is recommended. Additionally, change pointers might slow down during initial data transfers. Identifying the slow-running system using qRFC monitors can determine if the issue is at the sending or receiving end.
Key words :
component note number scm-apo-int-ccr cif compare/reconciliation 439438 scm-apo-int-pur external procurement 646397 scm-apo-int-dp demand planning 609883 scm-apo-int-imo integration model 618444 scm-apo-int-pps production planning, detailed scheduling 615877 scm-apo-int-md-pp master data 512496 scm-apo-int-ext interface, systems 614825 scm-apo-int-sls sales 610704 scm-apo-int-ppe integr, delta report solution inefficient database accesses inefficient database accesses, scm-apo-int-pur-sq apo, scm-apo-int-md-ppm /sapapo/cif_prod_inbound, scm-apo-int-pur /sapapo/cif_res_inbound, scm-apo-int-md-lo /sapapo/cif_order_inbound, scm-apo-int-md-pr /sapapo/cif_po_inbound, scm-apo-int-pps /sapapo/cif_irq_reduct_inbound
Related Notes :
| 1460194 | Report RDELALOG does not delete any entries of BALHDR table |
| 624679 | iPPE/CIF: Composite SAP note on performance |
| 618444 | Composite SAP note: Performance of integration models |
| 615877 | Integration/delta report manufacturing orders: Performance |
| 610704 | Composite SAP note: Performance of SD document update |
| 609883 | Performance during forecast consumption |
| 512496 | Composite SAP note: performance during PPM transfer |
| 454912 | Poor performance of tables used by APO (Oracle only |
| 454502 | /SAPAPO/C5: Performance improvement through blocking |
| 446154 | Performance during source of supply transfer |
| 439438 | Collective note: Performance of CIF delta report |
| 438015 | Latest qRFC version and supplement for 3.x, 4.x, 6.10, 6.20 |
| 407125 | Poor performance of Q and TRFC on ORACLE |
| 384077 | APO: Optimizing CIF Communication |
| 370601 | Composite SAP note: APO 3.0 and 3.1 performance |
| 171872 | CIF Performance improvement for online transfers |
| 114716 | Performance problems Oracle 8.0.4/all entries |