topic Re: DDIC Table Properties in Application Development and Automation Discussions

DDIC Table Properties

Former Member — Thu, 24 May 2007 17:03:04 GMT

I am looking for the system tables that store Table Properties. Properties I am looking for are: Delivery Class, Data Browser, Enhancement Category, Data Class, Size Category and Buffering. Is there a guide to the system tables that I can use?

Re: DDIC Table Properties

RichHeilman — Thu, 24 May 2007 17:07:22 GMT

Check these tables.

DD02L SAP tables

DD02T R/3 DD: SAP table texts

DD03L Table Fields

DD03T DD: Texts for fields (language dependent)

THe DD02L table will mostly give you what you want.

Regards,

RIch Heilman

Re: DDIC Table Properties

Former Member — Thu, 24 May 2007 17:08:53 GMT

DDTYPES

Re: DDIC Table Properties

Former Member — Thu, 24 May 2007 18:09:53 GMT

Hi Brad,

Please check DD02D, DD09V and DDREFSTRUC.

Hope this helps.

Please reward if useful.

Thanks,

Srinivasa

Re: DDIC Table Properties

Former Member — Thu, 24 May 2007 19:19:53 GMT

I have found most of the information requested in DD02L, DD02T and DD09L. I still haven't found ENHANCEMENT CATEGORY. Does anyone know what system table that data resides in?

Re: DDIC Table Properties

Former Member — Thu, 24 May 2007 19:29:23 GMT

Do you mean by Enhancement Category is Customer Exits and User Exits?

If so, try tables MODSAPA and MODACT.

Re: DDIC Table Properties

ferry_lianto — Thu, 24 May 2007 19:59:55 GMT

Hi Brad,

The enhancement category is stored in table DD02L and field EXCLASS.

Regards,

Ferry Lianto

Please reward points for all helpful answers.

Re: DDIC Table Properties

Former Member — Fri, 25 May 2007 06:29:35 GMT

Hi Brad,

Just search in SE11 transaction for DD* for the Database table, which will help you for sysetm tables of DDIC.

Following are the tables having the DDIC table properties -

DD01L                          Domains
DD01T                          R/3 DD: domain texts
DD02L                          SAP Tables
DD02T                          R/3 DD: SAP table texts
DD03L                          Table Fields
DD03T                          DD: Texts for fields (language dependent)
DD04L                          Data elements
DD04T                          R/3 DD: Data element texts
DD05S                          Foreign key fields
DD06L                          Pool/cluster structures
DD08L                          R/3 DD: relationship definitions
DD09L                          DD: Technical settings of tables
DD30L                          Search helps
DD30T                          Search help texts
ECLOG_HEAD                     Table for Log Header
E070                           Change & Transport System: Header of Reque
E071                           Change & Transport System: Object Entries

Hope this helps.

PS If the answer solved your query, plz close the thread by rewarding each reply and marking it Solved.

Regards

Re: DDIC Table Properties

Former Member — Fri, 25 May 2007 18:48:55 GMT

I think I have enough information to start writing a report. Thanks all.