출처 : http://hohojj.egloos.com/1381557
이상하게도 ABAP workbench에 sql query tool이 빠져있음.
마침 Jayanta Narayan Choudhuri 라는 인도분이 만든 yes4sql이라는 query 툴이 있어서 개인적으로 유용하게 사용하던 중 몇몇 아쉬운 점을 고쳐서 사용하게 되었고 성능이 나쁘지 않은 듯해서 원저작자인 Mr. Choudhuri의 동의하에 소스 수정본을 공개하기로 함.
Ridiculously there's no SQL query tool in ABAP workbench.
I was trying to find solution, because standard se16 isn't enough in the field. (Lots of join and join, aggregation, ...)
Finally I found "yes4sql". It's so cool and smoothly works. But there was little lack of functions.
It didn't support aliasing, some aggregate functions, '*', implicitly listed select clause, and some other features.
Especially, increasing the number of columns in select clause makes the response time slower and slower.
So I tried to add more functionality. And here's first release of myself.
The original author, Jayanta Narayan Choudhuri, thankfully agree to distribute it freely.
I'm trying to make it robust, and so far so good. But anyone who find the bug post it here. Don't hesitate please.
ABAP source and screendd
How to make ui (screen 100)
![](http://pds4.egloos.com/pds/200708/03/10/d0029710_04080872.png)
![](http://pds4.egloos.com/pds/200708/03/10/d0029710_0408124.png)
![](http://pds3.egloos.com/pds/200708/03/10/d0029710_04085223.png)
Screen capture
![](http://pds15.egloos.com/pds/200906/19/10/d0029710_4a3aa8970efc1.jpg)
![](http://pds15.egloos.com/pds/200906/19/10/d0029710_4a3aa8afb4951.jpg)
![](http://pds3.egloos.com/pds/200708/03/10/d0029710_04083026.png)
![](http://pds15.egloos.com/pds/200906/19/10/d0029710_4a3aa8fb6ea61.jpg)
Sample queries
select distinct
a~bustransid
b~item_number
count( distinct a~position_amt )
max( distinct a~position_amt )
sum( a~position_amt )
from trdv_trans_flow as a
left join tracv_accitem as b
on a~bustransid = b~bustransid
where a~bustransid in ( select bustransid from trdv_trans_flow )
group by a~bustransid b~item_number
select count( * )
from trdv_trans_flow as a
join tracv_accitem as b
on a~bustransid = b~bustransid
where a~bustransid in ( select bustransid from trdv_trans_flow )
select * from trdv_trans_flow as a
left outer join tracv_accitem as b
on a~bustransid = b~bustransid
where a~bustransid in ( select bustransid from trdv_trans_flow )
select trdv_trans_flow~bustransid flow_number from trdv_trans_flow inner join tracv_accitem as a
on trdv_trans_flow~bustransid = a~bustransid where item_number = 1
댓글 11
-
[퐈]박
2009.12.22 14:31
-
Risky
2009.12.22 18:15
좋은 정보 감사합니다.
4.6c는 yes4sql 오리지널만 가능한것 같아요. ^^;;;
-
썬
2009.12.23 11:10
옷 좋은 정보 감사합니다.
-
G.A.S
2009.12.24 09:56
이거슨 무슨에 쓰는 소스인거죠? -ㅇ-;;
-
Mike
2010.01.06 09:42
유용한 자료 감사합니다. -
ydoory
2010.02.06 23:57
뭔지는 자세히 모르겟지만 좋은 자료 감사합니다.
-
고담
2010.04.20 09:03
어떻게 사용해야 하는건가요???? 궁금합니다. ㅜ
-
KKGGTT
2010.04.21 13:45
무슨자료인지 모르겠습니다.
-
hooni
2010.06.24 08:27
오렌지, 토드와 같이 쿼리문을 바로 테스트 해볼수있는...
SAP상에서 쿼리문을 날려볼수있게 해주는 겁니다.
-
북극곰
2011.01.25 17:10
감사합니다^^ -
LeeMin
2012.03.26 13:59
감사합니다~
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
» | SQL 실행 프로그램 [11] | 열공아밥 | 2009.12.22 | 69305 |
3 | ABAP [문자열] 명령어 정리표 [28] | 문바이 | 2011.05.13 | 69655 |
2 |
퀵뷰어 생성하기
[22] ![]() | utkine | 2012.01.09 | 81000 |
1 | dialog popup screen, modal dialog box 디버그 방법.. [5] | magicsy69 | 2010.09.28 | 96339 |
좋은 정보 감사합니다...