Skip to Content
0
Former Member
Jul 03, 2015 at 07:19 AM

Available Data in target model to add while new data is copied from source to target model

22 Views

Dear Experts

Planned depreciation amount calculation is available in the model CSS_CAPEX, GL account and time wise for the cost center 1010, LC as reporting currency, version 101 & measure is periodic.

1. Data availability in Source model - All these values are based on assets that are planned for procurement in 2015 for specific time period

Header 1 2015.01 2015.02 2015.03 2015.04 2015.05 2015.06 2015.07 2015.08 2015.09 2015.10 2015.11 2015.12 600600 50 50 50 125 125 125 125 125 125 125 600610 1000 1000 1000 1200 1200 1200 1200 1200 1200 1200 1200 600620 2000 2000 2000 2000 2000 2000 2000 2000

2. Destination_app script logic

*XDIM_MEMBERSET CSS_VERSION=101

*XDIM_MEMBERSET CSS_CC=CC_1010

*XDIM_MEMBERSET CSS_TIME=BAS(2015.TOTAL)

*XDIM_MEMBERSET CSS_ACCOUNT=%CSS_ACCOUNT_SET%

*DESTINATION_APP =CSS_PL

*SKIP_DIM=CSS_AST

*WHEN CSS_ACCOUNT

*IS 600600

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

3. Already Planned depreciation values for the existing assets are available in CSS_PL model as below

Header 1 2015.01 2015.02 2015.03 2015.04 2015.05 2015.06 2015.07 2015.08 2015.09 2015.10 2015.11 2015.12 600600 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 600610 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 600620 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 1500

4. Result - When i execute the destination_app it overwrites the available data in CSS_PL which BPC is suppose to do so.

5. Requirement - How to ensure while copying data from one model to another model, the existing data (As shown in Point No.3) is added to the values (as shown in Point No.1) for the represented time periods.

*I have checked the SCN and have gone through suggestions of BADI but not able to identify a solution for the same. Could this be achieved with script logic?