Skip a record in Update rules

[Former Member]

Hi guys

I need to skip a record for material if it havent got material value in it. i know how to skip a rec for transfer rule, but i dont think i can apply the same for update rule

Regards

Chris

[Former Member]

U can write code in the start routine (in update rules) like..

delete DATA_PACKAGE where material =''.

Hope this helps

[Former Member]

Hi Chris,

you can also do in formula... create formaula for update of material with logic

IF material = '' THEN SKIP_RECORD() ELSE material

Best regards,

Björn

[Former Member]

Thank you Reddy,

It helped.

Chris

[Former Member]

Good to hear that it helped.

[Former Member]

Hi Björn

I tried the below one its giving me error

IF I_MATNR = ' '.

SKIP_RECORD.

ENDIF.

'E:Statement "SKIP_RECORD" is not defined. Check your spelling. spelling'

[Former Member]

Hi Chris,

select update method 'formula' and try

IF( /BIC/I_MATNR = '', SKIP_RECORD( ), /BIC/I_MATNR )

if I_MATNR is your InfoObject.

You will also find function SKIP_RECORD in function list (the list on the right). If you are familiar to writing ABAP and already created start routine, I would prefer Reddy's solution. I just wanted to add that formula is also possible, because it is quite easy to implement and sometimes people are afraid of coding ABAP

Best regards,

Björn

[Former Member]

Guys I am trying to SKIP a few Materials in my DATA LOAD. And I am using the following formula

IF( MATERIAL = "ABC", SKIP_RECORD( ), MATERIAL )

but I keep getting error "Formula element is not allowed here"

What am I doing wrong???

I need to SKIP a few Materials. If you want to suggest that I write a START or TRANSFER ROUTINE, could you please give me the exact formula Please...

Much appreciated