Implement Join Conditions
SAP tends to save the data in tables. Each type of data are saved in different table. These data are extracted from SAP tables through Data Extractor technology in Process Runner DB. The Join Condition feature in Process Runner DBis used for extracting data from multiple tables in a single run through a single process file.
Process Runner Data Extractor (DE) module extracts data from tables or views using SAP provided standard remote function module (RFM). This RFM provides basic but sufficient data extraction capabilities in most cases while some limitations resist extensive implementation of the same. There are other business requirements and optimization which are required at user-end.
insightsoftwareprovides a custom data extraction remote function module that further extends Data Extractor with other useful business needs. Process Runner DB software is already designed to work with this custom function module.
Prerequisites for ABAP Table Join Condition
Following table and image represents brief description on options and fields at ABAP Table Join Connection.
| Tab | Option | Description |
|---|---|---|
| Join Condition | ABAP Table Join Connection |
This field is used to enter the 'Table Join condition' where in a default join condition is allotted automatically according common primary keys among multiple table (if any). Note: If there are no common primary keys among multiple tables, then the Join Condition field will be blank. |
| Default | Select this option to revert the condition ABAP Table Join Condition field to defaults. Default condition is the one which is allotted first time according to the recording. | |
| Syntax Check | Select this option to check the Join Condition Syntax for errors if any. | |
| Tables | Active | Displays whether the corresponding table is activate or not. Enable/Disable the check box to activate/deactivate the corresponding table. |
| Tables | Displays the name of the table included in Join Condition. | |
| Delete Inactive Tables | Select this option to delete the Inactive table from the grid. Ensure the deletion before performing this operation as it cannot be reverted. |
To implement ABAP Table Join Condition
- Create a new Data Extractor process file with the Table/View Name field consists of all the Table/Views names for which multiple data extraction in a single run is required.
- Go to Home tab and select Settings > Join Condition.
- The default Table Join Connection appears at Join Condition tab of ABAP Join Table Condition.
- Edit the default condition corresponding to the requirements from the Join Condition tab. Perform additional operations if required through description from the above table.
- Select File from ribbon menu and select Save As > Save As Local.
- Navigate to the desired location and Save the process file.