To relate data in RPSCO & PRPS table

Hi,

For BI reports I need to take data from PRPS & RPSCO table. There is a function module created to bring data to BI system.

Now my problem is to capture modified records (new recs, changed recs and deleted recs)

I have following doubts about these tables, Please provide your inputs..

1. In PRPS, OBJNR is a unique value will not be repeated - Is it correct

2. In RPSCO table, OBJNR values are repeating based on other key fields.

If there is a change in WBS element AEDAT field in PRPS is getting updated.

In RPSCO, for a object number if revenue or cost any amount is updated..will it reflect in AEDAT of PRPS?

Thanks in advance,

Priya.D