You use this function to configure the column layout of your SAP Manufacturing Integration and Intelligence (SAP MII) grids.
The grid layout properties are as follows:
Property Name | Parameter Name | Data Type | Description |
Column Number | none | Integer | Identifies the column. |
Column Name | DisplayColumns | String list | Descriptive name for the column. |
Heading | ColumnHeadings | String list | The label for the column. |
Width | ColumnWidths | Integer list | If automatic scaling is not enabled, the width value specifies fixed widths for each column. For example, ColumnWidths=10,24,6,0,5. To hide a column regardless of the auto-scaling setting, set the width to zero. |
Format | ColumnFormats | String list | Specifies the format for numeric data for each column. You can define currency and percentage values and values with different decimal precision. You must provide a generic format for non-numeric columns. |
Alignment | ColumnAlignments | String list | Specifies horizontal text alignment for each column. When this parameter value is not specified, the default grid alignment is based on the data type; numeric fields are right-aligned and dates and strings are left-aligned. |
Boolean | ShowColumnAsBoolean | String list | Specifies if the column should be displayed as a checkbox in the grid. For more information about Boolean values, see Boolean Types. |
Freeze Column | FreezeColumn | Integer | Prevents columns from scrolling horizontally. You define the first column from the left, which is the frozen column. |
Allow Column Resizing | AllowColumnResize | Boolean | If you select this checkbox, you can resize the columns at runtime. Changes to column widths are not persistent; therefore, when the grid is updated, the widths default to the original values. |
Auto Resize Columns | AutoResizeColumns | Boolean | If you select this checkbox, the columns in the table are automatically sized based on the largest value in the column, including the column header text. |
Center Column Headers | AlwaysCenterColumnHeadings | Boolean | If you select this checkbox, the column header text is centered. If the checkbox is not selected, the alignment of the column header text is based on the alignment of the column data types or the Alignment property. |
In the Layout screen of your grid in the SAP MII Workbench, enter your query template and click Load. The column names for the query appear in the list.
You can do the following by using the properties in the table above:
Add columns
Delete columns
Configure column properties
You can change the parameter values for individual applets using scripting.