Restricting blank entry in table

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

VJ

[Former Member]

Saurabh,

If you need more clarification, please provide more info.

Otherwise, please reward points accordingly and close the thread.

[Former Member]

tx