10-09-2007 8:00 PM
Hi All,
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.
Any suggestions?
Thanks
Mridula.
10-09-2007 8:18 PM
Hi,
Keep the Valid-to date same . It wont update the CSKS with different valid to dates for the same record since it is a primary key. It will update the same when they have different valid from dates.
1000 10010020 31.12.2999 01.01.2002
1000 10010020 31.12.9999 01.01.3000
Regards
Kannaiah
10-09-2007 8:18 PM
Hi,
Keep the Valid-to date same . It wont update the CSKS with different valid to dates for the same record since it is a primary key. It will update the same when they have different valid from dates.
1000 10010020 31.12.2999 01.01.2002
1000 10010020 31.12.9999 01.01.3000
Regards
Kannaiah
10-10-2007 11:29 AM
Hi Kannaiah,
Thanks for your reply. I also have the same thought as yours. Since 'valid to' date is a primary key field; and if both the records have different values in this field, there should be no updation and two separate records should be created.
However the first record is overwritten for some reason.
Any suggestios ?
thanks
Mridula
10-10-2007 7:52 PM
Hi All,
i found the solution myself. If you debug the ale posting process code 'cosm', ale deletes the record in the master data table depending on cost center and controlling area.. it does not allow two records with the same cost center and CA.. even though the table can support it !
thanks
Mridula
10-09-2007 8:47 PM
Did you look at the data just before you sent it (while debugging)? It sounds like you have it set up correctly, so that the two records don't overlap time-wise. Did you check the contents of the table after each set of data was sent? Make sure that you are not overwriting the first data with the second data yourself before sending it.
- April King
10-10-2007 1:39 AM
Hi,
Thank you for your reply. I am sending the records to the receiver via ALE; thus in the sender system there is no change in data. In the ALE using conversions I am changing the data record times.
I debugged the posting program COSM and I found that the cost center records are deleted based on cost center and controlling area. So my first record gets deleted.
Can anyone suggest what I should do next ?
Thanks for your help !
Mridula