Tricky mapping scenario

[anthony_bateman3]

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?

[Former Member]

Hi Anthony

You can update existing tuple and create new one during the one import session if you get two records: one for existing tuple and another one for new one, with different record keys.

You can to do the same import scenario if you will use MDM API instead of standard import operation.

Regards

Kanstantsin Chernichenka

[former_member198313]

Hello Anthony,

Please suggest which is your requirement from below options.

condition type/condition number       Price               Start Date      End Date

or 

condition type/condition number       Old Price         New Price        End Date

+ AG

[Former Member]

Hi Anthony,

Can you please elaborate your requirements a bit?

I am not able to figure out the scenario correctly. Are you talking about Import scenario into MDM system and then you want to add new tuple for the record and change the existing tuple record?

Please elaborate a bit for better understanding. Thank you.

Regards,

Ankush Bhardwaj