topic table with key field is initial in Application Development and Automation Discussions

table with key field is initial

Former Member — Wed, 22 Oct 2008 13:24:18 GMT

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

Re: table with key field is initial

Former Member — Wed, 22 Oct 2008 13:35:39 GMT

re read your post.

Re: table with key field is initial

Former Member — Wed, 22 Oct 2008 13:39:49 GMT

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 .

Re: table with key field is initial

ThomasZloch — Wed, 22 Oct 2008 13:43:08 GMT

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

Re: table with key field is initial

Former Member — Wed, 22 Oct 2008 13:43:18 GMT

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

here is the discrepancy.

Re: table with key field is initial

prasannakrishna_mynam — Sat, 25 Oct 2008 11:58:46 GMT

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.