topic Re: question about table strucuture in Application Development and Automation Discussions

question about table strucuture

Former Member — Fri, 02 May 2008 10:26:53 GMT

Hello Gurus,

I have following two questions:

(1) how can I know what is the key field for a table ?

(2) in SE80, when I display the structure of a table, there are component type and data type , why does here have two different types? ( apparently, there values are differenct)

thanks very much!

Re: question about table strucuture

Former Member — Fri, 02 May 2008 10:34:58 GMT

check the second column.whichever is checked they are key fields

component type is data element

data type is to tell whether it is character type or any other type

reward if useful

Re: question about table strucuture

Former Member — Fri, 02 May 2008 10:41:40 GMT

1. To know the key fields of a table programmatically, write a select query on DD03l.

Select * from DD03L into table itab where KEYFLAG eq 'X'. Or else to identify visually, you can go to SE11 and open the table, all the fields which have the field KEY checked are key fields

2. Component type is nothing but Data element and Data type specifies the data type in domain.

Re: question about table strucuture

Former Member — Fri, 02 May 2008 10:43:02 GMT

Hi Bo,

In SE11 enter the table name and display.

In that table, The key (next colomn of field) is ticked means its a key field of the table.

Thanks.

Re: question about table strucuture

Former Member — Fri, 02 May 2008 10:54:36 GMT

Hi,

1) Go to t.code 'SE11'

enter the table name and display.

there the key checkbox is enabled.this the primary key field.

If the checkbox is not enabled then it is a non key field.

2) In structure,

Component type refers the data element.

Datatype refers type of the field that is wheather it is char,int etc.,

Thank u,

Manjula Devi.D