Moving Application Data 
The Data Manager allows you to define a package to move a data range or scope using the process chain /CPMB/MOVE.
The selected transaction data in the target source selection is cleared to 0. The selected transaction data in the source selection is written to the target application. The transaction data in the source is cleared to 0.
Procedure
-
Create a package using the corresponding process chains for moving data (see Package Usage).
-
Run the package.
-
Log onto the Planning and Consolidation Office client.
-
Choose
Manage Data 
Run a package 
. -
Choose the package you created in step 1 and choose Run.
-
Select one of the following methods to copy the data:
-
Choose Merge data values.
-
Choose Replace and clear data values.
-
-
To check the work status when importing the data, choose Yes.
-
Select the data regions for the source and destination.
-
Choose one of the following options:
-
Run now
-
Schedule
-
Run now & schedule
-
-
Choose Finish.
-
Note
You can change the default package instructions (see Modifying the Dynamic Script of a Package).
Dynamic script task parameters
|
Task |
Parameter |
Default Value |
Description |
|---|---|---|---|
|
/CPMB/APPEND_LOAD |
CHECKLCK |
0 |
Check work status 1 = YES 0 = NO |
|
/CPMB/APPEND_LOAD |
RUNLOGIC |
0 |
INTERNAL |
|
/CPMB/APPEND_LOAD |
CLEARDATA |
0 |
Delete data before writing 0 = NO 1= YES |
|
/CPMB/CM_CONVERT |
CLEARDATA |
0 |
Delete data before writing 0 = NO 1= YES |
|
/CPMB/CM_CONVERT |
SELECTION |
Selection |
|
|
/CPMB/CM_CONVERT |
SPACKAGE_SIZE |
40.000 |
Package size |
|
/CPMB/CM_CONVERT |
TOSELECTION |
Selection destination |
|
|
/CPMB/CLEAR_SOURCE_CUBE |
CHCKLCK |
0 |
Check work status 1 = YES 0 = NO |
|
/CPMB/CLEAR_SOURCE_CUBE |
RUNLOGIC |
0 |
Run logic after process 0 = NO 1 = YES |
|
/CPMB/CLEAR_SOURCE_CUBE |
SELECTION |
Selection |
|
|
/CPMB/CLEAR_SOURCE_CUBE |
SPACKAGE_SIZE |
40.000 |
Package size |
|
/CPMB/CLEAR_CUBE |
CHCKLCK |
0 |
Check work status 1 = YES 0 = NO |
|
/CPMB/CLEAR_CUBE |
RUNLOGIC |
0 |
Run logic after process 0 = NO 1 = YES |
|
/CPMB/CLEAR_CUBE |
SELECTION |
Selection |
|
|
/CPMB/CLEAR_CUBE |
SPACKAGE_SIZE |
40.000 |
Package size |
Example
The transaction data in the target selection is cleared to zero first, then all the transaction data in the source selection is written to the target. The transaction data in the source is then cleared to zero.
When set option = Merge, CLEARDATA=0:
Example1:
Source selection: Account=CASH
Target selection: Account=CASH1
Data in the application before the move::
ACTUAL,CASH,2006.MAY,200
ACTUAL,CASH,2006.JULY,300
ACTUAL,CASH1,2006.MAY,100
ACTUAL,CASH1,2006.JUNE,150
Data in the application after the move::
ACTUAL,CASH1,2006.MAY,200
ACTUAL,CASH1,2006.JULY,300
ACTUAL,CASH,2006.MAY,0
ACTUAL,CASH,2006.JULY,0
ACTUAL,CASH1,2006.JUNE,0
Example 2:
Source selection: Time=2006.MAY, DataSrc = INPUT
Target selection: Time=2006.JULY, DataSrc = INPUT
Data in the application before the move::
INPUT, ACTUAL,CASH, LC, 2006.MAY,200
INPUT, ACTUAL,CASH, USD, 2006.MAY,100
INPUT, ACTUAL,CASH, LC, 2006.JULY,300
INPUT, ACTUAL, CASH, USD, 2006. AUG, 500
NO_IP, ACTUAL,CASH,LC, 2006.JULY,150
MANU, ACTUAL,CASH,LC, 2006.JUNE,250
MANU, ACTUAL,CASH,USD, 2006.AUG, 400
Data in the application after the move::
INPUT, ACTUAL,CASH, LC, 2006.JULY,200
INPUT, ACTUAL,CASH, USD, 2006.JULY,100
INPUT, ACTUAL,CASH, LC, 2006.MAY,0
INPUT, ACTUAL,CASH, USD, 2006.MAY,0
INPUT, ACTUAL, CASH, USD, 2006. AUG, 500
NO_IP, ACTUAL,CASH,LC, 2006.JULY,150
MANU, ACTUAL,CASH,LC, 2006.JUNE,250
MANU, ACTUAL,CASH,USD, 2006.AUG, 400
When set option = Replace and clear, this means CLEARDATA=1:
Example 3:
Source selection: DataSource = INPUT, Time=2006. MAY,
Target selection: DataSource = MANU, Time=2006.AUG ,
Data in the application before the move::
INPUT, ACTUAL,CASH, LC, 2006.MAY,200
INPUT, ACTUAL,CASH, LC, 2006.JULY,300
INPUT, ACTUAL, CASH, USD, 2006. AUG, 500
NO_IP, ACTUAL,CASH, LC, 2006.MAY,100
NO_IP, ACTUAL,CASH,LC, 2006.JUNE,150 MANU,
ACTUAL,CASH,EUR, 2006.AUG,250 MANU,
ACTUAL,CASH,USD, 2006.AUG, 400 NO_IP,
ACTUAL,CASH,USD, 2006.AUG, 600 MANU,
ACTUAL,CASH,USD, 2006.JULY, 700
Data in the application after the move::
MANU, ACTUAL,CASH, LC, 2006.AUG,200
INPUT, ACTUAL,CASH, LC, 2006.MAY,0
INPUT, ACTUAL,CASH, LC, 2006.JULY,300
INPUT, ACTUAL, CASH, USD, 2006. AUG, 0
NO_IP, ACTUAL,CASH, LC, 2006.MAY,100
NO_IP, ACTUAL,CASH,LC, 2006.JUNE,150
MANU, ACTUAL,CASH,EUR, 2006.AUG,0
MANU, ACTUAL,CASH,USD, 2006.AUG, 0
NO_IP, ACTUAL,CASH,USD, 2006.AUG, 0
MANU, ACTUAL,CASH,USD, 2006.JULY, 700
Example 4:
Source selection: Time=2006.MAY, DataSrc = INPUT
Target selection: Time=2006.JULY, DataSrc = INPUT
Data in the application before the move::
INPUT, ACTUAL,CASH, LC, 2006.MAY,200
INPUT, ACTUAL,CASH, USD, 2006.MAY,100
INPUT, ACTUAL,CASH, LC, 2006.JULY,300
INPUT, ACTUAL, CASH, USD, 2006. AUG, 500
NO_IP, ACTUAL,CASH,LC, 2006.JULY,150
MANU, ACTUAL,CASH,LC, 2006.JUNE,250
MANU, ACTUAL,CASH,USD, 2006.AUG, 400
Data in the application after the move::
INPUT, ACTUAL,CASH, LC, 2006.JULY,200
INPUT, ACTUAL,CASH, USD, 2006.JULY,100
INPUT, ACTUAL,CASH, LC, 2006.MAY,0
INPUT, ACTUAL,CASH, USD, 2006.MAY,0
INPUT, ACTUAL, CASH, USD, 2006. AUG, 500
NO_IP, ACTUAL,CASH,LC, 2006.JULY,0
MANU, ACTUAL,CASH,LC, 2006.JUNE,250
MANU, ACTUAL,CASH,USD, 2006.AUG, 400
Any software coding and/or code lines / strings ("Code") included in this documentation are only examples and are not intended to be used in a productive system environment. The Code is only intended to better explain and visualize the syntax and phrasing rules of certain coding. SAP does not warrant the correctness and completeness of the Code given herein, and SAP shall not be liable for errors or damages caused by the usage of the Code, except if such damages were caused by SAP intentionally or by its gross negligence.