Usage problem: BI Query results as input for CRM Function module

[Former Member]

Hi all,

In my VC model I have maintained a dataservice (BI query) which delivers a customer key to me. I would like to use this specific customer key output as an input parameter in a function module from my CRM system.

I have implemented both data services and mapped the fields. However, the problem is as follows:

The query gives an output customer number: 001044082163. The customer_id in CRM is 44082163, so the output from BW needs to be changed to 0044082163 (as we need to input 10 characters).

So the question is: How can we change the output from BI query 001044082163 to 0044082163 within the VC model?

Best regards,

Jan Laros

[Former Member · Accepted solution]

Hi

try this expression

'00'&MID(@BI_CUST_NO,4,8)

Good luck

Ola

[Former Member · Accepted solution]

You are the best. 10 points awarded. I do not understand that expression yet, but I'll try