Data Extractor extracts existing table data from SAP into database table. Use Data Filter for data extraction to get the most relevant data.
How to Find Table Joins or Views?
In a standard SAP system, there are thousands of views or table joins already defined and delivered to you. Process Runner DB provides an easy look up facility to find and use them. Go to "New Process" and then click on "Data Extractor" icon on left panel. A screen similar to one below should appear. Here you can directly type in Table/View name if you know it.
If you do not know table name or if you want to find out table joins, click on "DD Explorer" button.
Understanding SAP Data Dictionary Explorer window
Process Runner DB presents you with a searchable list of all tables and views as found in standard ECC6 system.
Example
Below are steps to find a table joins between VBAK and VBAP.
Notes:
1.You can also use custom (Z or Y) tables and table joins. These will not be displayed in DD Explorer but you can directly type in Z or Y table name in "New Process” window.
2.List provided is based on ECC6. If you are using different system, selected table or view may not be available in your system. You can still type in table/view name directly in "New Process" window and should be able to use all available table/views in your system. Process Runner DB dynamically validates this once you log in to SAP system.
3.While SE16 or SE17 access may not be required, you must have a table level authorization to use any table or view. If you do not have required access, it will clearly indicate the authorization problem.
Next: