Programme SAP /LIME/CONV_TREE - Program /LIME/CONV_TREE, XPRA for TREE Conversion (AP 2005)

Purpose
For LIME AP 7.0, the underlying database design was changed to increaseperformance and decrease the database volume.
The following tables are affected from changes:

  • /LIME/TREE

  • /LIME/LOG_TREE

  • /LIME/QUAN

  • /LIME/LOG_QUAN

  • /LIME/SERIAL

  • LIME/LOG_SERIAL

  • The tables are changed from adjacent lists with pointers for all parentsinto a left/right traversal tree model. A detailed description of thedatabase design can be found in the specification and design documentsor in cProjects (A05_100444_AP_ERP_LIME, Workpackage 'miniPlatform').
    For the user, there are no changes in using LIME since only internallyused tables are changed and the interfaces were left unchanged.

    Prerequisites
    The XPRA should be executed if an upgrade from SCM 4.0 or 4.1 to SCM 5.0or later releases using LIME AP 7.0 or later is done.

    Features
    As described in the Design document, the XPRA performs the followingsteps:

    • Data analysis

    • Conversion of /LIME/TREE

    • Conversion of /LIME/QUAN

    • Conversion of /LIME/SERIAL

    • Conversion of /LIME/LOG_TREE

    • Conversion of /LIME/LOG_QUAN

    • Conversion of /LIME/LOG_SERIAL

    • If a serious error occurs in any of these steps, a message is written tothe XPRA log with instructions for an administrator and the XPRA exit .The XPRA can be restarted later when the problem that led to the errorhas been solved. In this case, the XPRA skips the steps that werealready successfully executed and continues with the remaining steps.
      Since the new database model uses widths for each tree node, reasonablevalues for tree widths are calculated during the XPRA based on datafound in /LIME/TREE and /LIME/LOG_TREE.
      Archives with LIME data is not converted by the XPRA, as the newarchiving functionality for LIME AP 7.0 can handle old and new archivesin parallel.