topic Re: Unable to insert record in database table with INSERT in Application Development and Automation Discussions

Unable to insert record in database table with INSERT

Former Member — Mon, 11 May 2009 18:42:55 GMT

Hi all,

I am trying to insert data into databse table CRMD_PARTNER in CRM. and I wrote the following code.

But the records are not getting inserted. but if i hard code the values then i am able to insert.


.....

if not Jtab[] is initial.
INSERT CRMD_PARTNER FROM TABLE JTAB ACCEPTING DUPLICATE KEYS.
COMMIT WORK.
ENDIF.

can some one tell me what is wrong? i am unable to insert the records..

Kindly help,

Regards,

Jessica Sam

Re: Unable to insert record in database table with INSERT

Former Member — Mon, 11 May 2009 18:48:20 GMT

Hi Jessica,

If you try to insert the new values with duplicates by accepting , it will not insert because it is database table define with some Primary key Fields..

try to use the MOdify command instead of Insert.

so if any Duplicates comes it will overwrite the existing record if any new record comes it will insert..


 if not Jtab[] is initial.
    loop at JTAB.
       Modify CRMD_PARTNER FROM JTAB .
      if sy-subrc = 0.
        COMMIT WORK.
     else.
        Roll Back.
     endif.
  endloop.
 ENDIF.

Regards,

Prabhudas

Re: Unable to insert record in database table with INSERT

Former Member — Mon, 11 May 2009 18:57:29 GMT

Prabhu...

I used Modify as suggested by you..butstill no use. unable to inert records into databse table

any clues what i am missing.

Re: Unable to insert record in database table with INSERT

Former Member — Mon, 11 May 2009 19:02:19 GMT

ACCEPTING DUPLICATE KEYS won't allow you to insert more than one record with duplicate keys. It just won't give a non-zero SY-SUBRC if it encounters the situation.

Try pressing F1.

Rob

Re: Unable to insert record in database table with INSERT

Former Member — Mon, 11 May 2009 19:04:33 GMT

H Jessica,

Check the Table JTAB Structure , it should be equal to the CRMD_PARTNER table structure..

and check r u passing the All key field ..

Regards,

Prabhudas

Re: Unable to insert record in database table with INSERT

former_member194669 — Mon, 11 May 2009 19:06:39 GMT

Possible reasons insert got failed

1. Same primary key values are already available in table CRMD_PARTNER

Try this code before making INSERT


loop at jtab.
v_tabix = sy-tabix. 
  select single * from crmd_partner where <primary key> = jtab-<primary key>
  if sy-subrc 0.
    delete jtab index v_tabix.
     continue.
  endif.
endloop.

a®

Re: Unable to insert record in database table with INSERT

Former Member — Mon, 11 May 2009 19:50:53 GMT

I tried everything. I am passing all key fields and my structute of jtab is same as that of the table, but still i dont see any records being inserted in my table.


data: begin of Jtab occurs 0.
        INCLUDE STRUCTURE CRMD_PARTNER.
DATA: end of Jtab


if not Jtab[] is initial.
   loop at JTAB.
      Modify CRMD_PARTNER FROM JTAB .
     if sy-subrc = 0.
       COMMIT WORK.
    else.
       MSG5 = 'SOME RECORD MISSED'.
  MOVE MSG5 TO IT_RESULT-MESSAGE.
  APPEND IT_RESULT.
    endif.
 endloop.

some one please help..i am trying to insert data into the database and that doesnt get instered ..any clues about what i am missing wil be highly appreciated.

regards,

jessica sam

Re: Unable to insert record in database table with INSERT

Former Member — Mon, 11 May 2009 21:17:57 GMT

Jessica,

1) Is it possible to post the entire program? If the program is too long, please create a short sample program, make sure that doesn't work, and then post the code here.

2) Do you know for a fact that Jtab[] is not initial? Did you go into debug and verify?

3) Don't go in a loop and modify one record at a time. Modify everything in one shot. Place the cursor on MODIFY statement and hit F1 key for the syntax.

4) MODIFY, INSERT, and UPDATE statements work fine. You will have to figure out what you are doing wrong. Code snippets you are posting are not enough for us to guess the problem.

Debugger is a programmer's best friend. Learn to use it, and you will solve most of your programming problems and feel really good by the end of the day.