cancel
Showing results for 
Search instead for 
Did you mean: 

Custom extractor track the deletes

Former Member
0 Kudos

Hi BI experts,

I have a custom extractor on the table PLAF. how can i track if any order is deleted from the table. Is there a way i can know in bw when a order or an entry is deleted from the table ?

it has these time tracking fields?

PSTMP Last Change to Planned Order: Time Stamp

Please suggest.

Regards,

BWer

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

well it looks like there are no change documents created for the deletion of a order, but it is really deleted from the database. So I think you need to create a shadow table for that and post all order numbers already extracted to that table. Then compare the order numbers (there might be a restriction possible for a specific time range) of plaf with that shadow table. Orders that are posted to the shadow table and no more available in plaf are the deleted ones. Just post the order no with record mode 'D' to bw. After posting to bw delete it from the shadow table. All other orders will be extracted from plaf, posted to bw and the new ones to the shadow table as well.

kind regards

Siggi