0Record Mode

0recordmode is a field which is added in the DSO level. It helps in fetching the after & before images of data.

First: the 0recrodmode controls how data is posted into cubes or ODS (DSO) Objects.

N for new records
B for Pre Images
' ' for after images
R for Reverse Images
X for Storno
D for Deletion of a Key (only in ODS possible)
Y-Update image

You would see the significance of the 0RECORDMODE if you look at the change log table of the ODS. When the data is loaded for the first time the 0RECORDMODE would get assigned a value "N". Now if you reload the data after sometime and lets say 1 of the records were modified then there will be 2 additional records in the change log table with 0RECORDMODE "X" and "" where X corresponds to Before image and "" corresponds to After image.

So when you do a delta from the ODS the system automatically picks up the changed records from the ODS (using the change log table) based on the 0RECORDMODE value.