Show TOC

Function documentationiGrid Layout Locate this document in the navigation structure

 

You use this function to configure the column layout of your SAP Manufacturing Integration and Intelligence (SAP MII) grids.

Features

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.

Activities

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.