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,