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 ?