Table containing scot smtp 'Address area' e-mail addresses

[benoit-schmid]

Good Morning,

Could you provide me the table name that stores the e-mails stored for the following scot configuration:
SCOT -> SMTP Nodes -> SMTP -> Internet -> Address area

Thanks in advance for your help.

[benoit-schmid]

Thank you jmodaal.

[mamartins · Accepted solution]

The table you need to read is the SXROUTE, column Address Area (REC_ADDR).

Interestingly, the data is stored backwards...

[benoit-schmid · Accepted solution]

Good Afternoon,

You are correct. It is the table I am looking for.

The e-mail addresses are reversed. By reversed, I mean that tota@ch is stored as hc@atot.

From unix, I am using the following command to get the e-mail addresses:
hdbsql -a -x -quiet -U default 'select rec_addr from sxroute' | rev

Would you know if I could get the correct e-mail address with a direct sql query?

Have a nice day.

[jmodaal · Accepted solution]

Hello,

I do not know whether this is possible in SQL. If you are in ABAP, you can use function module SX_ADDRESS_IN_ROUTE_CONVERT or have a look into the source code and use the ~10 lines of code where the mirroring is done. 

Kind regards

Jan

[benoit-schmid · Accepted solution]

Good Morning,

Yan, could you post you abap code in this thread?

Have a nice day.

[jmodaal · Accepted solution]

Hello,

I have doubts whether it is allowed to post source code from SAP here in the forum. Just have a look into the function module. It is no rocket science. Or you can use this ABAP source code, which does the same: 

data: mirrored   type char80 value 'moc.ti-tuctrohs@ofni',
      unmirrored type char80.
data: moveToOffs type i,
      moveFromOffs type i.
write:/ 'Mirrored string  :', mirrored.
moveToOffs = strlen( mirrored ) - 1.
moveFromOffs = 0.
do strlen( mirrored ) times.
  unmirrored+moveToOffs(1) = mirrored+moveFromOffs(1).
  moveToOffs = moveToOffs - 1.
  moveFromOffs = moveFromOffs + 1.
enddo.
write:/ 'Unmirrored string:', unmirrored.

Kind regards

Jan

[S_Sriram]

Hi Beboit,

Check this blog it may help you

https://community.sap.com/t5/spend-management-q-a/where-and-which-table-the-email-addresses-gets-sto...

Regards

SS