topic Re: Open SQL and UNION ALL in Application Development and Automation Discussions

Open SQL and UNION ALL

Former Member — Tue, 19 Dec 2006 14:53:29 GMT

Hi,

I want to do a union all for two open SQL statements at the database level, e.g:

SQL statement 1

UNION ALL

SQL statement 2.

Is this possible with ABAP open sql? I know its possible via native sql or using manipulations via ABAP internal tables (FOR ALL ENTRIES, joins, etc) but I don't want to take these routes and want to do it with just a SQL instead...So is this possible?

Re: Open SQL and UNION ALL

Former Member — Tue, 19 Dec 2006 15:05:01 GMT

A subquery?

Rob

Re: Open SQL and UNION ALL

Former Member — Tue, 19 Dec 2006 15:22:30 GMT

Already covered the sub query option but its not applicable to what I need since I am interested in a union of datasets rather than the results of dataset derived from another dataset.

Re: Open SQL and UNION ALL

Former Member — Tue, 19 Dec 2006 15:30:00 GMT

Hi Thang,

Check this link perhaps it may help.

http://help.sap.com/saphelp_nw2004s/helpdata/en/05/5b0e24d68849d4abcf034885ca82a0/content.htm

Regards,

Ferry Lianto

Re: Open SQL and UNION ALL

sridhar_k1 — Tue, 19 Dec 2006 15:45:33 GMT

Try with two open sql select statements works similar to UNION ALL:

select f1 f2 from tab1 into corresponding fields of table itab.

select f1 f2 from tab2 appending corresponding fields of table itab

Regards

Sridhar

Re: Open SQL and UNION ALL

Former Member — Tue, 19 Dec 2006 17:09:01 GMT

thanks for the info everyone. figured in the end that ABAP OPEN SQL couldn't handle UNIONs very well as per native SQL. Had wanted to transfer the processing logic to the DB but in the end of the day, I gave up and just did the union using internal tables.

Re: Open SQL and UNION ALL

subhamoy_ghosh — Tue, 09 Aug 2016 19:22:40 GMT

This message was moderated.