help required on RPSCO table?

[Former Member]

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.

[Former Member · Accepted solution]

Hi,

The value type 1 indicates planned values which are being eminated from project structure and value type 29 is from planned revenue from sales order.

Execute CJEN and check.

Thanks,

Sudhakar

[Former Member · Accepted solution]

The RPSCO table is used by the PS Info system reports, it does not contain the "real" data.  It is updated automatically when you change the real data, but sometimes it gets out of sync with the real data.  Run CJEN, like Sudhakar said, this will reconstruct the RPSCO table and get teh data in sync.