on ‎2025 Nov 11 4:31 PM
Hi Experts, seeking your help on below issue/scenario.
Scenario - Data is being pulled into informatica system from S/4 system via CDS view. CDS view is CDC(change data capture) enabled with table elements and view elemenst.
Issue - if a same key combination single record is changed multiple times( say 3 times) between 2 deltas, then ODQMON has 3 version of same data based on timestamp. However, when it moves to Informatica system, all 3 records flow without timestamp. Timestamp isn't part of CDS view as base table doesn't have change timestamp. So, there is no way in Informatica system to identify the latest record. CDS view with CDC enablement has been created on below FICA tables
DFKKKO - has timestamp
DFKKOP
DFKKOPK
DFKKSUM
DFKKSUMC
DFKKINVDOC_I
DFKKINVDOC_H
DFKKINVBILL_H
DFKKINVBILL_I
Any workaround or any help will be appreciated. Thank You.
Request clarification before answering.
| User | Count |
|---|---|
| 9 | |
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.