How to Execute SQL Statements Directly via SQL Command Editor in Sap St04

HOW TO EXECUTE SQL STATEMENTS DIRECTLY DIRECTLY VIA VIA SQL SQL COMMAND COMMAND EDITOR IN SAP ST04 GALLERY AUGUST 26, 2013 ERIC LEAVE A COMMENT

Som!"m#, $o% m"&'! ()*! !o +%! ) SQL omm)*-.#/"! -"/!$ ("!'o%! %#"*& AAP /o&/)m "* SAP #$#!m Yo% )**o! (/"! )* AAP o- "* *o*-5om*! o+ -"/!$ o/ $o% -o *o! ()*! !o (/"! ) 7% AAP /o&/)m 8%#! 7o/ +%!"*& ) SQL ! T'"# o#! (o%- #'o( $o% o* 'o( !o *!/ SQL o- )*- +%! !'m -"/!$ ("!'o%! )*$ AAP /o&/)m 5") SQL omm)*- -"!o/ 7%*!"o* /o5"-- $ SAP DA o9"! o/ SAP ST04 !/)*#)!"o* Yo% &o! !o ')5 SQL 9*o(-& !o -o !'"#  : T')! "# ) / o*-"!"o* M$ *5"/o*m*! "# )#- o* O/) 110 )*- SAP ECC 60 Co*!*!# o7 !' o#!; 1 W')! W' )! "# SA SAP P %!" %!"" "!" !"# # 7o 7o// + + %! %!"* "*& & SQL SQL o omm mm)* )*- -" -"// ! !$ $ 2 G* G */) /) #! #! # !o !o + + %! %!  SQL SQL o omm mm)* )*- "* "* SAP SAP #$ #$#! #!m m 3 A 7( +)m# 4 O!'/ 7 7)!%/# o7 o7 SQ SQL o omm)*- -"!o/ 

1 What is SAP utilities for executing SQL command SAP DA Co9"! /o5"-# ) SQL omm)*- -"!o/ 7o/ $o% !o *!/ ) SQL #!)!m*!.#/"!, )/# "!, +%! "! )*- /5"( !' /#%! -"/!$ ("!'o%! )*$ AAP 9*o(-& Yo% )* )## SAP DA Co9"! 5") SAP !/)*#)!"o* o- DACOCSQL Comm)*- E-"!o/? !o )%*' !' SQL omm)*- -"!o/ #/* : /7/ !o @&%/ 1

Figure 1 – SAP SQL Command Editor Screen

2 General stes to execute SQL command in SAP s!stem No( #!# !o /%* SQL #!)!m*! "* SQL omm)*- -"!o/; 1 E*!/ SQL omm)*- "* !' >ENTER SQL S!)!m*!? !)  /7/ !o B"&%/ 1  2 P)/# SQL omm)*- 5") -/o-o(* m*% SQL Comm)*- = P)/# B 9$ 3 E+%! SQL omm)*- 5") -/o-o(* m*% SQL Comm)*- = E+%! 4 R5"( !' /#%! : SQL /#%! "# #'o(- "* >R#%!? !) o7 SQL omm)*- -"!o/  Yo% )* $)## >P)/#? #! )*- -"/!$ &o !o >E+%!? I7 $o% -o !')!, SAP (o%- om"* >P)/#? )*- >+%!? "* o* #! I7 SQL #$*!)+ "# *o! o//!, $o% *- !o @+ !' #$*!)+ //o/ Yo% )* /7/ !o o!'/ o*"* -o%m*! !o %*-/#!)*- SQL #$*!)+ )*- 'o( !o @+ SQL #$*!)+ //o/ P)# !)9 *o! #om SAP AAP SQL EQ? )**o!  %#- )# ( N- !o 9*o( mo/ '9 oo9 : E+/! O/) D)!))# A/'"!!%/

" A fe# examles to execute SQL statement using SQL command editor H/ I (o%- #'o( )## !o F%/$ -)!) 7/om SAP o*@&%/)!"o* !), SAP !/)*#)!"o* !), SAP SIS !) )*- O/) #$#!m !) I (o%- #'o( +)m o* #! o* #"*& !), m%!" !) )*- o/) '"*!# !'*")$ Ho !o &"5 $o% #om )#" o*! o* +%!"*& SQL #!)!m*! 5") SQL omm)*- -"!o/

"$1 %etrie&e SAP Con'guration data – one ta(le I* !'"# +)m, ( *- !o &! om)*$ -#/"!"o* 7o/ ) "#! o7 om)*$ o- 7/om SAP !) T001 !) T' SQL "# SELECT m)*-!, %9/#, %!+! BROM !001 WHERE m)*-!  430 AND %9/# IN 0001, AU01 ORDER Y %9/#

