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. Join Condition feature in Process Runner DB is used for extracting data from multiple tables in a single run through a single process file.
Innowera 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.
Innowera provides 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.
Expand the following toggle to configure the prerequisites for ABAP Table Join Condition. The Join condition option will be applicable after this configuration only.
This section will provide guidelines on configuration settings that are to be necessarily configured before implementing ABAP Table Join Condition. These settings will lead to activate the custom function module which is precisely designed to enhance the implementation.
1.Go to Tools tab from the ribbon menu. 2.Select Options command from the drop-down list of Tools tab. 3.At the Options dialogue box, go to 'Data Extractor' tab and enable 'Use Extended RFM' 4.Enter "Y_PROCESS_RUNNER_DE" manually at 'Name of Extended Function' field. 5.Enable 'Reset Settings for Packed Numbers' and enter the required 'Record/Row width' 6.Click on 'OK'.
|
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).
|
||||
Default |
Click on this button 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 |
Click on 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 |
Click this option to delete the Inactive table from the grid. Ensure the deletion before performing this operation as it cannot be reverted. |
|||||
Following are the generic steps to implement ABAP Table Join Condition.
1.Create a new Data Extractor process file wherein the 'Table/View Name' field consists of all the Table/Views names for which multiple data extraction in a single run is required.
2.Go to Home tab.
3.Click on Join Condition from the Settings group.
4.The default Table Join Connection will be displayed at Join Condition tab of ABAP Join Table Condition.
5.Edit the default condition corresponding to the requirements from the Join Condition tab. Perform additional operations if required through description from the above table.
6.Save the process file.
Next: