help required on RPSCO table?

Hi All,

I wanted to understand the output of RPSCO table.

We follow assembly processing. we faced some discrepancy in planned revenue figures showing up in a custom report (very similar to cn41n) and the Sales Order value.so while searching for many possible reasons for discrepancy, i looked into RPSCO table.i need help in understanding why the table shows value for fiscal year 2017 whereas SO dates are in fiscal year 2013 ? what is the difference between the value type 1 and 29? interestingly the difference between the value for fiscal year 2013 and 2017 in RPSCO is showing up as planned revenue in the report..is there any possible connection?

Please Help.

Please refer the screenshot as given below.

Thanks. 😊