E*!/ )o5 SQL #!)!m*! "*!o >E*!/ SQL S!)!m*!?, Do )/#"*&B, !'* +%! BJ, D)!) "# /!%/*- "* R#%! !) P)# /7/ !o B"&%/ 2

Figure 2 retrie&e coman! descrition &ia SQL command editor

A &/)! oo9 o* SAP /7o/m)* : SAP P/7o/m)* O!"m"K)!"o* G%"-; A*)$K"*& )*- T%*"*& SAP S$#!m#, SAP )#"#, SAP A-m"*"#!/)!"o*

"$2 %etrie&e SAP transactional data – t#o ta(les  T'"# SQL "# !o &! o/-/ "*7o/m)!"o* 7/om o/-/ ')-/ VA< )*- o/-/ "!m !) VAP SELECT '5*, o#*/, m)!*/, 9(m*& BROM 5)9 ', 5)  WHERE '5*  5* '5*  00100336J2

P)# /7/ !o B"&%/ 3 7o/ !' SQL )*- /#%!

Figure " %etrie&e order info &ia SQL command editor

"$" %etrie&e data from )racle s!stem re&ie# and ta(le  T'"# "# !o /!/"5 "*7o/m)!"o* /)!- !o )* +"#!"*& SQL )#- o* SQLID P)# /7/ !o B"&%/ 4 7o/ -!)"

Figure * – %etrie&e SQL text &ia SQL command editor

P)# !)9 *o! !')! @&%/  #'o( !' SQL ID )#- o* O/) -)!))# 5"(#

Figure + – Part of SQLStats

"$* ,sing )racle hints in SQL command editor O/) '"*!# )*  %#- !o "*%* SQL )## )!' P)# /7/ !o B"&%/ 6 B% !) )## '"*!# )*- B"&%/ "*-+ '"*!#

Figure - ,sing )racle Full ta(le .ints in SQL Command Editor

Figure / ,sing )racle 0ndex hints in SQL command editor

* )ther features of SQL command editor  Yo% )* #)5 !' SQL $o% *!/- 7o/ #')/"*& o/ )! /7/* $ "9"*& >S)5? o7 %-o(* m*% >SQL omm)*-?  # @&%/ 1 Yo% *- !o &"5 )* SQL #!)!m*! ID T' SQL #!)!m*! ID )*  %#- 7o/ o)-"*& !' #)5- SQL #!)!m*! "*!o SQL omm)*- -"!o/ 7o/ +%!"o*.mo-"@)!"o*  Yo% )* o)- ) >/#)5-? SQL 5") #!)!m*! "- $ "9"*& >Lo)-? "* >SQL Comm)*-? %-o(* m*%  Yo% )#o +%! !' SQL "* )9&/o%*- 8o $ "9"*& >E+%! )9&/o%*-? "* B"&%/ 1 I* !'"# )#, $o% )* '9 /#%! 5") SAP SM3 !/)*#)!"o*, /#%! o7 SQL +%!"o* "# o%!%! !o #oo @ B"&%/ J Bo/ ) o*& F%/$, $o% m"&'! ("#' !o +%! "! "* )9&/o%*- "*#!)- o7 o*"* #"* -%/)!"o* o7 )* o*"* /o## "# *o/m)$ "m"!- $ #$#!m #!!"*& 7o/ ) -")o& /o##

Figure  Execute SQL in Command Editor &ia (acground 3o(

+ Further 0nformation I7 $o% )/ "*!/#!- "* )/*"*& SQL omm)*-#, $o% )* /7/ !o O/) o*"* -o%m*!; '!!;..-o#o/)om.'!m.A101.#Fm-'!m  So 7)/, $o% )* # !')! $o% )* &! "*7o/m)!"o* 7/om SAP !)# )*- O/) !)# $ +%!"*& SQL omm)*- -"/!$ 7/om SQL omm)*- -"!o/ Yo% m"&'! (o*-/ #o (')! )*- 'o( !')! (o%- ' o* SAP )")!"o* /7o/m)* )*)$#"# )*- !/o%#'oo!"*& Yo% )* %# SQL omm)*- -"!o/ !o 5/"7$ ('"' +%!"o* )* "# !!/ 7o/ /7o/m)* Yo% )#o )* 5/"7$ ('!'/ /7o/m)* "# ) )%# o7 %*+!- "*-+ ')*& I (o%- o5/ !'"# 5") +)m "* m$ 7%!%/ o#!

R7/*; '!!;..(((#)/7).+%!#F#!)!m*!-"/!$"*#).