topic Re: Table Creation Issue in Application Development and Automation Discussions

Table Creation Issue

Former Member — Thu, 24 Feb 2011 10:09:23 GMT

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

Re: Table Creation Issue

lijisusan_mathews — Thu, 24 Feb 2011 10:21:02 GMT

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

Re: Table Creation Issue

prasoon_sahay — Thu, 24 Feb 2011 10:35:21 GMT

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.

Re: Table Creation Issue

lijisusan_mathews — Thu, 24 Feb 2011 10:41:13 GMT

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

Re: Table Creation Issue

Former Member — Thu, 24 Feb 2011 10:41:24 GMT

Answered