cancel
Showing results for 
Search instead for 
Did you mean: 

Error during data filtering from SLT

Former Member
0 Kudos

Hi all,

I get an error during the data filtering (field-related rule assignment) from SLT LTRS. The code and the error screenshots are below. Could you please help me?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Saritha_K
Contributor
0 Kudos

Hi Tugce,

Since your event rule is in New state, it will not get executed I think.

With regards to your screenshot, I noticed that the values you are mentioning in import parameter 1 for eg mandt is in small case.

Can you re-write it in uppercase and try once?

Please let us know if it resolved or not.

Regards,

Saritha

Former Member
0 Kudos

Hi Saritha,

Thanks for your help, it worked for me. But, now I get another error for BSEG table and I guess it is related with the syntax. Could you also please help me on correcting it?

Many thanks in advance

Tugce Guler

Saritha_K
Contributor
0 Kudos

Hi Tugce,

I think Not IN is not allowed in this case. Unfortunately I could not test it at my end due to system issues.

Can you try below code-

IF I_KOART_1 <> 'K' AND I_KOART_1 <> 'S'.

SKIP_RECORD.

ELSE.

ENDIF.

Try this in 'line of code'.There is character limit here I guess of 80 or so.

Incase you get a character limit scenario, paste this code in an include and give it a shot.

Let us know if this helps you or not.

Regards,

Saritha K

Former Member
0 Kudos

Thanks Saritha,

Seems like it is solved

Regards,

Tugce Guler

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

In my opinion the error is not caused by this rule. maybe the event related rule ZFILTERING_TEST is causing it.

Anyway I recommend you to filter the data in other way.

please have a look at the following blog:

http://scn.sap.com/community/replication-server/blog/2014/02/25/how-to-filter-on-the-initial-load-pa...

Thanks,

Amir