ddic table

[Former Member]

hi

friends

when i go in to ddic tables , i find two colums. they are KEY AND INITINAL VALLU.

what do they mean?

can anyone please explain it to me?

points will be awarded.

troy

[Former Member]

Hi,

inital values are nothing but the default values for each data type .

Numeric types initial value

I 0

F 0

p 0

character types

C ' … '

D '00000000'

N '0 … 0'

T '000000'

Hexadecimal Type

X X'0 … 0'

key allowsus to define primary key foreign keys

The ABAP Dictionary allows you to define relationships between tables using foreign keys .

Regards,

Sruthi

[Former Member]

is it compulsary to have minimum of one key field in ddic table?

is it ok even if we have none primary value selected in a ddic table?

[Former Member]

Hi Krish,

The key Field is the field which refers to primary key ( Unique values),

the second one is the initial value means you have to specify the some value ( Not null)

Hope u got it right.

[Former Member]

hi troy...

As you ask the first one in for unique field that is ...value should not be repeat in that field and secondly when you want second table having a link with previous one then that key field will help to make that link...

Socond one Initial means the value of that field should not be blank the default value store in that field...Example for CHAR = ' '. inthat field...

so its a good practice to make first field key as well as initial ...

am I make it clear...

ok

Souman

[Former Member]

thanks for you valuable points...