Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Reg : Modifing a database Ztable

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

Tags:
Former Member
replied

Hi,

You can modify the exisitng ztable's data as follows

update ztable set date = value where date is initial.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question