Description
In this way, access to the transfer order items is only possible if youonly select the option "Source" in the selection screen "Referencestorage bin selection". This means that the system will only selecttransfer order items that have the respective storage bin in the sourceitem. If you mark the checkboxes "Dest." and "Return", this will causea much longer runtime since no corresponding database index exists andthus also a "full table scan" is executed. If you are going to use this function more frequently and want toinclude transfer orders that have the respective storage bin in thedestination item, we recommend that you create an additional databaseindex for Table LTAP: Remember that an additional database index requires an additionaldatabase update each time a transfer order item is created andconfirmed. You should therefore only create such an additional indexif you are going to use this function regularly. If the selection should also include return items, you must create anadditional index for this as well. It should contain the fields"Return storage type" and "Return storage bin". You should only dothis in exceptional cases. As a rule, we recommend that you do not create more than 3 indexes perdatabase table. Prerequisites INCLUDE WM_ALV OBJECT DOKU ID TX LANGUAGE EN |
391863 | Performance problems for TO list display |