09-06-2010 4:48 AM
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
09-07-2010 7:25 AM
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,
09-08-2010 7:40 AM
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.
09-08-2010 7:40 AM
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.
09-08-2010 7:40 AM
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.
09-08-2010 7:40 AM
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.