List of GRC tables, fields

[Former Member]

Hi,

Does anyone has the list of GRC tables, Fields?

I am dessigning a customized report in Crystal Reports and I need to know the table/fields for the designed reports.

Regards!

[Former Member]

Nina,

Please view note 1369045 for a list of all data mart tables and fields. This is the recommended process for creating Crystal reports. If this is not what you are looking for, ask your DBA to run a view/query on the database for all of the tables in the GRC DB. This is an extensive list that is version and installation specific (depends on how many upgrades and legacy tables, etc.).

Hope this helps!

[Former Member]

Thanks to all,

In SAP note Note 1369045 - AC SP09 Data Mart Design Description, there is an attachment that describes the tables where I can obtaint the information for Crystal Reports (AC_5_3_Datamart.pdf)

Also I obtain a list of GRC database and verify the information gained in SAP note.

Regards

[Former Member]

pull list of all VIRSA_CC_.... table name from your database.

then let us know which report you are refering to.

table names are enough self explanatory

e.g. all Viloation table end with ...VL

however remember analysis is done online....

alll management related table will have ....MGT....

FUNC - function

ACT - action (tcodes in R/3)

PRM - permission (authorization objects in R/3)

GENOBJ - all sync data

SAPOBJ - all SU24 data

SYSTEM - connector....

CONFIG - configruation

BP - business process

MIT - .. i think that for mitigation

regards,

Surpreet

[koehntopp]

Hi Nina,

please send a message to support, they will be able to provide you with documentation.

Frank.