topic Re: Restricting blank entry in table in Application Development and Automation Discussions

Restricting blank entry in table

Former Member — Mon, 08 May 2006 13:39:50 GMT

Hi All,

how to resctrict the blank entries in key field of the table? i.e if user leaves one of the key fields blank while creating the entry it should not allloe so.

Please reply

Regards

Saurabh

Re: Restricting blank entry in table

Former Member — Mon, 08 May 2006 13:44:21 GMT

Hi,

While inserting records in the table, SAP by default checks that you supply all the key fields with a value.

You can not keep the key fields blank.

Regards,

Amit Mishra

Message was edited by: Amit Mishra

Re: Restricting blank entry in table

Former Member — Mon, 08 May 2006 13:56:06 GMT

Amit,

That is not a true statement. SAP does not validate that all key fields have been filled.

Saurabh,

You will need to add screen validations in your code. Something like:

if the_current_field is initial.

message i000 with 'Please enter a value'.

exit. "to prevent the DB update from occurring

endif.

Re: Restricting blank entry in table

Former Member — Mon, 08 May 2006 14:02:10 GMT

Hi ,

Yes as John has mentioned atleast one EMPTY entry for the key fields can be made if there is no validation.

SAP does not provide std validation.

You can write events to handle the validation for your custom tables.

CHeers

Re: Restricting blank entry in table

Former Member — Mon, 08 May 2006 14:03:43 GMT

Hi Saurabh,

I am sorry, I was wrong here. SAP dosn't do the validation for the blank fields.

You will have to explicitly do that by providing validation for the same.

Incase, the table is Z* table you can write the code for doing this in TABLE MAINTENANCE GENERATOR.

Goto Utilities --> Table Maintenance Generator.

Regards,

Amit Mishra

Re: Restricting blank entry in table

Former Member — Mon, 08 May 2006 14:27:36 GMT

Saurabh,

If you need more clarification, please provide more info.

Otherwise, please reward points accordingly and close the thread.

Re: Restricting blank entry in table

Former Member — Thu, 28 Jul 2011 09:16:08 GMT