How can I know Oracle schema name which is the actual backend for my SAP system?

[Former Member]

I would like to know oracle schema name for my SAP system as I am working on modifying configuration settings from other application?For IDES having Sql Server as backend the schema name resulted as "ec7" for my SAP system but not sure on how I can get the schema name for oracle and sybase ASE or sybase Anywhere as backends.Please let me know as this is an urgent requirement .

[venkateswaran_k]

Hi Ravi

Use the following function modue to get the details.

SHDB_GET_DB_AND_SCHEMA

it will ask you parameters.. just pass blank and execute.. It will give you the result as name of the database and schema name.

SE37

give this function module name.

execute

Pass parameters as blank,

exectute

Regards,

Venkat

[Former Member]

Thanks for the reply but im getting Function Module SHDB_GET_DB_AND_SCHEMA  doesn't exist error when tried with SE37 and SE80.

[venkat_aileni]

Hello-

Try below FM's:

DB_DBSCHEMA, DB_DBNAME.

-Venkat

[Former Member]

DB_DBSCHEMA, FM works ,thanks for the help.

regards

ravi

[venkat_aileni]

Hey Ravi-

Request you to close your thread if it's been answered.

-Venkat