KNA1

[Former Member]

hi all,

when i open up this table in se11 , in the field section i see some are in blue and some are in black, what is the difference, and also next to the "data type" there is something called "length" what does that mean.

your help would be appreciated.

regards

[former_member181995 · Accepted solution]

Colors made difference between normal field and Primary key and foreign key.And Length is suggests max expected characters can contain by such field.

[Former Member · Accepted solution]

what does primary key and foriegn key means ?

[Former Member · Accepted solution]

Hi dilip,

The primary key which is used to idetify the table uniquely.It doesn't have any duplications.

The foreign is the key which is used as a reference for one table.

More about foreign key you can find in the following link.

[http://maxdb.sap.com/doc/7_7/44/e3a1e04c836c2fe10000000a114a6b/content.htm]

More about primary key you can find in the following link.

[More about foreign key you can find in the following link.]

Regards,

Mohan

[Former Member · Accepted solution]

Primary key :The field which is Unique and not null is called the Primary Key field

Foreign Key : To establish the relations between 2 tables the same key kield in another table is the Foreign key.

Foreign key can or can not be Unique and not-null.

Ranga

[Former Member]

Hi,

Foreign Key

A foreign key is a key field (column) that identifies records in a table, by matching a primary key in a different table. The foreign keys are used to cross-reference tables.

Primary Key

The primary key of a relational table holds a unique value, which identifies each record in the table. It can either be a normal field (column) that is guaranteed to be unique or it can be generated by the database system itself (GUID or Identity field in MS SQL Server for example). Primary keys may be composed of more than 1 field (column) in a table.

Rajesh