Import Transaction Data from a File

You can define a package to import transaction data from a flat file using the following process chains:

IMPORT to import transaction data from a flat file for the Overwrite mode
/CPMB/APPEND to import transaction data from a flat file for the Append mode
/CPMB/IMPORT_APPEND to import transaction data from a flat file for the Clear mode

Note Note

The data can be imported from a file stored on the Application server and FTP source by entering the fully qualified path and file name (see INFILE Prompt() Command).

End of the note.

Prerequisites

The dimension members in the source file must be base members.

Procedure

Create a package using the corresponding process chains for importing transaction data from a file (see Package Usage).
Run the package.
1. Log on to the Planning and Consolidation Office client.
2. Choose Manage Data Run a package .
3. Choose the package you created in step 1 and choose Run.
4. Choose the source file
5. Choose the transformation file.
6. Select one of the following methods to copy the data:
  - Choose Merge data values.
  - Choose Replace and clear data values.
  Note
  This option is not available for the process chain /CPMB/APPEND.
  
  End of the note.
7. To run default logic after the import, choose Yes, then choose Next.
8. To check the work status when importing the data, choose Yes.
9. Choose one of the following options:
  - Run now
  - Schedule
  - Run now & schedule
10. Choose Finish.

Note Note

You can change the default package instructions (see Modifying the Dynamic Script of a Package).

End of the note.

Dynamic script task parameters

Process chain: /CPMB/IMPORT parameter

Task	Parameter	Default Value	Description
/CPMB/CONVERT	CLEARDATA	0	Delete data before writing 0 = NO 1= YES
/CPMB/CONVERT	FILE		File name
/CPMB/CONVERT	SPACKAGE_SIZE	40.000	Package size
/CPMB/CONVERT	TRANSFORMATIONFILEPATH		Transformation file
/CPMB/LOAD	CHCKLCK	0	Check work status 1 = YES 0 = NO
/CPMB/LOAD	CLEARDATA	0	Delete data before writing 0 = NO 1= YES
/CPMB/LOAD	RUNLOGIC	0	Run logic after process 0 = NO 1 = YES

Process chain: /CPMB/APPEND parameter

Task	Parameter	Default Value	Description
/CPMB/CONVERT	FILE		File name
/CPMB/CONVERT	SPACKAGE_SIZE	40.000	Package size
/CPMB/CONVERT	TRANSFORMATIONFILEPATH		Transformation file
/CPMB/LOAD	CHCKLCK	0	Check work status 1 = YES 0 = NO
/CPMB/LOAD	RUNLOGIC	0	Run logic after process 0 = NO 1 = YES

Process chain: /CPMB/IMPORT_APPEND parameter

Task	Parameter	Default Value	Description
/CPMB/CONVERT	CLEARDATA	0	Delete data before writing 0 = NO 1= YES
/CPMB/CONVERT	FILE		File Name
/CPMB/CONVERT	SPACKAGE_SIZE	40.000	Package size
/CPMB/CONVERT	TRANSFORMATIONFILEPATH		Transformation file
/CPMB/LOAD	CHCKLCK	0	Check work status 1 = YES 0 = NO
/CPMB/LOAD	CLEARDATA	0	Delete data before writing 0 = NO 1= YES
/CPMB/LOAD	RUNLOGIC	0	Run logic after process 0 = NO 1 = YES
/CPMB/LOAD	CHCKLCK	0	Check work status 1 = YES 0 = NO
/CPMB/LOAD	RUNLOGIC	0	Run logic after process 0 = NO 1 = YES

Example Example

IMPORT Process:

Read data from source flat file
Transform data
Write data into target application by overwrite mode

APPEND Process:

Read data from source flat file
Transform data
Write data into target application by append mode

IMPORT_APPEND Process:

Read data from source flat file
Transform data
Write data into target application by append mode

End of the example.

Note Note

You can set the Package Size parameter to specify how many rows of data are read at one time. The optimal value for this parameter depends on the SAP NetWeaver system and on additional processing of the data that might occur. Typically, values between 2,000 and 20,000 offer the best performance.

End of the note.