08-25-2010 5:52 AM
Hi All,
I want to find the usage of the system or a communication user id in various place of the system like RFC....
Is there any table to find that information. i did search to find the related RFC tables but no luck and i found few documents related to communication table but there is no table information.
Kindly let me know.
Thanks & Regards
SV
08-25-2010 7:43 AM
Hi,
the format used for storing RFC connection is really funky. The RFC definition is stored in the table RFCDES but the parameters are concatenated into one string and that string is split into fields of table RFCDES with type RFCOPTIONS. So basically you are looking for string with format U=<USERNAME> in any field RFCOPTION*.
Cheers
08-25-2010 7:43 AM
Hi,
the format used for storing RFC connection is really funky. The RFC definition is stored in the table RFCDES but the parameters are concatenated into one string and that string is split into fields of table RFCDES with type RFCOPTIONS. So basically you are looking for string with format U=<USERNAME> in any field RFCOPTION*.
Cheers
08-25-2010 2:47 PM
Hi,
Thanks for the reply...
But this table RFCDES didnt show the username as output. Where as i am looking for the user id or name which is getting used in RFC's
Please help me on this.
08-25-2010 2:50 PM
08-25-2010 8:02 PM
I tried out the steps you provided worked like charm, to extend more on it,
do you have any method or idea on extracting just the username( U = <username> ) or we have to get the information manually?
08-26-2010 12:10 AM
Nope, just a simple custom report.
DATA: rfcs TYPE STANDARD TABLE OF rfcdes,
rfc TYPE rfcdes,
rfcdisplay TYPE rfcdisplay.
SELECT * INTO TABLE rfcs FROM rfcdes.
LOOP AT rfcs INTO rfc.
CALL FUNCTION 'CONVERT_RFCDES_TO_RFCDISPLAY'
EXPORTING
rfcdes_import = rfc
IMPORTING
rfcdis_export = rfcdisplay.
CHECK NOT rfcdisplay-rfcuser IS INITIAL.
WRITE: / rfc-rfcdest, rfcdisplay-rfcuser.
ENDLOOP.
Cheers
08-26-2010 11:12 PM
That will typically find the outbound connection.
It is a different ball-game to know where to run the program (for example, some connection data might even be saved in client side scripts).
SM19 is your best friend here.
The RFC client destination profiles in ST03N are next best, but you need to be fast enough.
Cheers,
Julius