I need a clear explanation on 0RECORDMODE and delta management.
1. When data is moved from the SAP source system to a DSO, is the 0RECORDMODE used in the source system before writing the data to the DSO.
2. Or is the Data written as is in the Activation table and then 0RECORDMODE is used to move the data from Activation table to the Active table.
3. What happens when a DSO is either set to Additive mode or Overwrite mode. Do we choose this mode based on the type of delta supported by a DataSource?
4. If I have a string value in one of the DataFields of my DSO, how is the change to that tracked? Or only numerical fields are allowed?