Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to left trim in the query designer?

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
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question