topic Re: ddic table in Application Development and Automation Discussions

ddic table

Former Member — Sat, 17 Mar 2007 06:14:42 GMT

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

Re: ddic table

Former Member — Sat, 17 Mar 2007 06:40:59 GMT

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

Re: ddic table

Former Member — Sat, 17 Mar 2007 06:52:44 GMT

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?

Re: ddic table

Former Member — Sat, 17 Mar 2007 06:55:33 GMT

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.

Re: ddic table

Former Member — Wed, 21 Mar 2007 12:44:23 GMT

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...

Souman

Re: ddic table

Former Member — Mon, 26 Mar 2007 11:06:03 GMT

thanks for you valuable points...