Skip to Content
0
Former Member
Jan 06, 2012 at 11:44 AM

Change TEXT (EVDESCRIPTION) in transformation/conversion

291 Views

Hi,

I have a problem when loading the standard text on an infoobject from BW to BPC.

The problem is that the description on the ID contains "-" and "+" in the beginning. For example:

"- Depreciation".

So there is a "minus" or "plus" in front of the text. So in BPC the text becomes "#NAME?" - because excel thinks it a formula.

I now want to add a conversion to my EVDESCRIPTION, but not sure how to add this to my transformation..

I tried the following:

EVDESCRIPTION=*NEWCOL(TEST)

Just to test what the text field is called in SAP BPC. But this doesn't work.

So !

What is the name of the "text" field in BPC (like id is "ID")

What is the text field from SAP BW ? (is it TXTLG ?).

Thanks,

Jdalby

Edited by: Jørgen Dalby Andersen on Jan 6, 2012 1:05 PM

The specific error is "Description is not allowed to be created by mapping "EVDESCRIPTION"". So apperantly I can not map evdescription when loading from BW.

I would prefer not to do a work around and use open hub to "dump" the infoobject text table to a flatfile and then load it into BPC....