SAP GRC Table (AC) for Viewing SOD Risks "Long" Descriptions

[Former Member]

Hi

Does anyone know which table shows the long description of SoD risks?

[madhusap · Accepted solution]

Hi Reza,

Since you already have the descriptions maintained, just use the program "GRAC_DOWNLOAD_RULES" to download your rules to notepad and then copy the data from risk description text file to excel file which will have long description and control objective as well.

Regards,

Madhu

[Former Member · Accepted solution]

Hi Madhu

Perfect! It is the correct answer. Thank you

Thanks to Rafael and Colleen as well for trying to help

[Former Member]

Hi Madhu

Perfect! It is the correct answer. Thank you

Thanks to Rafael and Colleen as well for trying to help

[Colleen]

Hi Reza

It doesn't look like the data is stored in an easy to access table. The thread linked by rafael.guimbala mentions KB article

https://launchpad.support.sap.com/#/notes/2343681 (2343681 - Where is the SOD Risk long description stored?)

If you run ST05 SQL trace on performing the steps you will see the data is in STXH Table (TDOBJECT = GRC; TDNAME = SOD_RISK*) and then table STXL which has the data compressed

You need to use the function module to read the data. If you need to mass extract to Excel then I'd get a developer to write a wrapper program that can loop through the Risks and extract it.

Regards

Colleen

[Colleen]

Hi Reza

It doesn't look like the data is stored in an easy to access table. The thread linked by rafael.guimbala mentions KB article

https://launchpad.support.sap.com/#/notes/2343681 (2343681 - Where is the SOD Risk long description stored?)

If you run ST05 SQL trace on performing the steps you will see the data is in STXH Table (TDOBJECT = GRC; TDNAME = SOD_RISK*) and then table STXL which has the data compressed

You need to use the function module to read the data. If you need to mass extract to Excel then I'd get a developer to write a wrapper program that can loop through the Risks and extract it.

Regards

Colleen

[Former Member]

Thanks but this does not seem to answer my query; we have already got the long descriptions populated by default. However, I need to know in which table they are stored as I can extract them into a spread sheet.

Thanks

[former_member73766]

See tread

https://archive.sap.com/discussions/thread/3937593

Regards

Rafael