2LIS_11_VAITM Recordmode to X in ODS records
I have a problem with one ODS receiving records from several InfoSources.
One of these is 2LIS_11_VAITM. Some of the records loaded from this InfoSource apepar in the ODS with RECORDMODE = 'X'. As some of the key figures (such as CML_ORD_QTY) are negative, I believe the last update that was received from the 2LIS_11_VAITM InfoSource was marked as a 'before Image' record.
This is very strange in the case of my ODS, because when I check the corresponding sales order in the R/3 system, I only see changes and no deletions.
My theory about this is that for some reason during the loading of data to the ODS, the after image is read before the before image. If this happens, then the sales order item record would be set to RECORDMODE = X and keyfigures would be negative.
If this is the case, how can I ensure that records are processed in the correct order?
Could someone give me some advice on this?