topic Avoid blank entries in table maintenance in Application Development and Automation Discussions

Avoid blank entries in table maintenance

Former Member — Thu, 13 Nov 2008 08:52:07 GMT

Hello Folks,

I have created a custom table where it contains 5 fields(2 key fields & 3 radio buttons).

When i try to maintain a new entry

1) Its taking all the blank fields as entries, resulting in the error(Entry already exists)

2) I see all the lines are defaulted with radio button.

Please suggest on how to avoid this error.

Re: Avoid blank entries in table maintenance

Former Member — Thu, 13 Nov 2008 08:55:31 GMT

Hi,

Open the Table maintenance program in SE80.

Open the Screen Layout & double click on each field so that system displays its attribute.

From the drop down select FIELD IS REQUIRED.

Activate

Best regards,

Prashant

Re: Avoid blank entries in table maintenance

Former Member — Thu, 13 Nov 2008 09:20:46 GMT

After making it as mandatory, it is expecting me to enter all the lines in the screen as the radio buttons are initialized.

Re: Avoid blank entries in table maintenance

Former Member — Thu, 13 Nov 2008 09:23:21 GMT

Please select REQUIRED instead of OBLIGATORY.

Best regards,

Prashant

Re: Avoid blank entries in table maintenance

Former Member — Thu, 13 Nov 2008 09:35:38 GMT

I See only required option.

Re: Avoid blank entries in table maintenance

Former Member — Thu, 13 Nov 2008 09:38:10 GMT

Hi Nishanth,

Then in the CHAIN ENDCHAIN of the Maintenance screen, add a MODULE VALIDATE.

i.e.

CHAIN.
FIELD MATNR MODULE VALIDATE.
FIELD QTY      MODULE VALIDATE_QTY

ENDCHAIN.

MODULE VALIDATE.
if matnr is initial.
message 'Enter Material' type 'E'.
ENDMODULE.

MODULE VALIDATE_QTY.
if qty is initial.
message 'Enter Qty' type 'E'.
ENDMODULE.

Best regards,

Prashant

Re: Avoid blank entries in table maintenance

Former Member — Thu, 13 Nov 2008 09:41:25 GMT

But the error message is coming for all the new lines as i said radio button is defaulted to all the new lines.

Anyways thanks a lot for the effort taken.

Re: Avoid blank entries in table maintenance

Former Member — Thu, 13 Nov 2008 09:46:09 GMT

What do you mean by;


>as the radio buttons are initialized.

Have you already did any modifications to the program?

Regards

Karthik D

Re: Avoid blank entries in table maintenance

Former Member — Thu, 13 Nov 2008 09:46:33 GMT

One radio button will always be defaulted bcz the 3 radio buttons would be part of a group.

Best regards,

Prashant

Re: Avoid blank entries in table maintenance

Former Member — Thu, 13 Nov 2008 09:54:54 GMT

Instead of radio buttons i suggest you to go for a domain with fixed values. So that you can capture the data in one field. It will also give you a F4 help/List box.

In domain Enter values like;

A - Option1

B - Option1

C - Option1

This is also easy for retrieving data back from the database for reporting purpose.

Regards

Karthik D

Re: Avoid blank entries in table maintenance

Former Member — Thu, 13 Nov 2008 10:05:21 GMT

Thanks a lot Karthik... your suggestion solved my problem