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:
Post a Comment