topic Re: Open SQL join using cast function in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/open-sql-join-using-cast-function/m-p/11530783#M1935254 <HTML><HEAD></HEAD><BODY><P>ABAP has a specific feature which also can be used to make joins on table without similar key data types: "For all entries"</P><P><A href="http://help.sap.com/abapdocu_70/en/ABENWHERE_LOGEXP_ITAB.htm" title="http://help.sap.com/abapdocu_70/en/ABENWHERE_LOGEXP_ITAB.htm">http://help.sap.com/abapdocu_70/en/ABENWHERE_LOGEXP_ITAB.htm</A></P><P></P><P>Regards, Andreas</P></BODY></HTML> Wed, 20 Jan 2016 19:49:34 GMT former_member183045 2016-01-20T19:49:34Z Open SQL join using cast function https://community.sap.com/t5/application-development-and-automation-discussions/open-sql-join-using-cast-function/m-p/11530782#M1935253 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.</P></BODY></HTML> Tue, 19 Jan 2016 19:36:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-sql-join-using-cast-function/m-p/11530782#M1935253 Former Member 2016-01-19T19:36:26Z Re: Open SQL join using cast function https://community.sap.com/t5/application-development-and-automation-discussions/open-sql-join-using-cast-function/m-p/11530783#M1935254 <HTML><HEAD></HEAD><BODY><P>ABAP has a specific feature which also can be used to make joins on table without similar key data types: "For all entries"</P><P><A href="http://help.sap.com/abapdocu_70/en/ABENWHERE_LOGEXP_ITAB.htm" title="http://help.sap.com/abapdocu_70/en/ABENWHERE_LOGEXP_ITAB.htm">http://help.sap.com/abapdocu_70/en/ABENWHERE_LOGEXP_ITAB.htm</A></P><P></P><P>Regards, Andreas</P></BODY></HTML> Wed, 20 Jan 2016 19:49:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-sql-join-using-cast-function/m-p/11530783#M1935254 former_member183045 2016-01-20T19:49:34Z