how to left trim in the query designer?

[Former Member]

Hi all,

I have a sceanario like zcust_details contains abcde/1000276 where 1000276 is the customer code (sold to party) how do i truncate this in the query and then reference this field to solto party.

The issue is when the user run the query abcde/1000276 is been displayed but users wants 1000276 text to be displayed which is not been captured in bw system.

so how to truncate and reference the same with 0customer master and display the text values from 0customer text.

thanks

[Former Member · Accepted solution]

Hi Pooja,

It would be easier to achieve this on bachend. You can truncate and store the result in another Object and then display it in your Query.

Deepika