Solution : https://service.sap.com/sap/support/notes/154091 (SAP Service marketplace login required)
Summary :
This SAP note addresses multiple performance issues across various delivery and goods handling processes within SAP ERP, covering transaction speeds in VL04, VL10, LT12, VL02, VL19, VL06G, VL21, VL23, and LT03. Problems range from slow mass creation of deliveries and stock removal confirmations to delays in goods issue postings and slow delivery monitors. It suggests comprehensive interventions not just limited to note implementation but also enhancing hardware specifications, system configurations, and database settings, encouraging constant review and adjustments as per latest SAP recommendations and monitoring tools like SQL Trace and Process Overview.
Key words :
preceding documentstock transport order = 1allocation table = 1store order = 1store replenishment = 1merchandise distribution = 1sales order = 2, allocation table store order store replenishment merchandise distributionif, transaction bh33 number title case predecessor release--------------------------------------------------------------84661 performance sd texts 1 2 2, 6c stock transfer orders------------------------------------------------------------------------number title case predecessor release, 6a incorrect delivery split159724 incorrect form call, 0b forecast check/performance306998 perfrmnc delivery monitor 6 4, generating fi documents326787 performanc problems drng 1 2 3, 6c gr & release invoice items caution, 5a text determination runs long117512 mb01, 6a updating vapma/vakpa163271 performance promo
Related Notes :
| 967182 | JIT: Short dump DBIF_RSQL_INVALID_SQL in transaction VL10X. |
| 678349 | VL10: Performance optimization of packet creation |
| 454465 | Transaction VL10: Performance improvement |
| 451940 | VL10: Performance for stock transfer orders |
| 354945 | Slow delivery generation in merchandise distribution |
| 336450 | Performance in delivery creation |
| 336374 | Delivery creation performance:R/2-R/3 link |
| 333277 | VL10: performance document list with sales orders |
| 327974 | No import of material master for APO materials |
| 326787 | Performance during mass processing of sales documents |
| 325628 | Performance of goods movements |
| 324026 | Performance improvement for creating FI documents |
| 320947 | Unnecessary PO data qty in delivery creation VL10B |
| 320693 | Buffering of KNVV in SD is incorrect |
| 319622 | Unnecessary purch.order update whn changing delivry |
| 317966 | Performance of data selection VL04 (RV50SBT1) II |
| 316792 | Bad performance in Transaction VL10D |
| 316638 | Performance of data selection VL04 (RV50SBT1) |
| 313808 | Performance VL10 during import of sales order data |
| 313703 | Double update in RV_MESSAGE_DIALOG |
| 309089 | Create transfer order: Performance improvement |
| 306998 | Perfrmnc delivery monitor selection sold-to party II |
| 305405 | Incorrect confirmation w forecast check/performance |
| 303485 | Runtime problems during ATP check |
| 303253 | Performance for purchase orders with many items |
| 300725 | Performance: Documents with many items |
| 216084 | Performance delivery monitor selction sold-to party |
| 214855 | Bad performance during avail.check with batches |
| 211258 | Performance improvement in the purchasing document |
| 211112 | CO Interface: Performance improvement |
| 209516 | Performance optimization in Message Control |
| 209207 | Performnce problm w.transfer to Financal Accountng |
| 209018 | GI: Performance for posting GI (LIPS_BEARBEITEN) |
| 208487 | Performance: needless DB acc. for statistics preparation |
| 208447 | Perf.: Statistics preparation & update in purchasing (EINS) |
| 208171 | Improving performance of GI of delivery |
| 207863 | RIS:Performance improvemnt, II, f data enhancement |
| 207744 | Performance: GR for PO with many PO items (MB01) |
| 207522 | Performance: GR for PO and GI for delivery Part 3 |
| 205941 | Perfmc.: reading EKET f. GR & release invoice items |
| 205844 | Performance object search batch determination |
| 205802 | Performance:GI f.STOs (reading of KONV in SAPLEINS) |
| 205338 | CO-PA: Performance problem when updating CO-PA |
| 205016 | Perf.:GR for purch.order and GI for dely (2. Part) |
| 202060 | Performance batch determination |
| 198347 | Performance improvement in function J_1B_SD_SH_CHANGE_LIPS |
| 196316 | VL06: Short dump DBIF_RSQL_INVALID_RSQL/Performance |
| 194690 | Generate replenishment deliveries:Prefetch material |
| 193062 | VL05 finds no deliveries/table VLKPA blank |
| 192423 | Delivery Processing Performance: Consulting |
| 191819 | Buffer of address management is not deleted |
| 191524 | Optimizatn CO-PA interface for several hierarchies |
| 191408 | Perf.outbound delivery monitor:sel.forwarding agent |
| 189523 | Performance in deliv.process: Advance clarification |
| 188125 | MMIM: MB_CHECK_INPUT performance improvement |
| 188082 | Performance of partner determination during mass processing |
| 187505 | MG_Hier_level_select_rt: Classification error |
| 186993 | Performance VL04/VL10 Sales data update |
| 186380 | Valuation type in the delivery cannot be determined |
| 185903 | Less material master access in reqs consumption |
| 185678 | Performance improvement for goods movement |
| 185081 | Collective processing: Performance |
| 184329 | Delivery monitor performance(selection of material) |
| 184327 | Performance during delivery service |
| 184207 | Partner profit center derivation /customer /vendor |
| 183410 | Needless read accesses to special stock tables |
| 180958 | Determination of offset. ac. during goods movements |
| 179224 | Doc.no.assignment for unbuffered number ranges |
| 178667 | Performance VL04 for automatic packing |
| 177667 | CO-PA interface optimization |
| 176882 | SIS reorganization - performance optimization |
| 174499 | Performance of data selection in delivery monitor |
| 174327 | Processing FI/CO document: Performance improvement |
| 172676 | Freeing up memory space |
| 171979 | Error in pick order verification VL08 / performance |
| 171760 | Transf.bill.doc SD/FI:Perf.probl.dur.pymt card chck |
| 171361 | Message Control: performance problems |
| 171295 | CO interface: performance of availability control |
| 168829 | Performance doc flow, file VBFA (Shipping Statist.) |
| 165291 | Perfrmnc.f.stock transfer/purchase order/Shipping |
| 163918 | In L_FETCH_.. Buffering too for exceptions |
| 163271 | Performance promotion determin. in POS inbound |
| 163073 | Performance problems when updating VAPMA/VAKPA |
| 162066 | Performance when you call up delivery monitor |
| 160768 | Performanc: GR for PO, GI for delivery |
| 159960 | RIS:Perform improvement drng data enhancement |
| 159724 | Incor. FORM call in RV_REQUIREMENT_GENERATE LV03V |
| 158721 | VL04: Performance problems/incorrect delivery split |
| 157286 | Existing delivery item is not read |
| 155311 | Performance for posting goods issue fm delivery SD |
| 154310 | Performance of mass creation of deliveries Part II |
| 154051 | Item texts incorrectly copied in VL04 |
| 151046 | Performance problem when posting goods issue |
| 149408 | Format and installation of corrections |
| 148219 | Performance through reading material short text |
| 147094 | Performance mass creation delivery (VBKD) - new |
| 144700 | Performance improvement when reading the delivery |
| 141930 | ATP: Bad performance |
| 141379 | Long runtime for COPCA_DOCUMENT_CHECK |
| 140346 | Performance of mass creation delivery (FXVBEP) |
| 140298 | Performance delivery (XVBAPF) |
| 139834 | Performance for components which are not checked |
| 139727 | Allocations: performance improvement |
| 139346 | Performance improv VL04 from stock transport order |
| 139318 | Low performance during ATP check |
| 138324 | Performance of mass creation of deliveries |
| 133247 | Dely for stk transport order:Performance improvemnt |
| 132013 | ATP: Performance when reading RESB |
| 131772 | Performance when creating delivery (SELECT VEPVG) |
| 129438 | Database deadlock when updating consumption |
| 127135 | Performance document flow, file VBFA (shipping) |
| 126637 | Performance of sales document processing (shipping) |
| 126634 | Performance of sales doc. processing (statistics) |
| 124669 | ATP: Performance when reading RESB |
| 122153 | ATP: bad performance for large SD documents |
| 119586 | Performance improvement of goods movement |
| 119585 | Performance improvement of goods movements |
| 118743 | Collective note performance in SD |
| 117969 | Collective call of ATP - optimize performance |
| 117512 | xxx MB01: GR with reference to goods issue document |
| 116841 | Performance:in VL01, VL04 text determin. runs long |
| 115583 | VL02, performance improvement batches & goods issue |
| 115213 | VL04: Poor performance during update |
| 112839 | Incorrect batch handling with note 107117 |
| 112801 | ATP: Performance when importing the order documents |
| 111811 | Bad performance during availability check |
| 107284 | Performance improvemnt measures in condition access |
| 107117 | Runtime problems when you change scheduling agreem. |
| 104312 | Performance:unneces. database accesses table T160M |
| 103218 | Performance of document flow, File VBFA |
| 101144 | Performance when saving sales order and delivery |
| 99609 | Runtime goods movement (split valuation) |
| 91830 | Performance in pricing |
| 84661 | Performance SD texts (for collective processing) |
| 70091 | Performance SIS sales order, delivery, billing doc. |