topic Re: commit in Z class method in Application Development and Automation Discussions

commit in Z class method

Former Member — Mon, 19 Mar 2007 12:02:06 GMT

Hello friends

I am enhanching someone else's code in a method in a class.

I am trying to insert something in my z table, but it won't insert without commit. If I write commit, it gives syntax error.

" insert zmm_intsales from ca_zmatint.

commit. "

can anyone guide how to commit in a method of a class.

Regards

Bhavna

Former Member — Mon, 19 Mar 2007 12:09:25 GMT

try 'COMMIT WORK' instead of COMMIT.

Former Member — Mon, 19 Mar 2007 12:25:07 GMT

I have used commit work it does not give syntax error, but still nothing is getting inserted in the Z table.

Thanks

RichHeilman — Mon, 19 Mar 2007 12:27:05 GMT

Are you sure that there is data in the ca_zmatint ?

Regards,

Rich Heilman

Former Member — Mon, 19 Mar 2007 12:33:04 GMT

Yes if nothing else material number is there in it.

Thanks

Former Member — Mon, 19 Mar 2007 12:35:00 GMT

In debug mode check the content of SY-DBCNT field immediately after the INSERT. If it contains a non-zero value, the record(s) are getting inserted.

In that case, check the content of table structure ca_zmatint to make sure you have populated the fields correctly.