Skip to Content
0
Former Member
Mar 25, 2009 at 05:21 PM

Copy data from One Application to Another

61 Views

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