DTP between DSO and same DSO
Is it possible to move data through a transformation from a DSO back to itself? We have a requirement to do this so we only have to update those records where the status is not yet complete - therefore optimising performance. For example, we would key the DSO on sales order document number and item number. That order item would move from OPEN to COMPLETE through various intermediate stages peculiar to our business process. We would want to update the status each night but cannot rely on the change of status causing a delta for the sales order item. Once it has reached COMPLETE we would no longer be interested in updating the status.