GRC 5.3 Tables

[Former Member]

Hi,

Do you know where can i find information related with tables of GRC AC 5.3. I heard something about SAP Notes that it refers to tables. I need to know about tables to delete information and develop some things.

Thanks,

Ricardo.

[Former Member · Accepted solution]

Hi Ricardo,

There is no NOTE that will give you AC 5.3 tables.

Regards,

Sirish Gullapalli.

[Former Member · Accepted solution]

Many Thanks,

Then, Do you have any information about the tables and descriptions?

Ricardo.

[Former Member · Accepted solution]

You can ask your DBAs to give you the list of GRC tables.

[Former Member · Accepted solution]

Ricardo,

I recommend you to get this information from SAP. If you get the table list (all the GRC table start with Virsa_) from DBA, you might clean up some of the required initial data and configuration tables.

Regards,

Alpesh

[Former Member · Accepted solution]

Hi,

To find GRC AC5.3 tables, you have to Login to Oracle like this-

c:\sqlplus sapsr3db/passoword

This Query is from CC (RAR) tables-

SQL> select * from tab where tname like '%CC%';

This Query is from AE(CUP) tables-

SQL> select * from tab where tname like '%AE%';

This Query is from RE (ERM) tables-

SQL> select * from tab where tname like '%RE%';

Thanks,

Sudip.

[Former Member · Accepted solution]

I can you give you all the table names but there are lot of tables which I can't paste or attach file on SDN.

So, you have to find these using SQL query given above.

Regards,

Sudip.

[Former Member · Accepted solution]

Hi,

Thanks for responses to all of you, i understand. It´s just that i´ve been searching to a formal document.

Ricardo.

Edited by: Ricardo Carrasco on Aug 20, 2009 5:17 PM

[Former Member]

Ricardo,

You need to ask SAP and SAP will provide you information about all the AC 5.3 tables. I am not able to find that note.

Regards,

Alpesh