Product specifications

Fields are mapped to table columns. An InfoSet or an SAP Query contains fields that are both projection
and selection fields. It also contains selection fields that are not used for projection. When you create
a connection with the connection wizard, you choose whether these selection fields are represented
as table columns. The Map Selection Fields into Table Columns parameter addresses this functionality.
If selected, then the field is mapped as an optional input column. If unselected, the selection field is
ignored, and no filtering is possible on this field.
Note:
There is no specific mapping for obligatory selection fields. The application user must query these fields
with filters.
Input columns
Input columns of a table are columns on which an equal condition (= operator) must be given when the
application user queries the table. In the information design tool, the user can view input columns as
mandatory or optional. A mandatory input column is a column for which it is mandatory to set a value.
An optional input column is a column for which it is not mandatory to set a value.
If the user does not set any value to an optional input column in a query, then Connection Server returns
one of the following:
• no value if the optional input column has no default value
• the default value if the optional input column has a default value
Driver capabilities
When the application user queries an InfoSet, some database operations are passed to the SAP ERP
system (SELECT, WHERE, sorting only with ORDER BY columns, and AS), while others are handled
2012-03-1570
Data access driver reference