Skip to Content
0
Former Member
May 18, 2016 at 09:42 AM

Name Schema Wrong in system query

86 Views

HI

I made a copy of the final database (eg SBO_DEF) on a test database (eg SBO_TEST).
For export I used the command
IMPORT "SBO_DEF." "*" FROM '/ usr / sap / NDB / HDB00 / work / tests'
WITH REPLACE RENAME SCHEMA SBO_DEF TO SBO_TEST

In SBO_TEST database system queries have the reference to the original scheme, for example:
... .. FROM "_SYS_BIC." "Sap.sbodef.ar.case/CustomerReceivableAgingQuery" ... ..

instead of ... .. FROM "_SYS_BIC." "Sap.sbotest.ar.case/CustomerReceivableAgingQuery" ... ..

The query then go to error on db sbo_test and, being system queries, if I change the schema name can not override them but I have to duplicate them.

Is there a way to fix the schema name in these queries?

Thanks