topic Re: MODIFY/UPDATE DDIC Table from ITAB in Application Development and Automation Discussions

MODIFY/UPDATE DDIC Table from ITAB

pruthvi_kosala — Fri, 07 Jan 2022 14:13:42 GMT

Hi Experts,

My requirement is to insert or Update itab records to DDIC table.

I am using syntax

MODIFY tab FROM TABLE itab.

but it is updating only one record to the DDIC table, Even when my itab has more than 1 record.

Can anyone tell me what are we doing wrong in this.

Regards,

Pruthvi.

Re: MODIFY/UPDATE DDIC Table from ITAB

Sandra_Rossi — Fri, 07 Jan 2022 14:28:04 GMT

There's nothing special with MODIFY ztab FROM TABLE itab. Try to create a new Z database table, a new Z program with MODIFY ztab FROM TABLE itab and you'll see that it works well...

Maybe you don't understand how it works, so if you provide an example, it will be better for us so that we can explain.

Re: MODIFY/UPDATE DDIC Table from ITAB

pruthvi_kosala — Fri, 07 Jan 2022 15:00:31 GMT

Hi Sandra,

My requirement is updating of a Z database table from a report,

But my syntax MODIFY tab FROM TABLE itab did seem to be not updating all the reords in itab.

in F1 help, when i saw this statement is Platform Dependent, i wanted to know more information on which cases this work and which cases it won't.

Also i realized that the Primary key constraint is the reason for my issue, trying to upload couple of rows with same composite primary key, So fixed it with changing the Primary keys.

Thank You.

Regards,

Pruthvi

Re: MODIFY/UPDATE DDIC Table from ITAB

Sandra_Rossi — Fri, 07 Jan 2022 18:45:23 GMT

Thanks for the feedback. We don't see the image that you tried to attach. I don't see anything dependent on the type of database except LOB handles, that you don't use anyway.

You may close the question if your issue is solved.