cancel
Showing results for 
Search instead for 
Did you mean: 

Skip Deleted Record for Cluster Table is not working in SLT

Parthi1
Explorer
0 Kudos

Hi All

We are trying to skip the replication of deleted records from source (SAP) to HANA using Event related rule for BSEG table. But the records are getting deleted in HANA. We have used the same process for other tables like MSEG,MARD and its working fine. We are validating the IUUC_OPERAT_FLAG, if its "D", then SKIP records.

In BSEG table records are getting deleted and not working as expected.

Could you please help in understanding the cause of issue.

Thanks

Parthiban

Accepted Solutions (1)

Accepted Solutions (1)

andrey_martynov
Active Participant
0 Kudos

The table BSEG is cluster table.

The replication migration object is created to RFBLG table. Try to create a rule to this table.

Parthi1
Explorer
0 Kudos

Hi Andrey

Could you please provide your comments my below reply.

Thanks

Parthiban

Answers (2)

Answers (2)

Parthi1
Explorer
0 Kudos

Hi Andrey

We have tried the same by creating the rule for RFBLG.

Still deletion is not working.

andrey_martynov
Active Participant
0 Kudos

Now, your coding is wrong. Have not you get a syntax error when you try to release the rule?

Please remove the input parameter from the rule. The field symbol already known in program.
In program remove the 4 line (ASSIGN (i_p1) ...).
On 5 line instead <ls_data> write <wa_r_bseg>
After this correction it should work.

Parthi1
Explorer
0 Kudos

Hi Andrey

Thanks for your quick response

We have tried creating rule for cluster table RFBLG but its not working.

We have tried both field related rule and event related for SKIP deletion, but its not working.

Code:

andrey_martynov
Active Participant
0 Kudos

but as I see on screenshot you create a rule to the table BSEG. As I wrote above in LTRS you have to add table RFBLG and add the rule for this table.