Penned the Q after a thorough research/search on the topic.
My business is looking for the statuses(30,40,50,60) of CATSDB table to be captured into BW, for auditing and invoicing(verification) purpose.we shall be negating the old values at the Cube level.
Tried with the Standard extractors but ignored due to the below :
01.One of the extractor doesn't have status and other don't bring the status -60(cancelled records).0CA_TS_IS_1 & 0CA_TS_IS_2
Finally decided to build a Generic extractor on CATSDB table - LAEDA(last change date) as delta pointer expecting my delta update i_updmode ='D'(writing a code to pull all the records with latest change on status) will work fine for me.
But my extractor i_updmode ='D is not getting me the changed status(like from 30 -> 50, 60) when ran Delta, even when no issues at code.
Please suggest if any working view on how to achieve the Delta for CATS.