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 |
good
Helpful.
Very Useful
Very Referenceable.
Regards
Chaitanya
Really Helpful
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 ...... 🙂
Really good
Good one !!!
Really useful
GOOD Really Helpful..
thanks a lot for giving such a useful information. definitely It will be very helpful .