Skip to Content
0
Former Member
Jun 09, 2011 at 02:38 AM

how to left trim in the query designer?

99 Views

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