Application Development 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
Showing results for 
Search instead for 
Did you mean: 

How to Show BSID and BSAD together in SQ01

tomomitsu_iijima
Explorer
0 Kudos

Hi everyone.

I want to show BSID and BSAD together in SQ01.

(like FBL5N)

I can found how to JOIN some tables,

but I cannot UNION.

Anyone know how to UNION some tables in SQ01(or SQ02)?

regards.

Edited by: Tomomitsu Iijima on Sep 6, 2010 4:18 PM

5 REPLIES 5

Former Member
0 Kudos

Hi Tom,

You cannot joint BSID and BSAD together. Find out more in

for How to union table in sq01, please do a little research if you're fresher, it would be good for you.

thanks,

0 Kudos

Hi Thien.

I found how to UNION.

I made INFOSET at "Integrated data reading program",

and wrote this:

select * from BSID into CORRESPONDING FIELDS OF TABLE it_data.

select * from BSAD appending CORRESPONDING FIELDS OF TABLE it_data

where augdt in s_augdt.

(My customer want to see clear item that cleared in today and all open item.)

It's my first time to use INFOSET and QUERY.

You've been very helpful.

Thanks a lot.

0 Kudos

Hi Thien.

I found how to UNION.

I made INFOSET at "Integrated data reading program",

and wrote this:

select * from BSID into CORRESPONDING FIELDS OF TABLE it_data.

select * from BSAD appending CORRESPONDING FIELDS OF TABLE it_data

where augdt in s_augdt.

(My customer want to see clear item that cleared in today and all open item.)

It's my first time to use INFOSET and QUERY.

You've been very helpful.

Thanks a lot.

0 Kudos

Hi Thien.

I found how to UNION.

I made INFOSET at "Integrated data reading program",

and wrote this:

select * from BSID into CORRESPONDING FIELDS OF TABLE it_data.

select * from BSAD appending CORRESPONDING FIELDS OF TABLE it_data

where augdt in s_augdt.

(My customer want to see clear item that cleared in today and all open item.)

It's my first time to use INFOSET and QUERY.

You've been very helpful.

Thanks a lot.

0 Kudos

Hi Thien.

I found how to UNION.

I made INFOSET at "Integrated data reading program",

and wrote this:

select * from BSID into CORRESPONDING FIELDS OF TABLE it_data.

select * from BSAD appending CORRESPONDING FIELDS OF TABLE it_data

where augdt in s_augdt.

(My customer want to see clear item that cleared in today and all open item.)

It's my first time to use INFOSET and QUERY.

You've been very helpful.

Thanks a lot.