Each row of the table represents one business object. Expressions are used to define the columns of data that are presented about the business objects in each row. When you define a table, you determine the number and contents of your table columns. A System table is an Administrator-defined template of columns that can be used in custom applications. These tables are available for system-wide use, and not associated with the session context. Each column has several parameters where you can define the contents of the column, link data (href and alt), user access, and other settings. For example, a user could click a link called Parts to display a system table containing a list of parts. The other columns in the table could contain descriptions, lifecycle states, and owners. System tables are created by business administrators that have Table administrative access, and are displayed when called within a custom application. System table columns can be role-based, that is, only shown to particular users. For example, the Parts table might have a Disposition Codes column that is shown only when a person is logged in as a user defined as a Design Engineer. Or a user defined as a Buyer might be shown a column in a table that is not seen by a Supplier user. When no users are specified in the command and table definitions, they are globally available to all users. When business objects are loaded into a table, the app evaluates the table expressions for each object, and fills in the table cells accordingly. Expressions may also apply to relationships. You can sort business objects by their column contents by clicking on the column header. For more information, see MQL Command Reference: table Command. |