IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > SAP Software > Reference > Business object information > Application-specific information
Query interface for SAP Software business objects application-specific information
Query interface for SAP Software application-specific information (ASI) is metadata that specifies adapter-dependent information about how to process Query interface for SAP Software business objects for WebSphere Adapter for SAP Software.
Business object-level metadata for Query interface for SAP Software
The adapter for SAP Software uses application-specific information (ASI) to create queries for Create, Retrieve, Update, and Delete operations. ASI for Query interface for SAP Software is generated by the external service wizard at the following levels: the table and query business-object level and at the property-level.
The sections that follow describe the metadata elements for each level.
The following table describes the business object-level metadata elements of a Query interface for SAP Software table business object.
| Metadata element | Description |
|---|---|
| TableName | The name of the table that this business object represents. |
| Type | The interface type the business object is supporting, which for the Query interface for SAP Software is QISS. |
The following illustration is an example of Query interface for SAP Software business object-level metadata:
Figure 1. Business-object metadata for SapKna1
Property-level metadata for Query interface for SAP Software business objects
Property-level metadata represents child objects or an array of child objects.
The following table describes the property-level metadata elements of a Query interface business object.
| Metadata element | Description |
|---|---|
| ColumnName | The name of the business-object parameter, which is the actual column name in the SAP table. |
| PrimaryKey | An indication of whether this property is a primary key. |
| ForeignKey | The foreign key relationship (if this property is a key), which is the reference to the parent table key parameter.
For an example of how the foreign key relationship is established using the external service wizard, see the illustration of the External Service wizard following this table. |
| MaxLength | The length of the field. |
The following screen capture illustrates where the foreign key relation is formed using the external service wizard:
Figure 2. Mapping the primary key columns to the parent-table foreign key reference columns
The following illustration is an example of Query interface for SAP Software property-level metadata:
Figure 3. Property-level metadata for City
