SAP Program RLE_SHP_IDX_TABLE_MAINTAIN - Report for Maintaining Index Tables for Deliveries

Title
Maintaining Index Tables for Deliveries

Purpose
The report is required for analyzing and reconstructing index tablesfor deliveries.
INCLUDE LE_SHP_IDX_EXPLAIN OBJECT DOKU ID TX
In certain cases it is advisable to construct the index tables again,for example

  • if there are inconsistencies in the tables caused by undiscovered or
  • already solved program errors, and these inconsistencies are visiblethrough missing and superfluous entries
    • if the tables must be reconstructed for the first time

    • The report allows you to reconstruct the index tables, and also toanalyze any inconsistencies that might occur.

      Prerequisites
      Since the report processes large numbers of documents without blocks,SAP recommends that you usebackground processingduring periods of minimal system use.
      In urgent cases, you can run the report parallel to your productivesystem. However, in this case you must assume that the worklists can beincomplete at times, because the reconstruction of the index tablesdeletes the entries in the delivery packages currently being processed.This has an effect on data selection in the delivery monitor, forexample, or when you use the search help for deliveries. The number ofpossible incomplete entries depends on your choice of the parameter'Number of Deliveries per Package' (see below).

      Features

      Selection
      On the selection screen, enter the client in which you want to performthe analysis or the reconstruction. You can limit the number ofdocuments to be processed by entering selection criteria such as thedocument numbers and the shipping point.
      The parameter 'Number of Deliveries per Package' controls how manydeliveries are processed between two COMMIT WORK
      statements. You can adapt the parameter as required, if youexperience database system problems when you run the report.
      If you have to run the report parallel to your productive system, inorder to reconstruct inconsistently filled index tables, you can usethis parameter to reduce the risk of incomplete worklists. To do this,select a smaller package size than the proposed value. The maximumnumber of deliveries missing in the worklists will be the same as thevalue of this parameter. However, the report runtime increases as thepackage size decreases. The minimum value for the parameter is 1.
      You can use the checkbox 'Only Perform Analysis' to control whether theindex tables for the selection criteria are reconstructed (checkbox notselected), or the system only analyzes the index tables without makingchanges to the database (checkbox selected).

      Output
      In analysis mode, when errors occur the report displays a list, withdelivery numbers, for each index table where there are incorrect ormissing table entries.
      In reconstruction of index tables, the report shows you the totalnumber of deliveries processed.

681639Goods issue for deliveries w/o inventory management
1252848JIT: Table SHP_IDX_EXOB not updated with external delivery
920245Analysis and reconstruction of index tables for deliveries
1093055Empty index tables after you upgrade to ERP 6.0
541461Problems with search help for external delivery ID
537084Runtime error ITAB_DUPLICATE_KEY in RLE_SHP_IDX_TABLE_XPRA