cancel
Showing results for 
Search instead for 
Did you mean: 

Tables that stores "Internet address" of SMTP node in SCOT

Former Member
0 Kudos

Hello All,

We store individual e-mail address in the "Address Type" space of SMTP node in SCOT transaction.

When we want to check if the internet address already exists or if we want to delete its very difficult to search.

I would like to know the table that stores the "Internet address" of SMTP node in SCOT.

I searched but not successful.

Thanks,

Subbu

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi

Can u check the transparent table SXROUTE in your SAP system for that. Read the field "REC_ADDR" from RIGHT to LEFT .

Regards,

Shashank

Former Member
0 Kudos

Hi Shashank Rai.,

You are awesome, thanks.

That works.

Thanks,

Subbu

imheku
Explorer
0 Kudos

Thank you.

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks Shashank Was very helpful. You are awesome

Sriram2009
Active Contributor
0 Kudos

Hi Subbu

I thing you need to search jointly in ADR6 & USR21 tables

BR

SS

Former Member
0 Kudos

Thank you Sriram.

We have around 400 email ids (entries) maintained in "Internet Address" of SCOT.

However, ADR6 table has 1,165,256 entries and USR21 has 54,620.

It looks impossible to compare with the number of entries in those tables

Also, by looking at the description of the tables, they doesn't look like they store the SCOT entries in these tables.

Thanks,

Subbu

Sriram2009
Active Contributor
0 Kudos

Hi

You can create the a query on both table reference filed " persnumber" and depend on your SAP system version it will differ.

just refer the SCN link

BR

SS

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Subbu,

Can you check table ADSMTP ?

Regards,

Divyanshu

Former Member
0 Kudos

Thanks Divyanshu. ADSMTP seem to be a structure, not a table.

Could you please help me how to see the contents of this?

Thanks,

Subbu

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Subbu,

Have a look at SADRP and ADRP tables.

Also have a look @ ADR* series of tables using F4 in se16.

Regards,

Divyanshu