Hi,
I am on BPC 7.0NW.
This is the scenario -
I have an application - A_HR, which has
For Cost Center 1000:
Employee ID A_WAGES
1000 A_SAL 100
A_COMP 10
1001 A_SAL 200
A_COMP 20
For Cost Center 1001:
Employee ID A_WAGES
1002 A_SAL
A_COMP
1003 A_SAL
A_COMP
A_SAL and A_COMP are the lower nodes of A_WAGES i.e. A_WAGES is assigned in the PARENTH1 column of these two.
I have another application in the same appset (say A_CC) which needs to pick this data up.
So in that application I have to pick up the values of A_SAL and A_COMP only at the Cost Center level i.e. for Cost Center 1000, it should pick the total value of the employee salary (300 in this case - 100200)and comp (30 in this case - 1020).
Can someone share a code to do this?
Thanks.
Anand