topic Re: Module POOL updating z table . in Application Development and Automation Discussions

Module POOL updating z table .

Former Member — Fri, 18 Jul 2008 06:14:25 GMT

My requirement is,,

In selection screen I should have

Main asset number

sub asset number...

I have to enter some datas here and it should go and update in the ztable...

it should also check whether the entered data exists in the ztable... if it doesnt exists it should update else it should not update......

ztable is empty as of now....

in layout I have kept main asset and sub asset..

do I need to keep table controls also...

if so in the same screen or in different screen.

Please help ....

Re: Module POOL updating z table .

Former Member — Fri, 18 Jul 2008 06:30:58 GMT

Hi Friend,

No you do not have to show in table control.

declare and interrnal table with same structure as Z table.

pull all data from table control and move to the int table with main asset number and sub asset number.

Use MODIFY ZTABLE FROM TABLE INT_TABLE.

It will do two things, if the record with primary key exist it will update other wise it will insert.

Hope it will help you.

Regards

Krishnendu

Re: Module POOL updating z table .

Former Member — Fri, 18 Jul 2008 07:22:30 GMT

i DECLARED THE SAME.....but still I am not getting it..

Re: Module POOL updating z table .

Former Member — Fri, 18 Jul 2008 09:01:15 GMT

hi,

if we want to modify the database table it will check for primary key fields of the database table. If the primary key matches then only the modification works. If you want to change the primary key fields it doesn't work.

Re: Module POOL updating z table .

Former Member — Fri, 18 Jul 2008 09:11:34 GMT

HI,

Use modify statement for your requirement.

Thanks,

Sriram POnna.