z table not getting modified

[Former Member]

hi all

i am using modify syntax to modify z table. following is the code:

modify deblo from table debloque.

it is showing sy-subrc = 0, but the changes are not reflecting in z table when i view it through se11 tc.

could anyone explain or suggest any syntax to solve this.

thanx

[Former Member]

try writing commit work after modify

modify deblo from table debloque.

commit work.

[Former Member]

hi raj,

check there is any entry already exists with the data which you are going to modify..

vijay

[Former Member]

Hi Raj,

DOn't forget to use commit work

after if sy-subrc = 0.

commit work.

endif.

[Former Member]

hi

i have tried commit work after modify syntax. the prob is, for some record there is difference of line data, so these records are multiple. i want to modify z table with single record.

[Former Member]

modify will compare the key fields from internal table to that of database table.If the key fields are same then only it will update the database table

[Former Member]

Hi,

USe UPDATE and try....

UPDATE deblo FROM TABLE debloque.

Vijay

Message was edited by: Vijay Babu Dudla

[Former Member]

hi

update syntax is also not updating the z table with single record.

[Former Member]

You can specify the where clause

using update and try with where clause.

vijay

[Former Member]

can u give an example by specifying some records in internal table with vales , and what u r expecting those records to get updated in Z TABLe

[Former Member]

Hi

I think the problem is how you have create your z-table, you should give us the structure of your z-table too.

Max

[former_member184495]

hi raj,

i hope you are talking about the ztable,

then as our friends said you need to commit work,

else if its an internal table, you wont see the data, unless you insert it into the ztable.

if your query is answered by any of our friends or me, please reward points

cheers,

Aditya.

[Former Member]

Hi Raj,

Modify statement acts as INSERT + UPDATE. If the record is does not exist then it will inserted. If it is already exist, it will update the custom table.

Regarding your problem,

MODIFY <ztable> from table <internal table>

The above statement returns sy-subrc when alteast one record of internal table is modified/inserted. So in your case it was updated atleast one record. Analyze the data in se11/se16 with respect to internal table.

Still you are not able to find it out, you can follow the below code to get the correct error.

Loop at <internal table> into <work area>

MODIFY <Ztable> from <work area>

IF sy-subrc <> 0.

write: / 'fail'.

ELSE.

write: / 'Success'.

ENDIF.

ENDLOOP.

COMMIT WORK.

I think your problem may be solved in the above way.

Reward points if it really helps you

Regards

Ganesh N