Unable to pull duplicate record in BW

21 Views

I am working on E-Recritment module.

I have to get candidate education details in BW but those are not available in standard extrator (0CANDAIDATE_ATTR & 0CAND_TD_ATTR). For that I have enhanced DS by fields INSTITUTE, START_DATE & END_DATE. My extractor is working fine & I am able to see all the records in RSA3.

I am getting these records upto PSA but when I want to update further to Info Object Candidate is giving error as Duplicate Records.

Problem is occuring in extracting the details such as Institute (from table HRP 5104) as each candidate is having more then one institute & BW is rejecting duplicate records.

Eg. 0OBJID INSTITUTE START_DATE END_DATE

50038860 ABC 10.06.1965 20.05.1973

50038860 XYZ 20.05.1976 15.05.1978

50038860 PQR 30.05.1978 12.05.1980

Alternatively I have done compounding of InfoObject but stll is not giving correct result.

Can anybody five idea to solve this.

Thanks in advance.