topic Ztable updation in Application Development and Automation Discussions

Ztable updation

Former Member — Thu, 18 Jul 2013 09:34:36 GMT

Hi all,

I have created a ztable releted to sale order details.There is some problem in updating the table.

whenever a record is added or modified, the update gets failed untill the next change is done...

Eg..1st change which i made is updated only after the 2nd change is made and 2nd change is updated after the 3rd and so on....

Please help me in this reg.

Regards,

Sam.

Re: Ztable updation

gouravkumar64 — Thu, 18 Jul 2013 10:49:54 GMT

Hi,

How did you updating the table?

Thanks

Gourav.

Re: Ztable updation

Former Member — Thu, 18 Jul 2013 11:03:53 GMT

Hi Sam,

Tell whether the Fields in the Z Table are standard's or custom fields.?

if it is standard then there should n't be any problem in insert/update the records.

can you tell in detail how the table is being updated...

Re: Ztable updation

Former Member — Thu, 18 Jul 2013 11:08:58 GMT

did you use COMMIT WORK after update? if not try with using it.

Re: Ztable updation

RaymondGiuseppi — Thu, 18 Jul 2013 11:08:59 GMT

Read Asking Good Questions in the SCN Discussion Spaces will help you get Good Answers

Can you precise :

How did you update the table, did you uise COMMIT WORK or FM DB_COMMIT or ?
In which context (single report, BAdI of a standard transacton...)

Read online help like Implicit Database Commits (or what the system did that you should have done yourself before...^)

Regards,

Raymond

Re: Ztable updation

Former Member — Sat, 20 Jul 2013 05:41:49 GMT

Dear all,

Thanks for your replies. The problem is solved.

I had to update custom field. There was a problem in commit work and was rectified.

Rgds,

Sam.

Re: Ztable updation

Former Member — Sun, 21 Jul 2013 06:37:38 GMT

Just check the documentation in INSERT and MODIFY.

INSERT dbtab

INSERT { {INTO target VALUES source }
| { target FROM source } }.

Effect

The INSERT statement inserts one or more rows specified in source in the database table specified in target. The two variants with INTO and VALUES or without INTO with FROM behave identically, with the exception that you cannot specify any internal tables in source after VALUES.

System Fields

The INSERT statement sets the values of the system fields sy-subrc and sy-dbcnt.

sy-subrc	Meaning
0	At least one row was inserted.
4	At least one row could not be inserted, because the database table already contains a row with the same primary key or a unique secondary index.

The INSERT statement sets sy-dbcnt to the number of rows inserted.

Note

The inserted rows are finally included in the table in the next database commit. Up until this point, they can still be removed by a database rollback.
The statement INSERT sets a database lock until the next database commit or rollback. If used incorrectly, this can lead to a deadlock.
The number of rows that can be inserted in the tables of a database within a database LUW is limited, since a database system can only manage a limited amount of locks and data in the rollback area.

Example, INSERT INTO ztable VALUES wa_ztable

MODIFY dbtab

MODIFY target FROM source.

Effect

The MODIFY statement inserts one or several lines specified in source in the database table specified in target, or overwrites existing lines.

System fields

The MODIFY statement sets the values of the sy-subrc and sy-dbcnt system fields.

sy-subrc	Meaning
0	All lines were inserted or changed.
4	At least one line could not be processed as there is already a line with the same unique name secondary index in the database table.

The MODIFY statement sets sy-dbcnt to the number of processed lines.

Note

The changes are finally transferred to the database table with the next database commit. Up to that point, they can be reversed with a database rollback.

The MODIFY statement sets a database lock until the next database commit or database rollback; incorrect usage can result in a deadlock .
The number of rows that can be inserted into or changed in the tables of a database within a database LUW is restricted database-specifically by the fact that a database system can only manage a limited amount of locks and data in the rollback area.

EXAMPLE : MODIFY ztable FROM wa_ztable.

UPDATE dbtab

Syntax

UPDATE target source.

Effect:

The statement UPDATE changes the content of one or more lines of the database table specified in target. The entries in source determine which columns of which lines are changed, and how they are changed.

System fields

The statement UPDATE sets the values of the system fields sy-subrc and sy-dbcnt.

sy-subrc	Meaning
0	At least one line has been changed.
4	At least one line was not able to be changed, either because no appropriate line was found, or because the change would generate a line that leads to double entries in the primary key or a unique secondary index in the database table.

The statement UPDATE sets sy-dbcnt to the number of changed lines.

Note

The changes are definitively copied to the database with the next database commit. Until that point, they can still be undone using a database rollback

The statement UPDATE sets a database lock up to the next database commit or rollback, which may lead to a deadlock if used incorrectly.
For the specific database, the number of rows that can be changed within a database LUW in the database table is restricted by the fact that a database system can only manage a certain amount of data in the rollback area and from locks.

Re: Ztable updation

Former Member — Sun, 21 Jul 2013 06:48:51 GMT

Hi Samuel,

Did you check if other tables also have the same behavior?

One suggestion: After your first change, check for consistency of the table structure and contents in SE14 transaction. In case of any consistencies exist, you can try to adjust the table.

-Ashwin

Re: Ztable updation

Aiolos — Sun, 21 Jul 2013 08:22:13 GMT

it is a simple problem, before asking, you should try to get any help online first.

Re: Ztable updation

VijayaKrishnaG — Sun, 21 Jul 2013 10:09:44 GMT

Hello Sam,

You can use "COMMIT WORK" after your statement used for Updating (either UPDATE/MODIFY/INSERT). So that all the tables related to that particular object will get updated.

Thanks & Regards,

VIJAY