BPC10 NW - Conversion File

[Former Member]

Hi Experts,

I'm facing pb while converting MATERIAL from BW to BPC.

My conversion user the following  java script :

EXTERNAL	INTERNAL
*	js:%external%.toString().replace(/,"")

Im trying to use this to replace / symbol i have in BW ID :

Rejected Material :

Dimension member M_EU_LAMX63064100M/P is an invalid member ID

Dimension member M_EU_MELB/HALF is an invalid member ID

Dimension member M_EU_PERF100/40/1019 is an invalid member ID

Dimension member M_EU_WE3H/SL is an invalid member ID

Dimension member M_IE_TVP2RSR.F/H.RED is an invalid member ID

Dimension member M_IE_VT7.B/BLACK.PVC is an invalid member ID

Is there something I m doing wrong ?

Tks a lot for your help,

Olivia

[akos_beres · Accepted solution]

Olivia,

please try this:  js:%external%.toString().replace(/\//g, ""). The syntax is /\/ before the char that needs to be replaced and /g after to find all instances of the character within a string.

Also you can look at this thread for more help.

Akos

[Former Member · Accepted solution]

Thanks Akos,

I 've tried, but I have exactly the same error.

I'm working with BPC 10 SP12 NW on Hana,

Tks a lot,

[former_member186338 · Accepted solution]

Hi Olivia,

The syntax like %external%.toString().replace(/\//g,"") has to work correctly (you can test string processing in any online java script editor). SAP has confirmed the issue only with backslash '\' (note http://service.sap.com/sap/support/notes/2020845) - the correction is only about '\'

Vadim

[bishwajit_das]

Hi,

Please try the following below with "/":-

js:%external%.toString().replace("/","")

also check whether in your transformation file you have mentioned -

Convert_Internal = NO

Regards,

Bishwajit