WebSphere Adapter for SAP Software

Business objects

An SQI business graph, which acts as the input to the SQI interface, consists of a table business object and verb. The table business object represents the columns in a table on the SAP server. The verbs supported for an SQI business graph are RetrieveAll and Exists.

An example of a business graph associated with a table business object is shown in the following figure.
Figure 1. Example of an SQI business graph
A screen capture of SapKna1BG, showing a pointer from the business graph to the SapKna1 business object.
The table business object contains columns selected from the specified SAP table. An example of a table business object (representing the KNA1 table) is shown in the following figure.
Figure 2. Example of an SQI table business object
A screen capture of the SapKna1 object.
In addition to column information, the table business object also contains a query business object as the last parameter.
Figure 3. The query business object as a parameter of the table business object (represented by the SapKna1Querybo parameter)
A screen capture showing the SapKna1 object, including the SapKna1Querybo object.
The query business object looks like this:
Figure 4. An example of an SQI query business object
A screen capture showing the SapAdrcQuery business object.

The tables can be modeled as hierarchical business objects. You specify the parent-child relationship of the tables when you select the business objects during the enterprise service discovery process.

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, shown in the following figure, has a column named AddressNumber. This column has an associated property (ForeignKey) that contains a reference to the parent business object.
Figure 5. An example of a child table object
A screen capture of the SapAdrc business object, showing the AddressNumber property.
You can see the property by clicking AddressNumber and looking at the Properties tab.
Figure 6. Example of the property metadata that links the child object to the parent object
A screen capture of the ForeignKey property, with its value of SapKna1/Address.
The ForeignKey property contains a reference to the Address column of the SapKna1 table object.

The return from the SQI interface call for a RetrieveAll operation is a container of business graphs.

Related tasks
Selecting business objects and services
Related reference
Metadata of SQI business objects
Operations of SQI business objects
Naming conventions for SQI business objects

Terms of use |

Last updated: Mon 30 Oct 2006 03:34:55

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)