Data Extractor

Extract existing table data from SAP into Excel File. Use custom WHERE conditions for data extraction to get the most relevant data.

dataextractorb1

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 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.

dataextractorb2

Understanding SAP Data Dictionary Explorer window.

Process Runner presents you with a searchable list of all tables and views as found in standard ECC6 system.

dataextractorb3

Example

Below are steps to find a table joins between VBAK and VBAP.

dataextractorb4

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 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.