Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

No database update after insert / update

Former Member
0 Kudos

Dear all..

I have created a small report for storing additional invoice text into a z-table. These invoice text could have the lenght of 2560 character and are needed for EDI transmission.

Directly after saving - I can view them. After some hours I am always getting empty fields wenn I try to view the data. ... for me it looks like that the table entries are buffered but nor really stored into database. Does a commit work solves this problem ?

Thanks in advance

Jürgen

1 ACCEPTED SOLUTION

Former Member
0 Kudos

yes do use 'commit work and wait'.

it works

6 REPLIES 6

Former Member
0 Kudos

yes do use 'commit work and wait'.

it works

Former Member
0 Kudos

Its mandatory to have the COMMIT WORK so that the data is saved to the database.

Regards,

Ravi

Note : Please mark all the helpful answers

Former Member
0 Kudos

use commit work.

andreas_mann3
Active Contributor
0 Kudos

hi,

you say :

...

Directly after saving - I can view them.

...

how? with se16 or program?

-> try to work with offset

A.

Former Member
0 Kudos

It may be that the actual database updates are failing. You can use transactoins SM13 and SM14 to see if there are problems with the V1 or V2 updates.

Rob

Former Member
0 Kudos

How are storing 2560 character long texts in a Z table? Why not create a standard text and use SAVE_TEXT instead of creating a separate Z table for that.