topic Re: Reg : Modifing a database Ztable in Application Development and Automation Discussions

Reg : Modifing a database Ztable

mallikarjun_vaja — Mon, 08 Oct 2007 09:55:24 GMT

Hi,

I have a ztable with 10fields and 11th field is date field. I also have a work area with these fields.

For every record in the Ztable...all the 10 fields have data but 11th filed does not have data(its empty).

Now I want to insert/modify/update database table ztable in such a way that:

IF the date field is empty..just update that date field only with SY-datum.

else leave it.

How do you do that?

Can you give me a sample code?

Thanks,

Arjun

Re: Reg : Modifing a database Ztable

former_member404244 — Mon, 08 Oct 2007 09:59:04 GMT

Hi,

do like this..

Loop at itab into watab.

if watab-date is initial.

watab-date = SY-DATUM.

ENDIF.

MODIFY ITAB FROM WATAB transporting date.

ENDLOOP.

Now go for update statement with ztable

update ztable from table itab.

Regards,

Nagaraj

Re: Reg : Modifing a database Ztable

JozsefSzikszai — Mon, 08 Oct 2007 10:00:35 GMT

hi Arjun,

something like

SELECT *

INTO gt_ztable

FROM ztable

WHERE date EQ '00000000'.

LOOP AT gt_ztable INTO gw_ztable.

gw_ztable-date = sy-datum.

MODIFY gt_ztable from gw_ztable TRANSPORTING date.

ENDLOOP.

UPDATE ztable FROM TABLE gt_ztable.

IF sy-subrc EQ 0.

COMMIT WORK.

ELSE.

ROLLBACK WORK.

ENDIF.

hope this helps

Re: Reg : Modifing a database Ztable

jayanthi_jayaraman — Mon, 08 Oct 2007 10:05:38 GMT

Hi,

You can modify the exisitng ztable's data as follows

update ztable set date = value where date is initial.

Re: Reg : Modifing a database Ztable

Former Member — Mon, 08 Oct 2007 10:05:45 GMT

Hi,

How this Ztable is getting updated?

if its thru Zprogram: then u can write thru codeand Modify Ztable.

If its thru maintenance view, then u need to write the code in Maintenance prgm.

Regards

Kannaiah

Re: Reg : Modifing a database Ztable

mallikarjun_vaja — Mon, 08 Oct 2007 15:34:00 GMT

hi Jayanti,

thats perfect answer.

my problem is solved.

I have given you points.

thanks again

bye

Arjun