Skip to Content
Jun 22, 2017 at 06:51 AM

Unexpected ' ' at position XX in transformation file. *IF THEN formula

591 Views Last edit Jun 22, 2017 at 07:27 AM 2 rev

In order to avoid error for unfilled fields, we use sentence BU = *IF(0DIVISION=*STR() THEN *STR(_NA_BU);0DIVISION).

Transformation file mapping validation ends with this message

[line 15] Unexpected ' ' at position 21 in the mapping formula [*IF(0DIVISION=*STR() THEN *STR(_NA_BU);0DIVISION)]

So, the space before THEN should be eliminated.

If we do that, the validation ends with:

Command error: COL(101 )=

that seems to be related to SAP NOTE 2456763 - Command error: COL() when running BPC data package. The solution of this note is to put a space before and after the THEN, but then we have the previous error missage.