Skip to Content
0
Oct 01, 2010 at 03:10 PM

BPC 7.5 NW - IF stament in Formule for Transformation File ?

112 Views

Hi, i try load data from 0PROFIT_CTR to BPC reading PDF "How To Import Master Data and Hierarchies into BPC 7.5 from SAP NW BW".

Then use this assing:

*MAPPING
ID=ID
RESPONSABLE=0RESP_USER
BPC=*IF(ID(2:2)=*STR(I) then *STR(I);*IF(ID(2:2)=*STR(D) AND ID(4:4)=*STR(Z) then *STR();*STR(D)))
PAIS=*IF(ID(1:1)=*STR(C) then *STR(CHILE);*STR(PERU))

In Validate get Error for Field BPC : The number in parentheses is incorrect, check your formula

*IF(ID(2:2)=*STR(I) then *STR(I);*IF(ID(2:2)=*STR(D) AND ID(4:4)=*STR(Z) then *STR();*STR(D)))

This line working good :

PAIS=*IF(ID(1:1)=*STR(C) then *STR(CHILE);*STR(PERU))

Examples value for 0PROFIT_CTR is :

CD1Z0101

CD101C01

PI1CA001

CI1CA001

I look sintaxis and is good number in parentheses.

Any idea the problem ?