Saturday 7 April 2018

SUM ERROR "M_PREMA", "V_7BR_PREMA" and "V_T7BRAP" tables error in ACT_TRANS or ACT_UPG phase




"M_PREMA", "V_7BR_PREMA" and "V_T7BRAP" tables error in ACT_TRANS or ACT_UPG phase ERROR

Symptom
During upgrade process, the ACT_UPG phase terminates with DDIC ACTIVATION errors "TABLE XXXX was not activated" as per the below error message:

Directory:    /SUM/abap/log
Name      :     ACTUPG.ELG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DDIC ACTIVATION ERRORS and RETURN CODE in SAPAAAA731.ABC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


   3 EDT014XActivate dependent table "M_PREMA"
   2WEAD275 Foreign key "M_PREMA"-"BUKRS" (dependency factor "REF" is
   incorrect here)
   2WEAD275 Foreign key "M_PREMA"-"OBRA" (dependency factor "REF" is
   incorrect here)
    1EEDT354 Search field "M_PREMA"-"FILIA" not contained in search help
    attachment
   3 EDT015 Dependent table "M_PREMA" was not activated
   3 EDO525XActivate dependent view "M_PREMA"
   1 EDH202 Check dependent search help "PREMA"
   1 EDH103 Search help "PREMA" is consistent
   3 EMC763 Key field "T7BRAP"-"GRPBR" missing
   2WEMC732 All fields are evaluated as key field
   3 EMC726 View must be created in the database
   3 EDO526 View was activated with warnings"M_PREMA"
    1EEDO519 "Table" "M_PREMA" could not be activated

   3 EDT014XActivate dependent table "V_7BR_PREMA"
   2WEAD275 Foreign key "V_7BR_PREMA"-"BUKRS" (dependency factor "REF" is
   incorrect here)
   2WEAD275 Foreign key "V_7BR_PREMA"-"OBRA" (dependency factor "REF" is
   incorrect here)
    1EEDT354 Search field "V_7BR_PREMA"-"FILIA" not contained in search help
    attachment
   3EDT015 Dependent table "V_7BR_PREMA" was not activated

   3 EDO525XActivate dependent view "V_7BR_PREMA"
   1 EDH202 Check dependent search help "HRPADBRA"
   1 EDH103 Search help "HRPADBRA" is consistent
   3 EMC763 Key field "T7BRAP"-"GRPBR" missing
   2WEMC732 All fields are evaluated as key field
   3 EMC726 View must be created in the database
   3 EDO526 View was activated with warnings"V_7BR_PREMA"
    1EEDO519 "Table" "V_7BR_PREMA" could not be activated

   3 EDT014XActivate dependent table "V_T7BRAP"
   1EEDT354 Search field "V_T7BRAP"-"FILIA" not contained in search help
   attachment
   3 EDT015 Dependent table "V_T7BRAP" was not activated
   3 EDO525XActivate dependent view "V_T7BRAP"
    1EEDO519 "Table" "V_T7BRAP" could not be activated
   1 ETP111 exit code : "8"

Reproducing the Issue

  • Start SUM tool.
  • In ACT_UPG phase, the error occurs.

Cause

The root cause of the issue is some fields were removed from the table T7BRAP. This action is delivered by standard packages however this is not reflecting in other objects like M_PREMA.

On the other hand M_PREMA is a Match code object which is obsolete.

Resolution


You can ignore this error and continue with the upgrade only for the specified tables.

Continue the upgrade by choosing the option 'Accept non-severe errors and repeat phase MAIN_SHDRUN/ACT_UPG' in SUM tool.




More details Refer Snote : 1909524