Application Development and Automation 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: 
Read only

No database update after insert / update

Former Member
0 Likes
830

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
Read only

Former Member
0 Likes
791

yes do use 'commit work and wait'.

it works

6 REPLIES 6
Read only

Former Member
0 Likes
792

yes do use 'commit work and wait'.

it works

Read only

Former Member
0 Likes
791

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

Read only

Former Member
0 Likes
791

use commit work.

Read only

andreas_mann3
Active Contributor
0 Likes
791

hi,

you say :

...

Directly after saving - I can view them.

...

how? with se16 or program?

-> try to work with offset

A.

Read only

Former Member
0 Likes
791

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

Read only

Former Member
0 Likes
791

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.