topic Re: checking foreign key relation while updating table though program in Application Development and Automation Discussions

checking foreign key relation while updating table though program

uttam_kumar4 — Wed, 04 Feb 2015 19:36:42 GMT

Hi Experts,

I have a table A in which a field z_field is having Entry/Check on table B. So if I update table A in SM30 I can see that it is checking table B for field Z_field so if I enter anything that is not available in B it would throw error.

How can we achieve the same when we are uploading data through a program using modify statement.

thanks

Rahul.

Re: checking foreign key relation while updating table though program

Former Member — Wed, 04 Feb 2015 19:50:19 GMT

Select by fkey in B table and if not exist, adapt your code.

Hope it helps.

Re: checking foreign key relation while updating table though program

uttam_kumar4 — Wed, 04 Feb 2015 20:03:55 GMT

I wanted it without code.. with code of course I can do that.

Thanks & regards,

Rahul

Re: checking foreign key relation while updating table though program

ThomasZloch — Wed, 04 Feb 2015 20:10:46 GMT

If you want stuff without code, then why post in ?

Thomas

Re: checking foreign key relation while updating table though program

Former Member — Wed, 04 Feb 2015 20:35:49 GMT

No way as far as I know.

If you insert value by value then in screen fields, google check table and value table.

From Abap, unlike for instance MS Sql there is no auto check when inserting. Thats what frustrated me for a while, but Sap wanted to work on most Databases so here You go.

You can manipulate DB directly, constraint, but I would not do that for such trivial thing...or ever.

2 lines of code, 1 select and IF

I recommend get data in Alv, test mode, flag wrong inserts etc.

Without code, use Winshuttle.

Re: checking foreign key relation while updating table though program

RaymondGiuseppi — Thu, 05 Feb 2015 07:55:32 GMT

You could use a generic check tool which was developed in HR : method CHECK_STRUCTURE of class CL_HRBAS_FOREIGN_KEY_CHECK.


ls_structure-mtart = '????'. " wrong value
 CREATE OBJECT: lr_key_check, lr_message_handler.
 TRY.
     lr_key_check->check_structure(
       EXPORTING
         structure             = ls_structure
         excluded_fields       = lt_excluded_fields
         ignore_initial_fields = lv_ignore_initial_fields
         message_handler       = lr_message_handler
       IMPORTING
         is_ok                 = is_ok ).
   CATCH cx_hrbas_violated_assertion.
 ENDTRY.

Regards,

Raymond