topic Re: Insert/Update fields into custom table by checking key field in Application Development and Automation Discussions

Insert/Update fields into custom table by checking key field

Former Member — Sat, 14 Nov 2009 06:08:20 GMT

Hi,

I have to two tables like Dept in which fields are

DEPT

===========

CLNT

DEPTID( PK )

,DEPTNAME.

Another table is EMP, the fields are

EMP

============

CLNT

EMPID(PK)

DEPTID(PK)

EMPNAME.

In this created a foreign key relation ship withEMP-DEPTID = DEPt-Deptid.

In program

I want to insert some records to my custom table EMP.

There It should accept only emp-deptid value if it exists in Dept-deptid.

what statement I should write.

When I write " insert into zEMP values <workarea>.

Re: Insert/Update fields into custom table by checking key field

nirajgadre — Sat, 14 Nov 2009 06:15:21 GMT

Hi,

Get the data of your table DEPT into internal table.

while inserting the data check if the work area Deptid id is present in the internal table of DEPT.

if yes then insert the record into the EMP table.

Re: Insert/Update fields into custom table by checking key field

Former Member — Sat, 14 Nov 2009 15:05:34 GMT

Hi,

This is very simple...

1.Just before the insert statement READ TABLE DEPT WITH DEPTid = DEPTID.

2. check for sy-subrc value for 0

3.if yes then insert else prompt the erroe message or do nothing depending upon the requirement.

Hope this will solve your problem.

pooja

Re: Insert/Update fields into custom table by checking key field

Former Member — Sat, 14 Nov 2009 15:30:38 GMT

Hi Pooja,

I am not in front of the SAP Login now. So, can't confirm.

Doesn't the table throw an error when there is a foreign key violation??

I didn't know we were supposed to write a check explicitly !!!

@OP

I am not too sure about this. Probably you can check for yourself.

Re: Insert/Update fields into custom table by checking key field

kesavadas_thekkillath — Sat, 14 Nov 2009 15:32:59 GMT

Its better that you create a foreign key relationship between these two tables.

Are you using table maintenance to insert data ?

if its from your program just use modify table statement

Check F1 help documentation for modify table

Re: Insert/Update fields into custom table by checking key field

Former Member — Sat, 14 Nov 2009 15:34:19 GMT

Hi Bachi,

Check the existance of record in foregin table and then only insert the record.

or else.

first insert in the foregin key table and then insert your table.

Hope you get it.

Re: Insert/Update fields into custom table by checking key field

kesavadas_thekkillath — Sat, 14 Nov 2009 15:37:57 GMT

Are you using table maintenance to insert data ?

before table updation just put a query

select single * from table1 where empid =empid.

if sy-subrc = 0.

"True

else.

"false.

endif.

You can try function module HELP_VALUES_GET_WITH_CHECKTAB

Also Check F1 help documentation for modify table