Table 12 shows table entries for the Dynamic Retrieve table.
Table 12. Table Entries for Dynamic Retrieve
Field Name | Description | When Used | Technical Name |
---|---|---|---|
Object Name | WebSphere business object name | Always | OBJ_NAME |
Counter | Counter | Always | POSNR |
Table | Table to read | Always | TABNAME |
Field Name | Field name in table | Always | NAME_FELD |
Key | Specifies a key field of a table | First field of each table. Used to build the where clause of the select statement. | KEYFLAG |
Optional | Free text description of screen, field or command | Used for non-key fields. If all non-key fields are marked as optional and if the select statement fails, the results will be a warning, not an error. | OPTIONAL |
Rel | Operand (relation) | Used to determine relationships in where clause. By default, the operands in the where clause are 'equal' but can be changed by entering a value in this field. | YXR_OPERND |
Field Name in business object | Attribute in the WebSphere business object to supply the input value |
|
SOURCEFLD |
Default Value | A static default value to use if no entry is provided in the WebSphere business object | Key fields | DEFLT_VAL |
SY Field | A dynamic system field to be used as a default value (for example: DATUM) | Key fields | SYFIELD |
Length | Character length from the 0 or offset position of the attribute value that should be used when building the where clause. | Key fields. Only relevant when using an attribute that contains a composite value. | LENGTH |
Offset | Character offset from the 0 position of the attribute value that should be used when building the where clause. | Key fields. Only relevant when using an attribute that contains a composite value. | YXR_OFFSET |
To access adapter's table-driven connector table for Display:
Figure 15 shows the Dynamic Retrieve table with a nested SQL select statement. Results from a previous select statement are used to build the key on subsequent select statements.
Figure 15. Dynamic
retrieve with a nested SQL select statement
Using the Counter column as a line number for discussion, you can step through the SAP_FuncLocation example of a functional location object in the Dynamic Retrieve table.
where TPLNR = '4711'
Select * from IFLOT where TPLNR = '4711'
The resulting value of ILOAN is then copied into the ObjectLocation attribute, which is '5678' for this example.
where TPLNR = '4711'
and SPRAS = 'E'
If the value of Language2 is CxIgnore, then the E is taken from the Default Value field.
Select * from IFLOTX where TPLNR = '4711' and SPRAS = 'E'
The resulting value of PLTXT is copied into the CustomerName attribute. If the select statement fails, a warning is issued, because all the non-key fields for table IFLOTX are marked as optional.
where ILOAN = '5678'
Select * from ILOA where ILOAN = '5678'
The resulting value of ADRNR will be copied into the AddressId attribute.
This completes the building of the SAP_FuncLocation function module for Dynamic Retrieve support.