Business objects for the query interface for SAP Software
A business object is a structure that consists of data, the action to be performed on the data, and additional instructions, if any, for processing the data. The input to the Query interface for SAP Software is a table business object. The table business object represents the columns in a table on the SAP server. The adapter uses the table business object to obtain data from tables on the SAP server.
How data is represented in business objects
The adapter uses metadata that is generated by the Adapter Connection wizard to construct a business-object definition.
The data in the business object represents the columns of the associated table in SAP.How business objects are created
You create business-object definitions by using the Adapter Connection wizard. The wizard connects to the application, discovers data structures in the application, and generates business-object definitions to represent them. It also generates other resources that are needed by the adapter, such as the interface information that indicates the input and output parameters.
Business object structure
The table business object can be part of a container.
The table business object contains columns selected from the specified SAP table.
In addition to column information, the table business object also contains a query business object as the last parameter.
- The sapWhereClause property retrieves information from SAP tables. The default value is populated by the Adapter Connection wizard. The space character is used as the delimiter to parse the sapWhereClause.
- The sapMaxRows property is the maximum number of rows to be returned.
The default value is
100
. - The sapRowsSkip property is the number of rows to skip before
retrieving data. The default value is
0
.
The tables can be modeled as hierarchical business objects. You specify the parent-child relationship of the tables in the Adapter Connection wizard.
Tables are linked by a foreign key to form parent-child relationships. The child table business object has a foreign key that references a property in the parent query business object.
In the KNA1 business object, notice the reference to SapAdrc, a child business object. The SapAdrc table object has a column named AddressNumber. This column has an associated property (ForeignKey) that contains a reference to the parent business object.
The return from the Query interface for SAP Software call for a RetrieveAll operation is a container of table objects.