Sunday, October 21, 2007

How To Write a Start Routine in Update Rules

ABAP code used in Start Routines of Update Rules :

Here I am giving some sample ABAP code used in Update rules to filter unwanted records.

NE - Not Equal
EQ - Equal(=)
LT - Less Than (<)
GT - Greater Than (>)
BT - Between



1 :
-----------------------------------------------

DELETE DATA_PACKAGE WHERE ORGUNIT IS INITIAL.

-----------------------------------------------

2:
-----------------------------------------------

DELETE DATA_PACKAGE WHERE REPTT NE '00000009'.


* DELETE DATA_PACKAGE WHERE REPTT EQ '00000009'.
* DELETE DATA_PACKAGE WHERE REPTT = '00000009'.


-----------------------------------------------



3:
-----------------------------------------------

DELETE DATA_PACKAGE WHERE REPTT EQ '00000001'
OR REPTT EQ '00000002'
OR REPTT EQ '00000003'
OR REPTT EQ '00000004'
OR REPTT EQ '00000005'
OR REPTT EQ '00000006'.

-----------------------------------------------


4:
-----------------------------------------------

DELETE DATA_PACKAGE WHERE WRHRS EQ '0'
AND DUR_ACTUAL EQ '0'
AND DUR_VALUE EQ '0'
AND PLHRS EQ '0'
AND ALP_AMOUNT EQ '0'.

-----------------------------------------------


5:
-----------------------------------------------

LOOP AT DATA_PACKAGE.
IF DATA_PACKAGE-COMP_CODE NE '1000'.
DELETE DATA_PACKAGE.
ENDLOOP.

-----------------------------------------------





If you have any more examples, please feel free to post in the comments.

No comments: