topic Re: Create a not null key field in Application Development and Automation Discussions

Create a not null key field

Former Member — Tue, 17 Jun 2008 13:39:52 GMT

Hello everyone,

I'm trying to create a table with 4 key fields. I want one of them to be obligatory. How can i do this?

Best regards

João Anastácio

Re: Create a not null key field

sivasatyaprasad_yerra — Tue, 17 Jun 2008 14:06:59 GMT

Select INITIAL checkbox (column property which can be find in FIELDS tab in SE11 for table) for the field which you need it as obligatory. So, that it will allow you to save the record without the value for that field. Let's suppose you have 4 fields, F1, F2, F3 and F4. and F3 is checked as INITIAL.

Now i can enter values as follows: F1 = 'aba'., F2 = '123' F3 = space and F4 'def'.

Reward points if useful.

Regards,

Siva.

Re: Create a not null key field

Former Member — Tue, 17 Jun 2008 14:11:15 GMT

here is the complete methodology for creating a Table in sap:

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb6e446011d189700000e8322d00/frameset.htm

Regards,

Ravi

Re: Create a not null key field

Former Member — Wed, 18 Jun 2008 05:19:42 GMT

hi,

if u want to make a key field obligatory....what u can do is ...

when u create the screen for the entry, u can set that particular field as...

REQUIRED = '1'.

whenever u will not do the entry in that particular field it will prompt an error msg ....

Regards

Preetesh

Re: Create a not null key field

Former Member — Wed, 18 Jun 2008 06:44:23 GMT

Hi,

Just check the checkbox intial at side of checkbox for making the field as key field.

I hope this will help you.

Help children of U.N World Food Program by rewarding them and encourage others to answer your queries