Hierarchy Transformation Example 
Transformation file:
*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = TAB
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=YES
CREDITPOSITIVE=YES
MAXREJECTCOUNT=
ROUNDAMOUNT=
*MAPPING
NODENAME=NODENAME
HIER_NAME=HIER_NAME
PARENT=PARENT
ORDER=ORDER
IOBJNM=IOBJNM
VERSION=VERSION
*CONVERSION
HIER_NAME=HIER_NAME.xls
NODENAME=HIER_NAME.xls!
NODE_NAME PARENT=HIER_NAME.xls!NODE_NAME
Corresponding conversion file definition:
Tab1 CONVERSION:
A |
B |
C |
|---|---|---|
External |
Internal |
Formula |
HIERARCHY1 |
PARENTH1 |
Tab2 NODE_NAME:
A |
B |
C |
|---|---|---|
External |
Internal |
Formula |
* |
js:%external%.split(' ').join(“) |
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.