table with key field is initial

[Former Member]

Hi all,

I have created a table with key fields as mandt and matnr and also created a Table Maintainence generator for it .

I declared in the Table with Key fields as Key and initial.

But when i am creating the entries through SM30, key field is accepting inital value.

I dont know how can this possible.

Will you anybody clear my doubt.

Regards,

Madhavi

[Former Member]

re read your post.

[Former Member]

Will you know any discrepancy, i didnt find anything there.

As though i defined as key fields in se11, it is accepting Initial values while creating new entries in SM30 .

[ThomasZloch]

The initial value (space in case of character fields) is a valid key field value. If you want to prevent initial values as key field values, you will probably have to work with table maintenance events.

Thomas

[Former Member]

I declared in the Table with Key fields as Key and initial.

here is the discrepancy.

[prasannakrishna_mynam]

Hi..

When you mark the init value for the key fields, the particular field will have the field's datatype's initial value, if you left the field with out giving any value, while entering the data.

Eg: If the key field is of type Char and is marked as init, the space will be the value, incase we don't provide any value as input to that field.