topic Re: foreign key check holds while updating table through program? in Application Development and Automation Discussions

foreign key check holds while updating table through program?

former_member242512 — Mon, 28 May 2012 09:49:42 GMT

Hi All

I want to know if foriegn key check works when we update a z table from program.

My check table has values for field FV1 : AD,BD,CD .... say

I have used this field FV1 into foreign table .

Now when im updating the foreign key table and suppose i use value ED,FG. which is not there in check table .

Modify foreign key table from workarea.

I'm able to updata data in foreign key with ED, FG ...... kind even though it is not present in Check table.

I have checked forign key relations ship everthing is fine and active.

Please let me know if this is correct ? ....... how the foreign check should work then ?

Re: foreign key check holds while updating table through program?

Former Member — Mon, 28 May 2012 10:10:59 GMT

Hi,

If you assign any domain level values for fields or maintining forign key relation works in selection screen or table maintanance ,,,,,,in program your manually appending some other values,it means automatically update to table,,,,,,,that time you need check explicitly this data exist in CHECK TABLE,,,,if needed

any help revert back,,,,,,,,

Thanks and regards

Re: foreign key check holds while updating table through program?

kumud — Mon, 28 May 2012 10:13:19 GMT

Hello Ujjwal,

That's correct. When a check table is defined for a field, validation happens when you try making entry for that field via SM30 (table maintenance generator) and a value help is provided as well.

But when you try updating the field with ABAP commands, by default the same check does not take place.

To do that, you could provide value help (F4) to your fields and add validation checks in selection-screen events.

Regards,

Kumud

Re: foreign key check holds while updating table through program?

former_member242512 — Mon, 28 May 2012 10:15:34 GMT

So does this means automatically updating table through modify insert statements ...... will not implicit check and they will update the Z table with any data ......... even check table data is different ?

Re: foreign key check holds while updating table through program?

kumud — Mon, 28 May 2012 10:18:43 GMT

Yes. You will have to write coding for that.

Re: foreign key check holds while updating table through program?

former_member242512 — Tue, 29 May 2012 06:46:29 GMT

Silly question ...... explicit check i believe selecting data from check table and then go on inserting data while checking it from check table ..... if not in check table theb that data should not be uploaded.?

Re: foreign key check holds while updating table through program?

kumud — Tue, 29 May 2012 07:07:27 GMT

Hello Ujjwal,

True. I am assuming you have developed a report and what I meant was you could provide F4 help on that field and let user select the appropriate value. You can use standard FMs like F4IF_INT_TABLE_VALUE_REQUEST to provide value help. All the values in check table can be provided in F4 help. You may do a where-used list for this FM and it would be clear to you.

Once user selects the value, you can validate the value as he may type the value instead of selecting from F4. For validation you have to use selection-screen events e.g. AT SELECTION SCREEN ON....

However, if you just want valid data to be entered then what you said is sufficient with proper message for rejected records.

Regards,

Kumud

Re: foreign key check holds while updating table through program?

kumud — Tue, 29 May 2012 07:25:26 GMT

Could you please let me know if you are using any selection-screen?

Re: foreign key check holds while updating table through program?

former_member242512 — Tue, 29 May 2012 09:49:36 GMT

Thanks

lingaraj desai and Kumud Singh.

Re: foreign key check holds while updating table through program?

Former Member — Tue, 29 May 2012 13:54:47 GMT

Hi Ujjwal,

Thanks for asking this question. I haven't noticed this till now and it is really a good Thread.

Thanks to Kumud singh and Lingaraj (though i have not asked the question).

Best Regards,

Praveenkumar T