2220206 - ACT_UPG: ORA-00942: table or view does not exist calling SPDD in shadow instance

Running an update with SUM you are in MAIN_SHDRUN/ACT_UPG phase and it is time to run SPDD.

[SAPup.log]

CURRENTPHASE MAIN_SHDRUN/ACT_UPG
...started at <xxxxxxxxxxxxxx>
# SPDD HALT for phase ACT_UPG performed
...begin dialog at  <xxxxxxxxxxxxxx>

In your update, shadow instance is used so SPDD should be run on this but calling SPDD transaction you get a DBSQL_SQL_ERROR short dump:

[ST22]

Runtime Errors DBSQL_TABLE_UNKNOWN
Date and Time 27.06.2019 13:17:27
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Short text |
| There is no help text for this runtime error |
| Either the text was inadvertently deleted or the release of |
| the kernel differs from that of the database. |
| Refer to the Note system for further information on |
| this runtime error. |
----------------------------------------------------------------------------------------------------

and in the Error analysis section of the dump, you see that the missing table is a Z* table (table created in a customer namespace). For example:

|Error analysis |
| Description not available |
| 

| Parameters: |
| P1 "ZTABLE" |
| P2 0 |
| P3 "ORA-00942: table or view does not exist" |

To recognize the programs affected, you should go to active calls section of the short dump. For example:

|Active Calls/Events |
----------------------------------------------------------------------------------------------------
|No. Ty. Program Include Line |
| Name |
----------------------------------------------------------------------------------------------------

| 13  OPEN_FORM SAPLSTXC  ZFORM_MODIFY |
| 12  PRINT_TEXT SAPLSTXD  LSTXDU12 |
| 11  STATUS_0300 SAPLSPO6  LSPO6O01 |
| 10  POPUP_DISPLAY_TEXT_USER_BUTTON SAPLSPO6  LSPO6U02 |
| 9  POPUP_DISPLAY_TEXT SAPLSEMM  LSEMMF05 |

You need to identify a modification on the programs.

user exit, SUM , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem