Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

How to convert a length in Open SQL

former_member681953
Explorer

‎2021 Apr 26 9:37 AM

0 Likes
1,241

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?

2 REPLIES 2
Read only

pfefferf
Active Contributor

‎2021 Apr 26 10:36 AM

0 Likes
1,091

Using the CAST expression is an option.

Read only

Sandra_Rossi
Active Contributor

‎2021 Apr 26 12:43 PM

0 Likes
1,091

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
...