Skip to Content
0
Former Member
Nov 01, 2012 at 06:13 AM

Using comma in Master Data mapping STR function - BPC NW 10

119 Views

Hi

I'm trying to use the mapping section of the master data transformation file to populate a given property.

For our work status, we need to set the OWNER property to include two different team names that are allowed to change work status. Let’s say the team names are Y_BUS_A and Y_BUS_B

Based on the SAP documentation, the property needs to be set to [Y_BUS_A],[Y_BUS_B]

We are trying to figure out how to set this property via transformation, We are trying to use OWNER=*STR([Y_BUS_A],[Y_BUS_B])

However, when we try and validate the transformation file, the system doesn't like the comma between the two team names – probably because it is a standard delimiter?

I have tried breaking it down into a concatenation of three strings (team1, comma, team 2)... I have tried putting it within quotes etc, but no luck

We really need to have the two team names in there, and I haven't found an alternate separator that will work for the OWNER property/for work status.

Anyone here run into this issue before or have any suggested work-arounds?

Thanks for your help!