exact name of ABAP schema

[Former Member]

Hello

For backup/restore system copy of an ECC system I would need to know exact name of ABAP schema.

I think this is written in system->status->Database data->owner

Am I 100% right?

Thank you in advance

Jan

[former_member312776 · Accepted solution]

Hello

Yes one of the way (easisest) is to check system->status->Database data->owner.

The other way is to check in  'T000' for owner i.e.

select owner from dba_tables where table_name = 'T000'

You can also check SVERS table. both from sqlplus or from SAP.

Also as Surojit wrote you can check it via dev_w* it is in

"Logon as OPS$-user to get password from schema

" and in trans.log

kindestr regards

Branko

[Former Member]

Hi

In addition to above method there are few more ways.

You can check SVERS table from R3 or DB level. SVERS contains schema name.

You can run R3trans -d from any application server using <sid>adm. The output of R3trans -d i.e. trans.log also contains the DB schema name and DB version.

In work folder all the dev_w* traces contains information of schema with which wp are trying to connect.

Hope this helps.

Regards,

SG

[Former Member]

As all of above mentioned options, select owner from dba_tables where table_name = 'T000' gives you the schema.

Regards,

Nick Loy

[karthikeyan_natarajan4]

Yes Jan,

You can check the tablespace names PSAPXXX.....XXX =Schema ID.

regards

kartik

[Former Member]

Hi Jan

Yes you are exactly correct. Its an easy way to check the schema.

Else you can look for the table owners in SAP or DB level also ..

Thanks

Rishi