topic Check initial value for foreign key in Application Development and Automation Discussions

Check initial value for foreign key

roland_spindler — Tue, 24 Oct 2006 11:40:09 GMT

Hello,

I have a screen field that should be checked using a check table. This works if I enter any value.

However, if the field is left blank then the check does not happen.

Is there a way to 'force' the foreign key check even if no value has been entered? (There may or may not be a blank entry in the check table.)

thanks in advance

Roland

venkata_ramisetti — Tue, 24 Oct 2006 11:44:22 GMT

Hi,

YOu can do that manually.

Write a validation in the PAI when value entered inthe screen field.

EG: FIELD V_SCREEN_FIELD MODULE VALIDATE_FIELD ON INPUT.

The module is only processed if the corresponding field does not have an initial value(if user enter some thing).

Thanks,

Ramakrishna

roland_spindler — Tue, 24 Oct 2006 11:46:14 GMT

Hi,

Yes, I could, but the field is a customer enhancement of VBAK and I don't want to change transaction VA0x if possible.

Roland

Former Member — Tue, 24 Oct 2006 11:46:31 GMT

Hi Roland,

If it is your own program,

Then in the PAI event of the screen,

Validate that field yourself.

IN Pai.

field field1 module check .

module check.

if field1 is initial.

message e001(zz) with 'Invalid Value'.

endif.

endmodule.

Regards,

ravi

Former Member — Tue, 24 Oct 2006 11:53:03 GMT

If edit mode of your foreign key relation you can check one checkbox (do not remember exactly its name, but you will find it in SE11 transaction).

roland_spindler — Tue, 24 Oct 2006 11:55:28 GMT

Hi,

You're probably referring to 'check required'. This checkbox is already checked.

Roland