Export Master Data to a File on the Application Server

You can define a Data Manager package to export master data (dimension members) from a dimension into a file stored on the NetWeaver application server using the /CPMB/EXPORT_MD_TO_APPL process chain.

Activities

Create a Data Manager package by using the corresponding process chains (see Package Usage).
Run the Data Manager package as follows:
1. Log on to the Planning and Consolidation Office module.
2. On the action pane, choose Manage data Run a package .
3. Choose the package created in step 1 and choose Run.
4. Choose the source dimension and select the members.
5. Choose the transformation file.
6. Enter the input application file. The file name includes the folder.
7. Choose Next.
8. Choose Yes if other application data will be added, then choose Next.
  
  Note
  
  Other application information includes application set, application, user name, and time stamp.
  End of the note.
9. Choose one of the following options:
  - Run now
  - Schedule
  - Run now & schedule
10. Choose Finish.

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/APPL_MD_SOURCE	SELECTION		Dimension members
/CPMB/APPL_MD_SOURCE	SPACKAGE_SIZE	40.000	Package size
/CPMB/EXPORT_MD_CONVERT	SAPP	%APP%	Application name
/CPMB/EXPORT_MD_CONVERT	SAPPSET	%APPSET%	Application set name
/CPMB/EXPORT_MD_CONVERT	SPACKAGE_SIZE	40.000	Package size
/CPMB/EXPORT_MD_CONVERT	SUSER	%USERS%	User name
/CPMB/EXPORT_MD_CONVERT	TRANSFORMATIONFILEPATH		Transformation file
/CPMB/APPL_SERVER_TARGET	ADDITIONALINFO		Additional information that is passed to the export file: 1 = YES 0 = NO
/CPMB/APPL_SERVER_TARGET	FULLFILENAME		File name
/CPMB/APPL_SERVER_TARGET	OUTPUTDELIMITER		Column delimiter in file
/CPMB/APPL_SERVER_TARGET	OUTPUTHEADER		Include header information: 1 = YES 0 = NO
/CPMB/APPL_SERVER_TARGET	SPACKAGE_SIZE	40.000	Package size

Example Example

PROMPT(DIMENSIONMEMBER,%DIMENSIONMEMBERS%,"Please select dimension",Please select members,%DIMS%)

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(TEXT,%FILE%,"Input application file",)

PROMPT(RADIOBUTTON,%ADDITIONINFO%,"Add other information(Appset,Application,User,Time)?",1,{"Yes","No"},{"1","0"})

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

TASK(/CPMB/APPL_MD_SOURCE,SELECTION,%DIMENSIONMEMBERS%)

TASK(/CPMB/APPL_MD_SOURCE,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/EXPORT_MD_CONVERT,INPUTNO,%TEMPNO1%)

TASK(/CPMB/EXPORT_MD_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/EXPORT_MD_CONVERT,SUSER,%USER%)

TASK(/CPMB/EXPORT_MD_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/EXPORT_MD_CONVERT,SAPP,%APP%)

TASK(/CPMB/EXPORT_MD_CONVERT,OUTPUTNO,%TEMPNO2%)

TASK(/CPMB/APPL_SERVER_TARGET,INPUTNO,%TEMPNO2%)

TASK(/CPMB/APPL_SERVER_TARGET,FULLFILENAME,%FILE%)

TASK(/CPMB/APPL_SERVER_TARGET,ADDITIONALINFO,%ADDITIONINFO%)

End of the example.

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.