The Kind of SAP Tables

October 30, 2009 by mySAP
Filed under: SAP Tip

T**** Tables are Transparent Tables

Has a Physical definition and gets created in the database.

V_ Tables are View Tables

View tables are basically LOGICAL VIEW of one or more tables. For example a view is not actually physically stored, instead it is derived from one or more other tables… if you look at the View Table Structure.. you will see that they are basically JOINS of other tables and the fields are derived by varied tables…

Checking SAP Tables via SM30 transaction. eg:

T512W_D (Definition/Has Physical Storage)
V_512W_D (Table with Joins/doesnt have physical storage)

As Regards Listing the Number of V_ Tables or T Tables, Please follow the below processes

Run SE81 transactionand put the pointer on PA-PA from the list
From the Menu Click on Edit and Select the option ‘Select Subtreee +/-‘
From the Application Menu bar click on Information system button
On the subsequent screen from the R/3 Repository information System; go to ABAP Dictionary >> Database Tables; double click on it.
Enter T* in the Table Name field and Execute.
List of all the T Tables are displayed.

For View Tables

Step 1,2 and 3 remain the same

On the subsequent screen from the R/3 Repository information System; go to ABAP Dictionary >> Views; double click on it.
Enter V_* in the view name field and Execute.
List of all the V_ Tables are displayed.

And added to this, if you do not give T* or V_*, you will find all the kinds of tables.

Credit: Kumarpal Jain