question about table strucuture

[Former Member]

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!

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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