Data Extractor - New Process

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

•DD Explorer: Click on this button to open SAP Data Dictionary Explorer window if you do not know table name.

•Logon Shortcut File: Enable this option and select the Logon Shortcut File that you want to use for SAP Login. When this option is enabled, SAP logon system selection and logon prompts will be disabled.

•Save Local: Saves the file at the selected location. The file is usually saved in the default local path under My Documents\Innowera\Process Files folder. If you change the path, remember it for future references.

•Save on EShare: This option allows to save the file on EShare. Set the sharing type as 'Private' or 'Shared'. For shared files users are allowed to set 'Read Only' or 'Read/Write' permissions.

•Excel Data File (Optional): Allows to select external excel file that has data to be uploaded/downloaded to/from SAP. Provide correct sheet name of the selected excel file. This is an optional step and this field can be skipped as you can set this later in the Home tab. If no information is provided for this field then Process Runner will use the internal iBook as a default data source.

•Get field descriptions: Retrieves field descriptions from SAP in your logon language.

•Automap all fields: When enabled this option automatically maps return fields to Excel columns.

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.

data extractor -new process1

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.

data extractor -new process2

Example

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

data extractor -new process3

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.