Table Creation Issue

[Former Member]

Hi Experts,

I am creating 'Z' Table. in that table 3 Primary Keys (including MANDT) and 3 Non key fields. The all Primary Keys Should not accept the initial value. I Un-marked the Initial field and activated..

My Problem is while activating the Un-Marked Initial field is Marked.

How can i solve the Problem..

Regards,

Dhina...

Edited by: Dhina DMD on Feb 24, 2011 11:18 AM

[lijisusan_mathews]

The key fields will have Initial = 'X' by default. It will accept blank values if that is what you want. This flag simply sets ths field value as initial if data is not entered depending on the data type. But for Key fields, this is always set.

Suzie

[prasoon_sahay]

you need to create Table Maintanance Generator for this table.

Now in events you need to write your validation code for blank field

In table maintanance generator go to Environment->Modification->event

under events write your Form Routine.

[lijisusan_mathews]

If you want to block blank entries, You have to write code. Create Table maintenance generator as mentioned above and create events as mentioned or, you can goto the screen directly, take the layout and make the field Required

Suzie

[Former Member]

Answered