Master data table Updation
I am updating the CSKS master data table. The key fields for this table are controlling area, cost center and 'valid to' date.
I have to do data transfers:
I am sending the same cost center two times and i need to create two corresponding records in the receiver side.
First data transfer: I send cost center 'x' under controlling area 'y' and with 'valid from' date as 1850 (year) and 'valid to' date as 2007(for eg)
Second : I send the same cost center 'X' under controlling area 'y' and with 'valid from' date as 2008 and 'valid to' date as 9999 (note the dates are just the year value and are an eg only).
Now since 'valid to' date is one of the key field and both records have diff 'valid to' dates, I expected two records to be created in the receiver. The first record was sent successfully. However after second ALE, the first record was overwritten even when the key fields are different.