Originally posted by jmodic
I guess your WWCIW_SAP.ytcurr table in ACP side is not empty before you start copying. So some records with the same unique constraint values that you are trying to copy from the other table obviously allready exists in your destination table.
Jurij :

Before copy, we truncate the table in ACP....so no question of having any records....


try this query
select
KURST,FCURR,TCURR,GDATU,count(1)
from wwciw_sap.ytcurr
group by
KURST,FCURR,TCURR,GDATU
having count(1) > 1;
Mallika,

Indeed by this query we get a dupilcate records....as i heard from my colleague that in PRO PK is with no validate option and can have dulicates.....

Code:
WW15:W_DBA> select kurst, fcurr, tcurr, gdatu, count(1) from ytcurr
  2  group by kurst, fcurr, tcurr, gdatu
  3  having count(1) > 1
  4  /

KURS FCURR TCURR GDATU      COUNT(1)
---- ----- ----- -------- ----------
M    GRD   USD   19990320          2
P    USD   PTE   19960901          2
Thnaks....but again why will the query with "having option before group by clause" will not work???

Abhay.