Skip to Content
Author's profile photo Former Member

Steps to find the Custom Dictionary objects in database tables

Submitted by : Saravana Kumar.S

Submitted on : 03/13/2012

The below table helps to find the Custom Dictionary objects in Database table.

Enter the appropriate table  and provide the entry for the Fields and enter “ Z* “  in the table name field to get all custom Dictionary objects in database table.

For example :If we want to know how many Custom VIEW are present in database table , for that i am using follow steps.

T code SE11 , table name DD25L , In AGGTYPE field enter V and in VIEWNAME enter Z*. Will give you list of custom view present in database table

Object list name

Steps to find in SE11

Table

SE11->DD02L

OR

SE11->TADIR

PGMID -> R3TR

OBJECT-> TABL

Structure

SE11->DD02VV

Tab class->INTTAB

View

SE11->DD25L

Aggregate Type(AGGTYPE) -> V

Data elements

SE11-> DD04L

OR

SE11->TADIR

PGMID -> R3TR

OBJECT -> DTEL

Domains

SE11->DD01L

OR

SE11->TADIR

PGMID -> R3TR

OBJECT -> DOMA

Table Types

SE11->TADIR

PGMID -> R3TR

OBJECT -> TTYP

Match code objects

SE11->DD25L

Aggregate Type(AGGTYPE) – >M

Lock objects

SE11->DD25L

Aggregate Type(AGGTYPE) – > E

Append Structure

SE11->DD02VV

Tab class -> APPEND

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      good

      Author's profile photo Former Member
      Former Member

      Helpful.

      Author's profile photo Former Member
      Former Member

      Very Useful

      Author's profile photo Former Member
      Former Member

      Very Referenceable.

      Regards

      Chaitanya

      Author's profile photo Former Member
      Former Member

      Really Helpful

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      HI  ,

      Thanks

      Thajunniza M A , usha masani , R Karthik, Krishna Chaitanya, Swapna P

      for your comments, it drives me to write more articles  .....thanks to all ...... 🙂

      Author's profile photo Sudhir S
      Sudhir S

      Really good

      Author's profile photo Harshad Bhingarkar
      Harshad Bhingarkar

      Good one !!!

      Author's profile photo Former Member
      Former Member

      Really useful

      Author's profile photo Former Member
      Former Member

      GOOD Really Helpful..

      Author's profile photo Former Member
      Former Member

      thanks a lot for giving  such a useful information. definitely It will be very helpful .