Show TOC

Function documentationColumn Map Locate this document in the navigation structure

 

You use this action to simplify the creation of complex calculations in SAP Manufacturing Integration and Intelligence (SAP MII). The action inherits the column names and values for one or more specified rows from the associated XML object that conforms to the SAP MII output format.

Features

The action displays the appropriate data type icon for each column in the query results set in the Link Editor screen and makes them available for linking.

For example, if you have a tag query action named CurrentSpeedsTagQuery followed by a sequence containing a Column Map action named SpeedColumnMap, any links or assignments could use:

SpeedColumnMap.DateTime

rather than:

CurrentSpeedsTagQuery.Results{/Rowsets/Rowset/Row/DateTime}

Activities

For queries that return a single row, you assign the Source of Query Results value on the Map C onfigurationscreen to the Results object of a query or some other XML object that conforms to the SAP MII output format.

For queries that return multiple rows, you assign the Source of Query Results value and use a Repeater action to iterate through each row and assign the RowSource property to the output from the Repeater action.