I am trying to map pricing conditions from the COND_A IDoc to a product list prices. We have a requirement that when the date for a list price changes for a condition type, we want to do the following:
1) Map the validity start date to the validity end date of the previous List Price tuple.
2) Create a new List Price Tuple.
Part 2) is clear, part 1 I think I can match because we use the condition number from the IDoc as a key for the tuple, but is it possible to both update an existing tuple and then create a new one in the same mapping operation? And what if I have more than one tuple record with the same condition number but differing end dates, how could I find the last tuple to update?