Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Create a not null key field

Former Member
0 Kudos

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

4 REPLIES 4

sivasatyaprasad_yerra
Active Contributor
0 Kudos

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.

former_member181962
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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