trigger_1.sql

// Give name to a trigger   
CREATE TRIGGER "SAPABAP1"."BUT000_I"


// State which schema and table to replicate


AFTER INSERT ON "SAPABAP1"."BUT000" 
// Give reference name for each row
REFERENCING NEW ROW BUT000_REF FOR EACH ROW 
BEGIN 
IF :BUT000_REF.CLIENT = '100' 
THEN INSERT 
      //Give which table to insert and state columns
INTO "SAPABAP2"."ZBUT000" VALUES('100',
	 :BUT000_REF.CLIENT,
	 :BUT000_REF.PARTNER,
	 CURRENT_UTCTIMESTAMP,
	 'I' )
;
END 
IF
; 
END
;