Table in SQL Server

[Former Member]

Hai,

Is there any table to store the table names for specific screen.

Regards,

Anitha

[former_member201110 · Accepted solution]

Hi Anitha,

What do you mean by name? Do you mean the SQL table name (eg OITM, OINV etc) or the description of the table in SBO (eg Item Master, AR Invoice etc)? SBO does not store this information in another table and the table description is language specific so I think this information is built in to the SBO client. If you're interested in the SQL table names then you can use the sysobjects system table in the company database. If you just want information on what is stored in each table then you can refer to the SDK Help Center which provides a schema for most SBO tables.

Kind Regards,

Owen

[Former Member · Accepted solution]

Owen,

Thanx for ur reply. Is there any table to store the screen name.

Regards,

Anitha

[Former Member · Accepted solution]

Hi Anitha,

OADM will store the alias names for some marketing documents but not the original names.i don't think we have a table to store screen names in SBO

[Former Member · Accepted solution]

Vishnu,

In OADM there is list of database name.

Regards,

Anitha

[Former Member · Accepted solution]

Hi Anitha,

a workaround may be a selfcreated list..

OITM = Item Master

OCRD = Business Partners

...

Matthias