Skip to Content
0
Former Member
Apr 28, 2010 at 05:16 PM

(DB) ERROR: DDL statement failed

550 Views

Dear all,

I am getting the following error in the import during system copy

(CREATE VIEW "V_T5NKDBC" ( "MANDT" , "TABLENAME" , "TBTYPEC" , "TBTYPECTXT"  )
AS SELECT T0001."MANDT", T0001."TABLENAME", T0003."TBTYPEC", T0004."TBTYPECTXT"
FROM "T5NKD" T0001, "T5NKB" T0002, "T5NKC" T0003, "T5NKCT" T0004 WHERE T0002."MA
NDT" = T0001."MANDT" AND T0002."TBTYPE" = T0001."TBTYPE" AND T0002."MANDT" = T00
03."MANDT" AND T0002."TBTYPE" = T0003."TBTYPE" AND T0003."MANDT" = T0004."MANDT"
 AND T0003."TBTYPE" = T0004."TBTYPE" AND T0003."TBTYPEC" = T0004."TBTYPEC")
 DbSlExecute: rc = 103
  (SQL error 942)
  error message returned by DbSl:
ORA-00942: table or view does not exist
(DB) INFO: disconnected from DB

Import job SAPVIEW is failing

System copy is using R3load and not backup / restore

Kernel is latest

Any suggestions?

Rgds,