Show TOC

Example documentationTransformation Example Locate this document in the navigation structure

 

SourceSAP NetWeaver BW InfoObject 0COSTCENTER has defined the following attributes:

0BUS_AREA

0COMPANY_CODE

0LOGSYS

0OBJ_CURR

0PROFIT_CTR

0RESP_PERS

0RT_LOCATIO

0CO_AREA+ID

Destination dimension COSTCENTER is defined in Planning and Consolidation with the following properties:

ID

EVDESCRIPTION

PARENTH1

SCALING

BUS_AREA

COMPANY_CODE

LOGSYS

OBJ_CURR

PROFIT_CTR

RESP_PERS

RT_LOCATIO

Example Conversion File

EXTERNAL

INTERNAL

FORMULA

*-*

js: %external%.replace("-", "_")

This file is saved as ID_CONVERT.XLS. It is used in the transformation file.

Example Transformation File

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = TAB

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT= *MAPPING

BUS_AREA=0BUS_AREA

COMPANY_CODE=0COMPANY_CODE

LOG_SYS=0LOGSYS

OBJ_CURR=0OBJ_CURR

PROFIT_CTR=0PROFIT_CTR

RESP_PERS=0RESP_PERS

RT_LOCATIO=0RT_LOCATIO

ID=0CO_AREA+ID

*CONVERSION

ID=ID_CONVERT.XLS