How to Find Table Joins or Views

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.

HT-TJ1 (1)

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.

 

HT-TJ1 (2)

Example

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

HT-TJ1 (3)

 

Refer to the following video to understand this procedure practically.

 

 

Having trouble viewing this video. Click here to download/view this video directly.

 

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.

 

 

Next

How to Read or Download data from SAP Transaction fields