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
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
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)
The query business object looks like this:
Figure 4. An example of an SQI query 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
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
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.