Solution : https://service.sap.com/sap/support/notes/736268 (SAP Service marketplace login required)
Summary :
This SAP Note addresses performance optimization during type matching, focusing on variant configuration updates and efficient database searches. It recommends maintaining up-to-date database statistics with DB20 and creating value statistics for the old buffer's tables (INOB, KSSK, AUSP) via Transaction CLST. Note emphasizes enhancing configuration searches in the new memory (IBase) by generating relevant statistics through IBRT_STATISTICS_CREATE and adjusting conditions in SQL SELECT statements. Performance can also be better by excluding characteristics using RCU_EXCL_CHARACTERISTICS or optimizing queries with RCU_CUSEPRES. Key related notes include 558853, 74693, 301944, and 336842, among others, ensuring comprehensive guideline adherence for system improvements.
Key words :
composite sap note groups important notes, valid material variants' flag, important general performance notes, correct related errors, important performance notes, report rcu_excl_characteristics exists, find object function, start report ibrt_statistics_create, terms material variant, type matching solution 1
Related Notes :
| 1446740 | Performance during search for material variants |
| 917987 | General performance in variant configuration |
| 791479 | Long runtimes in variant configuration |
| 749949 | Long runtimes in classification/selection |
| 749159 | Class search performance for variant classes |
| 697122 | Long runtimes in the classification/selection |
| 678435 | Search for planning variants takes very long |
| 662298 | CL30N: too many hits w/ batch selection |
| 643371 | CL30N: Incorrect result with search for reference chars. |
| 621808 | Timeout in SAPLCLEX1 CLEX1_CHECK_AGAINST_VBAP |
| 610759 | CL30N: Performance improvement w/ search via reference chara |
| 581642 | Deadlocks w/ updates in table IBINVALST_SYM, IBINST_OBJ |
| 580899 | Object search w/ characterstic value asignments: Performance |
| 561441 | Enhancement for report RCU_CUSEPRES |
| 560898 | Long runtime during type matching on result screen |
| 558853 | Long runtimes during the variant configuration |
| 553919 | Long runtime when searching for material variants |
| 545359 | Error message with XPRA "IBRT_STATISTICS_CREATE" |
| 544722 | Termination of XPRA IBRT_STATISTICS_CREATE |
| 539889 | Long access times on table MARC |
| 512105 | All reference characteristcs have the object number as value |
| 504166 | Performance during search for material variants |
| 502034 | RCU_CUSEPRES does not find any configurable materials |
| 489919 | CL30N: Performance-problems with reference characteristics |
| 433565 | Material variant determination: Control |
| 422452 | Material variants: Performance (2) |
| 409123 | Maintenance report for table CUSEPRES |
| 408616 | Performance during material variant determination |
| 406122 | Material variant determination: performance |
| 395040 | Performance in variant matching |
| 362438 | Procedure RCU_EXCL_CHARACTERISTICS |
| 356397 | Performance variant search |
| 336842 | Characteristics not allowed for type matching |
| 309801 | Performance: initial settings for type matching |
| 309035 | Performance variant matching in Rel. 4.5B |
| 301944 | Performance Variant matching for 4.6B |
| 74693 | Classification system, object search, general performance |