create or replace trigger TRIG_SYS_HANA_US_CUST_PO
before insert or update on SYS_HANA_US_CUST_PO_SHIPMETHOD
for each row
begin
if updating ('ADDRESS') and (:new.ADDRESS is not null and :new.ADDRESS <> :old.ADDRESS)
or (:new.ADDRESS is not null and :old.ADDRESS is null)
then select sysdate into :new.T_TS from dual;
end if;
end;