Get SAP Objects Actions
Get SAP Objects actions retrieve the specified SAP objects from two RFC Destinations. The results are stored in a Table dataset which represents a hierarchy of retrieved objects. The Table dataset may be:
- Compared using the Compare Objects action.
- Converted to a Hierarchy dataset using the Make Hierarchy action.
- Written to a Hierarchy report using the Create Hierarchy Report action.
| Action Property | Description |
|---|---|
| Derivative Object Map | A Table parameter or dataset specifying a derivative object map. Derivative object maps allow differently named objects of the same type to be retrieved for comparison. |
| Retrieve Append Structures | A Boolean parameter which specifies whether the append structures associated with tables will be retrieved. If this parameter is not set, ‘false’ is used as the default value. |
| Retrieve Data Element Domains | A Boolean parameter which specifies whether data elements and domains associated with tables will be retrieved. If this parameter is not set, ‘false’ is used as the default value. |
| Get Subobjects | A Boolean parameter which specifies whether subobjects will be retrieved into the Result dataset. The default value is ‘true’. If this parameter is set to ‘false’, only the specified objects will be retrieved, and not their associated subobjects. |
| IMG Select List | An IMG Select List parameter which allows IMG objects to be retrieved. |
| Object Header Filter | An Object Header Filter parameter which restricts the objects that are retrieved based on their header values (optional). |
| Objects | A Table parameter or dataset specifying a list of objects to retrieve. The table should have at least a NAME column which stores the name of each object, and a TYPE column which stores each object’s type. Object types should be specified using UPPER CASE. |
| Result | A Table dataset that stores a hierarchy representation of the retrieved objects. |
| RFC Destination1 | An RFC Destination parameter or dataset referring to the first SAP system from which to retrieve objects. |
| RFC Destination2 | An RFC Destination parameter or dataset referring to the second SAP system from which to retrieve objects |
| Selects | A Select List parameter specifying the objects to retrieve. |
At least one of the Objects, Selects or IMG Select List properties must be specified for this action to succeed.
If the TABL object type is specified, the Get SAP Objects action retrieves table definitions only. To retrieve the definition and contents for a table, specify both the TABL and TABC object types.
The Result dataset has the following columns:
| Column | Description |
|---|---|
| SYSTEM | The RFC Destination from which the object was retrieved. |
| TYPE | The type of a retrieved object or hierarchy folder. |
| NAME | The name of the retrieved object or hierarchy folder. |
| PARENT_TYPE | The type of a parent object in the hierarchy. |
| PARENT_NAME | The name of the parent object. |
| RELATION | If BW objects are retrieved by the Get SAP Objects action, this column may contain numerical values representing BW hierarchy types. |
| DESCRIPTION | The description for the retrieved object. |
The RELATION column may contain the following values. In the Compare Objects and Compare Objects Advanced workflows from the Synchronization package, the Get SAP Objects action’s Result dataset may be filtered by these values to retrieve and compare only the specified hierarchy types.
| RELATION | BW Hierarchy Type |
|---|---|
| 5 | Info Providers |
| 6 | Info Objects |
| 7 | Info Sources |
Example:
Transport Table Key Results
If the Get SAP Objects action is configured to retrieve one or more Transport Table Key (TPRD) objects, the action’s Result table includes the following object types:
- FLDR objects for each table / transport pair.
- TABK objects for each table key.
- TABB object for each table affected by one or more table keys.
To examine the details for a Get SAP Objects action, double-click the action node, or select ‘View Details’ from the node’s context menu. The Details screen displays the number of rows written to the Result table and the time taken for the action to complete.