Symptom
When upgrading NetWeaver 7.4 SPS level, got below error at phase EU_CLONE_CRE_SHDVIEWS
R3LDCALLRUN.ELG
****************************
A1EEIMP 007 Task failed with error: (ORA) DDL statement failed
A1EEIMP 007 (CREATE VIEW "SUID_SH_BPPERSON" ( "CLIENT" , "PARTNER" , "NAME_FIRST" , "NAME_LAST" , "PARTNER_GUID" ) AS SELECT T0001."CLIENT", T0001."PARTNER", T0001."NAME_FIRST", T0001."NAME_LAST", T0001."PARTNER_GUID" FROM "BUT000" T0001 WHERE T0001."TYPE" = '1')
A1EEIMP 007 (rc = 103)
A1EEIMP 007 (ORA) DbSlErrorMsg rc = 0 'everything went well'
A1EEIMP 007 (ORA) ORA-00942: table or view does not exist
A1EEIMP 016 Finished create for object "SUID_SH_BPPERSON" of type "view" with error in 0 sec #20251129145408
A1 EIMP 012 Starting create for object "SUID_SH_ORGADDR" of type "view" #20251129145408
A1EEIMP 007 Task failed with error: (ORA) DDL statement failed
A1EEIMP 007 (CREATE VIEW "SUID_SH_ORGADDR" ( "CLIENT" , "PARTNER" , "ADDRNUMBER" , "NAME_ORG1" , "PARTNER_GUID" ) AS SELECT T0002."CLIENT", T0002."PARTNER", T0002."ADDRNUMBER", T0001."NAME_ORG1", T0001."PARTNER_GUID" FROM "BUT000" T0001, "BUT020" T0002 WHERE T0001."CLIENT" = T0002."CLIENT" AND T0001."PARTNER" = T0002."PARTNER" AND T0001."TYPE" = '2')
A1EEIMP 007 (rc = 103)
A1EEIMP 007 (ORA) DbSlErrorMsg rc = 0 'everything went well'
A1EEIMP 007 (ORA) ORA-00942: table or view does not exist
A1EEIMP 016 Finished create for object "SUID_SH_ORGADDR" of type "view" with error in 0 sec #20251129145408
****************************
According to the above log, Table BUT000 and BUT020 were referred.
In SE11, table BUT000 and BUT020 exists. The tables belong to package "S_BUPA_GENERAL". But the package "S_BUPA_GENERAL" does not exist in the system.
Read more...
Environment
SUM 1.1
NetWeaver 7.4
Product
Keywords
EU_CLONE_CRE_SHDVIEWS, 7.4, ORA-00942, table or view does not exist, reset, SUM, SUM 1.1 , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview