cancel
Showing results for 
Search instead for 
Did you mean: 

In which tables of CUP in sap GRC 5.3, can I find the below fields?

Former Member
0 Kudos

Dear experts,

I'm looking for the tables in CUP where the below mentioned fields are present -

1) Roles

2) Firefighter ID

3) Delegated

4) Status Change Date

5) Requested For

6) Sytem

Please let me know in which table I can find it.

Thanks & Regards,

Shruti Yendigeri

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Shruti,

You can search for the tables in your database.

Lookup for VIRSA_AE* tables. All of CUP 5.3 tables start with that naming.

Best Regards,

Fernando Bassuino

Former Member
0 Kudos

Hi Fernando,

Thanks for your reply.

I have searched in help.sap.com as I have not got the access to the GRC 5.3 system.


I could not get the tables containing the above mentioned fields . Could you please help me.


Also, I have got the access to GRC 10.0.  In t-code se11, the tables does not exist with VIRSA_AE*.

Please tell me how to identify the CUP tables in GRC 10.0.

Thanks & Regards,

Shruti Yendigeri

Message was edited by: Shruti Yendigeri

Former Member
0 Kudos

Hello Shruti,

There are a huge number of tables in GRC 5.3. Unfortunately, I do not have a GRC 5.3 system to provide you all the table names.

The tables are not located in the back-end system. You will not be able to see these tables as they are just accesible directly in your database or through Java front-end (opensql_test.jsp).

You can check both options:

- Ask your DBA to give you the list

- Query directly from database (depending on the database you are using)

Oracle for example: select *from tab where tname like '%AE%'

Best Regards.

Fernando

Former Member
0 Kudos

Hi Fernando,

Thanks for giving me idea.I Will check out both options provided by you.

Thanks & Regards,

Shruti Yendigeri

Former Member
0 Kudos

could you let us know, why would you need the table names

10/10.1

GRACROLE

GRACFFOWNER

Don't know for delegate, but you can find it by putting SQL trace, and performing a admin/approver delegation

GRACREQPROVITEM: Status of each line item of a request.

GRACCONNSTAT: system/connector to GRC

regards

Former Member
0 Kudos

Hi Plaban,


I have to develop one report in which many fields will be populated from different tables present in CUP .

So I could not get for some fields which I have asked.  I wanted to know these table names from SAP GRC 5.3 as I have to bring the data from GRC 5.3 to BW.

Thanks & Regards,

Shruti Yendigeri

Former Member
0 Kudos

Hello Experts / Shruti,

I also have a similar requirement.we are using GRC 5.3 and In Portal we have a custom report that fetch some fields from the GRC tables(using SQL query).

Currently the report gets below fields from tables "virsa_ae_roldtls" and "virsa_ae_roleaprv" :

ROLEPROFDISPNAME

ROLEPROFDESC

BUSSPROC

REAFFIRM_PERIOD

LST_REAFF_DT

Primary APPROVERID


we have a requirement to add below fields in the report  :

Secondary Approver ID

Tertiary Approver ID


Please can anyone suggest which table in GRC5.3  have these fields?


or please suggest a way how to get the information of fields or tables.


Regards,

Gunja

Former Member
0 Kudos

Hi Gunja,

There is a field by the name "ALTAPPROVERID" in the table "VIRSA_AE_ROLEAPRV".

I think this field is what "Secondary Approver ID".

I could not find field for "Tertiary Approver ID".

Thanks & Regards,

Shruti Yendigeri

Former Member
0 Kudos

Hello Experts / Shruti.

Thank you Shruti for secondary approver ID.

Please let me know which table in GRC database provide all the approver ID(already got Primary and secondary approver), looking for rest of the 4 approver IDs for roles for the new report.

Also need to get the email address of all the Approver IDs.

Please can anyone suggest which table in GRC5.3  have these fields?


Thank you

Regards,

Gunja

Answers (0)