Skip to Content
0
Mar 03, 2017 at 11:55 AM

Possibilities to capture Delta for CATSDB table including statuses(50,60).

229 Views Last edit Mar 03, 2017 at 02:26 PM 2 rev

Dear Gurus,

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.

Thanks

Yogi