Show TOC

Example documentationHierarchy Transformation Example Locate this document in the navigation structure

 

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.