Denise's IT Story

with bom as ( SELECT *    FROM HIERARCHY (     SOURCE (                 SELECT m1.mandt                 , m1.stlnr                 , m1.stlal                 , m1.stlan                 , s1.stlty                 , s1.stlkn                 , m2.stlnr  as child_bom                   , m1.matnr  as parent_id                 , p1.posnr                 , p1.idnrk  as node_id                          ..

*--- Data Element search select l.rollname, l.datatype, l.leng, l.decimals, l.signflag , t.ddtext, t.reptext from dd04l l , dd04t t where t.rollname = l.rollname and t.ddlanguage = '3' and t.as4local = l.as4local and t.as4vers = l.as4vers and t.ddtext like '%지연%' *--- Domain search select l.domname, l.datatype, l.leng, l.decimals, l.signflag , t.ddtext from dd01l l , dd01t t where t.domname = l...

TYPES : gty_t_query TYPE TABLE OF string. FORM execute_native USING pt_query TYPE gty_t_query CHANGING pt_data TYPE STANDARD TABLE. DATA: lo_conn TYPE REF TO cl_sql_connection. DATA: lo_stmt TYPE REF TO cl_sql_statement. DATA: lo_result TYPE REF TO cl_sql_result_set. DATA: lo_except TYPE REF TO cx_sql_exception. DATA: lv_rc TYPE i. DATA: lv_rows TYPE i. DATA: lv_text TYPE string. DATA: lv_query ..

SELECT h.klart , h.class , c.atnam , t.atbez , w.atwrt , wt.atwtb FROM klah h , ksml s , cabn c , cabnt t , cawn w , cawnt wt WHERE h.mandt = '200' AND h.klart = '023' AND h.class = 'SSC_HALB_01' AND s.mandt = h.mandt AND s.clint = h.clint AND c.mandt = s.mandt AND c.atinn = s.imerk AND t.mandt = c.mandt AND t.atinn = c.atinn AND t.spras = '3' AND w.mandt = c.mandt AND w.atinn = c.atinn AND w.ad..

SELECT f.tabname, f.fieldname, t.ddtext, ltrim(position,'0') as position, f.keyflag as "Primary Key", d.rollname as "Data Element", d.domname as "Domain", d.memoryid, f.datatype, ltrim(f.leng,'0') as leng, f.checktable, f.reftable, f.reffield, m.entitytab, m.convexit FROM dd03l f, dd04l d, dd04t t, dd01L m WHERE d.rollname(+) = f.rollname AND t.rollname = d.rollname AND m.domname(+) = d.domname ..