Product specifications

• An optional parameter that has a default value is mapped to an optional input column. The user
does not have to set a value to this column. The value returned to Connection Server by the data
source in that case is the default value.
• An optional parameter with no default value is mapped to a mandatory input column. The user has
to set a value to this column, because a primary key attribute cannot be null.
Note:
The driver appends a <column name>-ID column to the table which the ABAP function is mapped
into and another <column_name>-IDREF to the table if it contains a reference to another table.
Column renaming
Column names are renamed at driver level. The following table shows the prefixes added to the columns.
PrefixParameterInput or output
-IMPORT_ImportInput
-IMPORT_CH_ChangingInput
-IMPORT_CH_TableInput
-EXPORT_CH_ChangingOutput
-EXPORT_CH_TableOutput
Note:
When an output table parameter (A) is made of another table (B), both tables are renamed -EX
PORT_CH_A and -EXPORT_CH_A.B respectively.
Driver capabilities
All database operations (SELECT, WHERE, ORDER BY, GROUP BY, AS, etc.) are handled internally
by the driver, while equal conditions on input columns are passed to the SAP ERP system.
• Remember:
The driver only accepts tables with one single row as input parameters. They are equivalent to input
structures.
• When you create a connection in the connection wizard, you set whether a changing parameter of
table type or a table parameter is considered as both input and output. The Map Table Parameters
into Input Columns parameter addresses this functionality. If checked, the parameter is both input
and output. In this case, it can only be a structure as input. If not checked, the parameter is only
considered as an output parameter.
• The driver considers fields of an optional input structure as optional input columns. Input columns
are considered optional as a whole, that is, if a column has a value, the others must also have a
value. The application user must ensure all columns have a value.
2012-03-1572
Data access driver reference