New report: /PACG/ECM_USERS_MIGRATION has been created in order to allow migration of users previously created and stored in an existing table /PACG/ECM_USER . The records are transferred into new tables PACG/ECM_USERS and PACG/ECM_UCOMP.
The initial screen allows for the selection of:
Company Id
User’s name
Personnel’s number
Each of the fields contains search help.
Additionally there is a migration option: Without data consistency check checkbox. Upon setting this to yes, all users in the specified range will be migrated without checking for data existence, duplicates and conflicts.
After entering the selected values/ ranges of values, deciding about the migration option and pressing execute button, the program finds the data within the selected range and guides through migration process. If the Company ID is left blank, then the selected user/users will be migrated to all companies to which the user is already linked in /PACG/ECM_USER. If the Company ID is entered and user and personnel number ranges are blank then all users/personnel number belonging to the entered company will be migrated.
The migration program has an additional feature which checks data consistency. This feature can be turned on and off by setting the checkbox Without data consistency check. In case when consistency check is turned on and a duplicated records exist in /PACG/ECM_USER, the program will trigger the extra selection screen to enable the choice of desired setting to be migrated to /PACG/ECM_USERS and /PACG/ECM_UCOMP for a specific user (users conflict) or for user and company combination (users company assignment conflict). When multiple records of generic user settings for different companies exist in /PACG/ECM_USER but one record (one user or company user combination) already exists (was previously migrated) in /PACG/ECM/USERS and /PACG/ECM_UCOMP then the setting that was previously migrated will be defaulted, and no selection screen will be displayed.
Users conflict is a situation when a user or personnel number has varying generic records (different values for fields: FSM Usr Id, Perm ID, FSM Usr ac.) for different companies. In the example below, the user JUK has different FSM User ID record linked with different companies. This is incorrect, as the FSM User ID is a general user setting and should be set up per user only not per user/company combination.
In order to avoid migration of duplicated data, the migration program displays additional selection screen to choose proper record to be migrated.
After valid choice the program continues with migration.
User company assignment conflict is a situation when a user has duplicated company assignment with different settings. It is possible to have some values assigned per user and company (such as: Subcontr., Plannable, Not active, User CT) but multiple records for the same user and the same company should not be allowed. The data in the below example is incorrect. The user JUK is incorrectly assigned to company 8 with two different settings: plannable -yes, not active - no, and plannable - no, not active -no.
In order to avoid migration of duplicated data, the migration program displays additional selection screen to choose proper user/company configuration to be migrated.
After the initial entry and optional selection (in case of conflicts), the program displays all users and companies in the selected range and present the data to be migrated. This screen provides an option to review the data and delete some rows before migration confirmation.
After confirmation, the log information with numbers of records created in each table and ALV Grid with list of initially selected users and migration status messages are displayed.
The users selected on the initial screen have been migrated to new tables: /PACG/ECM_USERS and /PACG/ECM_UCOMP:
Additionally the migration program checks user validity and user lock based on USR02 table (fields: GLTGV, GLTGB, UFLAG).
The non valid users or users with lock are successfully migrated (as they can be easily unlocked or their validity can be adjusted later on) but the program displays the warning icons for information.
