Join table Query custom field

[sam_amari]

Hello

I am trying to join the two tables in SAP GRC : GRFNMWRTINST and GRACFFLOG (To fetch all the FFlog_id generated for each MSMP instance session).

To do so , i need to remove the "FFLOG/" from the external key field in GRFNMWRTINST table to obtain the FF_LOG ID . Is there a way to do it using queries? (PS : i'm not an abaper)

[YTHO]

Hi, you can try building up your query (kind of "WYSIWYG"-like) with tcode SQVI.

Create your own join by drag and drop the key field.
Note that the key fields can only be linked if the table and field definitions are consistently maintained.If not possible, you'll need an ABAP developer.

[madhusap]

Hi Samar,

Just to correct you, the logic as follows:

Get the "EXTERNAL_KEY" from GRFNMWRTINST table.

You have to exclude the "FFLOG\" from EXTERNAL_KEY field.

Now pass the updated EXTERNAL_KEY field to WF_ID table in GRACFFLOG table to identify the log id related to the corresponding FF Log review workflow.

As your requirement is straightforward, just extract the data to excel and then do a vlookup by extracting the EXTERNAL_KEY field separately using excel RIGHT function which will be simple and easy approach.

You can also achieve this using SAP query and then you may need to do a bit of coding to use Sub-string function, however as per your P.S i feel this approach should ease out things.

Regards,

Madhu