Module POOL updating z table .

[Former Member]

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 ....

[Former Member]

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 ....

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

HI,

Use modify statement for your requirement.

Thanks,

Sriram POnna.