How to combine Tables GLPCA & GLPCP
I have a requirement to show Actual and Plan values for Material and GL Accounts in a Report.
The Actual values come from GLPCA table and the Plan values come from GLPCP table. But the problem is that the GLPCP table continas the values on period basis.
Could you please help me find a solution on how to combine data from these 2 tables and display in the report.