topic Re: Insert statement is not working for z table. in Application Development and Automation Discussions

Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 15:44:14 GMT

Hi experts,

My insert statement is not working.

I have used follwing code to update z table .

INSERT ztable FROM TABLE gt_table.

here i have checked gt_table and its filled up with all the records properly.

now the problem is in this table i have 15 fields and it inserts 14 fields of it but

the last field is never inserted though in gt_table i can see value for last fields also.

I have added this field in ztable recently . so i also used se14 to adjust table but still i am facing same problem.

please help me out.

thanks,

Neo

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 15:46:13 GMT

Hi,

Have you enabled table maintaince generator? if not please enable it and re generate the screen.

it will work.

Regards,

Niyaz

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 15:47:08 GMT

Did you regenerate the table maintenance as well, if there is one?

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 15:48:31 GMT

Table maintainance will have nothing to do with this issue.

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 15:48:41 GMT

Try to use statement:

INSERT INTO <dbtable> VALUES <inttable>

Also, check SY-SYBRC EQ 0 and then use COMMIT WORK statement.

Thanks,

SKJ

Re: Insert statement is not working for z table.

former_member194669 — Tue, 21 Aug 2007 15:48:57 GMT

Hi,

1. Check the last field name is as fieldname in ztable

use Modify instead of Insert

MODIFY ztable FROM TABLE gt_table.

a®

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 15:49:03 GMT

Adjust the database as well using the utility is SE11

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 15:50:27 GMT

Try deleting all the records from the ZTABLE and try once again. goto se14 and delete the records

Thanks

Mahesh

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 15:53:32 GMT

> Table maintainance will have nothing to do with this

> issue.

It does sometimes when you are trying to see the values from SM30 instead of SE16. The value may be there, but it may just not seen in SM30 because the table maintenance hasn't registered the addition of new field.

Another place to look at is the activation log to see if there are any warnings issued there.

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 15:55:20 GMT

Hi neo,

1. How is your gt_table declared?

2. Make sure it is declared exactly like database table ZTABLE.

eg.

data : gt_table type table of ztable.

regards,

amit m.

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 16:02:16 GMT

> > Table maintainance will have nothing to do with

> this

> > issue.

> It does sometimes when you are trying to see the

> values from SM30 instead of SE16. The value may be

> there, but it may just not seen in SM30 because the

> table maintenance hasn't registered the addition of

> new field.

> Another place to look at is the activation log to see

> if there are any warnings issued there.

You shouldn't use SM30 to view table entries. You use this transaction to maintain the table entries. Pure and Simple.

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 16:49:23 GMT

Thanks for your input.

but i have created table maintainance again.

I also did table adjustment .

but still i am facing same problem.

Thanks,

Neo

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 16:54:10 GMT

What is the new field type? Also how is gt_table defined? Is this a normal program or is it part of some RFC code?

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 18:56:30 GMT

hi experts,

New field is division i have defined it using data element SPART.

gt_table is same as table in which i am going to insert.

thanks,

Neo

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 19:11:46 GMT

Hi Neo,

Can you please answer the last part of my question? Is this code part of a RFC or a regular program? Also did you check the activation log of the table and is there anything that raises a red flag?

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 20:28:00 GMT

Hi experts,

THis code is in one function module and itsRFC enable.

thanks,

Neo

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 20:30:02 GMT

Hi experts,

There is no error when i activate this table.

thanks,

Neo

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 20:41:42 GMT

Ok, there is an issue with RFCs recognizing changes done to repository objects (program as well as table). They keep the old version of the object buffered. In order to have them recognize the latest changes to the code or the tables etc, you will need the external connection to be reset and basically connect again. That way the latest definitions are uploaded.

The same function module, if you try it from SE37, or from a program within the system, it should work.

Re: Insert statement is not working for z table.

Former Member — Tue, 21 Aug 2007 20:46:25 GMT

hi experts,

sorry i don't understand your question.

i am using this function module seperately for testing purpose.

still its not working.

thanks,

Neo