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

Open SQL join using cast function

Former Member

‎2016 Jan 19 7:36 PM

0 Likes
1,731

Hi All,

I have to join CDHDR and CDPOS using cast function OBJECTID and kostl field which has different length.Is it possible to cast using join function in New abap open SQL.Please help.Thanks.

Hi All,

I have to join CDHDR and CDPOS using cast function OBJECTID and kostl field which has different length.Is it possible to cast using join function in New abap open SQL.Please help.Thanks.

Reply
1 REPLY 1
Read only

former_member183045
Contributor

‎2016 Jan 20 7:49 PM

0 Likes
1,027

ABAP has a specific feature which also can be used to make joins on table without similar key data types: "For all entries"

http://help.sap.com/abapdocu_70/en/ABENWHERE_LOGEXP_ITAB.htm

Regards, Andreas