Conversion File

[Former Member]

Hello Experts,

I am trying to integrate the master data from BW to BPC. In the data I have unauthorised characters like *.

In conversion file I have inserted the following JS script

EXTERNAL	INTERNAL
*	js:%external%.toString().replace(/*/g,'_').split('/').join('_')

Still it is populating an error as

*IXXX IT MFG KLU MES,ZZORG,, is invalid in the transaction data

Regards,

[former_member186338 · Accepted solution]

Hi Mahesh,

Please read some JavaScript tutorial, especially about regular expressions!

To replace all '*' with '_' you neen the following code:

js:%external%.toString().replace(/\*/g ,'_'))

'*' is a special character, has to be entered as '\*'

I don't know if you have '/' characters, but you use split and join?

Also looks like your data contain spaces and commas...

B.R. Vadim

[Former Member · Accepted solution]

Hello,

I replaced with the following Script:

js:%external%.toString().replace(/\*/g,'_').replace(/\s/g,'_')

But still I am having the same error. On the same member "*IXXX IT MFG KLU MES". The "," is not  part of the member in BW info object. ZZORG is the Info Object Name in BW..

Regards,

[former_member186338 · Accepted solution]

Yes, .replace(/\s/g,'_') will replace space with '_' The rest depends on your data...

Is it the only ID with spaces inside?

Vadim

[Former Member · Accepted solution]

Hello Vadim,

Yes . Other records also have space.

But the conversion file is not able to handle this record.. it gives the same error "is invalid in the transaction data".

I tried multiple Options:

1. *                                            js:%external%.toString().replace(/\*/g,'_').replace(/\s/g,'_')

2. *                                            js:%external%.toString().replace(/\*/g,'_')

3. *IXXX IT MFG KLU MES      *SKIP

But None of this work. Even it is not able to skip the record? Is it because it starts with * and that is used as Wildcard.

[former_member186338 · Accepted solution]

And the error text is the same?

What is the ID for this line in BW?

[Former Member · Accepted solution]

The ID in BW is *IXXX IT MFG KLU MES.

There is no Text in BW for this ID.

Error Log:

*IXXX IT MFG KLU MES,ZZORG,, is invalid in the transaction data

model: PLANNING. Package status: ERROR

Regards,

[former_member186338 · Accepted solution]

Can be a specific issue with the ID starting with * and containing spaces... You can try ABAP debugging or open a ticket in SAP support.

Vadim

[Former Member · Accepted solution]

Hello,

You are right. When I am removing that record starting with * it is loading it.

Thanks.

Regards,