Master Data from BW TO BPC

52 Views

HI Friends,

I'm facing the master data upload issue from BW TO BPC,in BW for GL MASTER Info object is OGL_ACCOUNT now in info object my GLAccount is appearing in this series 0000100000 but in BPC i need excluding zeros l.e 100000.

EX:IN BI 0GL_ACCOUNT 88880000461010

IN BPC I NEED 461010

For this in transformation file in Mapping column i used different combinations as follows:

ID=ID

ERRORS

Validate has successfully completed

ValidateRecords = YES

Master data (dealt by table level) has errors

Detected duplicate member ID '0000610100'

Detected duplicate member ID '0000610110'

THEN I USED THE FOLLOWING IF CONDITIONS

ID=IF(ID(1:4)=STR(8888))

ID=IF(ID(1:8)=STR(88880000))

ID=IF(ID(1:8)=STR(88880000)-ID)

ID=IF(ID(1:4)=STR(0000)-ID)

But i'm not able to achieve,could anybody who worked onthis could let me know how to achieve this its very urgent.

Thanks in Advance