DDIC Table Properties

[Former Member]

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?

[RichHeilman]

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

[Former Member]

DDTYPES

[Former Member]

Hi Brad,

Please check DD02D, DD09V and DDREFSTRUC.

Hope this helps.

Please reward if useful.

Thanks,

Srinivasa

[Former Member]

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?

[Former Member]

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

If so, try tables MODSAPA and MODACT.

[ferry_lianto]

Hi Brad,

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

Regards,

Ferry Lianto

Please reward points for all helpful answers.

[Former Member]

Hi Brad,

Just search in <i><b>SE11</b></i> transaction for <i><b>DD*</b></i> 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 <i><b>Solved</b></i>.

Regards

[Former Member]

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