on 08-03-2015 1:21 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.