topic Re: How to convert a length in Open SQL in Application Development and Automation Discussions

How to convert a length in Open SQL

former_member681953 — Mon, 26 Apr 2021 08:37:26 GMT

I'd like to connect between purchasing order and outbound delivery, using a link beteen [EKKO-EBELN] and [LIPS-VGBEL] and a link between [EKPO-EBELP] and [LIPS-VGPOS].

Both EKKO-EBELN and LIPS-VGBEL are char10, but the length of LIPS-VGPOS(length 6) is different EKPO-EBELP(length 5).

Is it possible to convert the length in SQL?

Re: How to convert a length in Open SQL

pfefferf — Mon, 26 Apr 2021 09:36:19 GMT

Using the CAST expression is an option.

Re: How to convert a length in Open SQL

Sandra_Rossi — Mon, 26 Apr 2021 11:43:53 GMT

The solution depends on your code and on your ABAP version.

Pasting your code would be nice... Is it what you currently have or do you have something else?

...
FROM lips
  INNER JOIN ekko
   on EKKO~EBELN = LIPS~VGBEL
  INNER JOIN ekpo
   on EKPO~EBELP = LIPS~VGPOS
...