how to find the table for stms route

[Former Member]

HI

I have my route in STMS like that

I check the table 'tmscsys' and found that

There is the SYSNAM but not in good order. I need to find the table or file who do the good order like this : DCD, DCR, DCQ, DCI, (DCP, DCC, DCF)

[Sriram2009 · Accepted solution]

Hi

I am not sure, Could you check the "*E070*" tables?

BR

SS

[Former Member · Accepted solution]

No I have checked all

not this

[former_member185954 · Accepted solution]

Hello,

I don't think the route is stored in one table.

It is generated from multiple tables using joins.

Try looking for TCE* tables, try TCESYST, TCETARG, TCEDELI, TCETARGHDR, TCETRAL.

Hope that helps.

Regards,

Siddhesh