topic Re: Concatenation output in Application Development and Automation Discussions

Concatenation output

Former Member — Tue, 01 Dec 2015 06:28:00 GMT

Hi, I am creating a CDS view. I am concatenating two fields from a table "LFA1"

The fields are:

lifnr(supplier id)[TYPE: CHAR : LENGTH:10]

name1(supplier name)[TYPE: CHAR : LENGTH:35]

So when I concatenate like:

Concat(Concat(Concat(Vendor.name1 , '('),Vendor.lifnr),')') as MySupplier

I get something like:

Geller(0000100791)

These "0000" are appended. I guess its done to match length of lifnr .

But I don't want it to display like this. I want it to appear as-

Geller(100791)

Is there any workaround?

Thanks.

christian_seitel — Tue, 01 Dec 2015 10:12:25 GMT

Hi,

is the function LTRIM available in your system ?

LTRIM( Vendor.lifnr, '0' ) is what you are looking for.

Regards, Christian

CarineTchoutouo — Tue, 01 Dec 2015 10:36:43 GMT

Additional Info:

The string function LTRIM is available as of AS ABAP 7.5:

Former Member — Tue, 01 Dec 2015 13:36:42 GMT

Thanks a lot Carine, Very useful document.

Former Member — Tue, 01 Dec 2015 13:42:18 GMT

Thanks a lot Christian, It worked