Here is what I wanna achieve. I want to do a delta on Masterdata Text. I'm using a DB View for generic extraction. When I try to do a Generic Delta, I see only 3 fields,MANDT, AUFNR and TXTMD.
Now my question is -
Can I do a delta on AUFNR?
If so, what kind of delta should i be using? (Time stamp, Calender day or Numeric Pointer)
And for the settings, would it be a New Status for changed records or Additive delta?
If the above isnt possible, how would I be able to achieve delta?
Thanks in Advance. Any help or pointer would be appreciated and fully rewarded.
If AUFNR is your data key (which I guess is your case) then you won't be able to do a delta with that information.
For generic deltas you need a field that is updated with every change the source data suffers, like for instance, a timestamp.
In order to perform a generic delta on a table, you need that every time a row is updated on that table:
- A timestamp field is updated on the table, or
- A "last changed" field is updated on the table, or
- A counter is updated on the table
One of these three fields is the field that you'll use to base your delta.
There is a good how to guide on SAP Service that will guide you on the process of creating a generic delta. If you can't find it, let me know.