Link between sap table name and od/400 table

[Former Member]

Hi, I was hoping one of you could let me know where to find the link between the tables in sap, which are sometimes quite long and the os400 table?

Thanks

Flemming Grand

[Former Member · Accepted solution]

Hi Flemming,

I learned it from the old SAPoniSeries Yahoo group.

Option 1. find one from OS400 session

use STRSQL or SQLUTIL

SELECT system_table_name, table_name FROM R3SIDDATA/SYSTABLES

WHERE table_name = '<Tablename long>'

Option 2. get the whole list from SAP GUI (dump to Excel possible)

Tcode ST04 >> Detailed Analysis Menu >>

Systemcatalogtable >>Doubleclick on SYSTABLES

Regards,

Victor

[Former Member]

You can always go from OS/400 to SAP:

WRKF R3sidDATA/filename

Option 8 to see the description

Page down once or twice and it will give you the SQL name

Otherwise, you can query a logical table called SYSTABLES, which gives a crossreference as well.