SAP动态内表与动态SQL技术

1、1SAP动态内表与动态SQL技术动态内表的创建2当程序运行时才能确定内表的结构，我们就需要用到动态内表。动态内表的创建一般有两种方法：1. 使用类CL_ALV_TABLE_CREATE的方法CREATE_DYNAMIC_TABLE；2. 使用RTTI(Run Time Type Services)：CL_ABAP_TABLEDESCRCL_ALV_TABLE_CREATE3使用CL_ALV_TABLE_CREATE创建动态内表：1. 定义动态内表的数据类型type-pools: slis. field-symbols: type standard table, ” 内表指针 , ” 工作区 .

2、 ” 字段data: dy_table type ref to data, dy_line type ref to data, ” 行 wa_fcat type lvc_s_fcat, ” 列结构 it_fcat type lvc_t_fcat. CL_ALV_TABLE_CREATE42. 定义列结构动态内表表结构的定义必须使用表结构与tabletype:lvc_t_fcat一样的内表.clear wa_fcat. wa_fcat-fieldname = MATNR. wa_fcat-datatype =CHAR. wa_fcat-intlen = 18. append wa_fcat to

3、 it_fcat. clear wa_fcat. wa_fcat-fieldname = MAKTX. wa_fcat-datatype = CHAR. wa_fcat-intlen = 40. append wa_fcat to it_fcat. CL_ALV_TABLE_CREATE53. 创建内表call method cl_alv_table_create=create_dynamic_table exporting it_fieldcatalog = it_fcat importing ep_table = dy_table. assign dy_table-* to . creat

4、e data dy_line like line of . assign dy_line-* to .动态内表的操作6获取内表的行指针；获取指定的字段；读/写指定字段的值；read table assigning index 1.if sy-subrc = 0. assign component MATNR of structure to . if sy-subrc = 0. write:/ . endif.endif.RTTI7定义数据类型DATA: CL_STRUTYPE REF TO CL_ABAP_STRUCTDESCR, CL_TABL TYPE REF TO CL_ABAP_TAB

5、LEDESCR, CL_HANDLE TYPE REF TO DATA, WA_COMPONENTS TYPE ABAP_COMPONENTDESCR, IT_COMPONENTS TYPE ABAP_COMPONENT_TAB.DATA: IT_CELLSTABTYPE LVC_T_STYL, WA_CELLSTABTYPE LVC_S_STYL.FIELD-SYMBOLS: TYPE STANDARD TABLE , TYPE ANY, TYPE LVC_T_STYL.使用cl_alv_table_create=create_dynamic_table动态创建内表的时候，如果是Deep S

6、tructure的结构的内表，程序Dump。这时就需要使用RTTI来创建。RTTI82. 定义列结构CLEAR: COMPDESC.WA_COMPONENTS-TYPE ?= CL_ABAP_DATADESCR=DESCRIBE_BY_NAME( EKPO-MATNR ).WA_COMPONENTS-NAME = MATNR.APPEND WA_COMPONENTS TO IT_COMPONENTS.WA_COMPONENTS-TYPE ?= CL_ABAP_DATADESCR=DESCRIBE_BY_NAME( EKPO-MENGE ).WA_COMPONENTS-NAME = MENGE.

7、APPEND WA_COMPONENTS TO IT_COMPONENTS.WA_COMPONENTS-TYPE ?= CL_ABAP_TYPEDESCR=DESCRIBE_BY_DATA( CELLSTAB ).WA_COMPONENTS-NAME = CELLSTAB.APPEND WA_COMPONENTS TO IT_COMPONENTS.RTTI93. 创建内表CL_STRU = CL_ABAP_STRUCTDESCR=CREATE( COMPONENTS ).CL_TABL= CL_ABAP_TABLEDESCR=CREATE( CL_STRU ).CREATE DATA CL_H

8、ANDLE TYPE HANDLE CL_TABL.ASSIGN CL_HANDLE-* TO .4. 操作SELECT * FROM ekpo INTO CORRESPONDING FIELDS OF TABLE UP TO 10 ROWS.WA_CELLSTAB-FIELDNAME = MENGE.WA_CELLSTAB-STYLE = CL_GUI_ALV_GRID=MC_STYLE_ENABLED.INSERT WA_CELLSTAB INTO TABLE IT_CELLSTAB.LOOP AT ASSIGNING .ASSIGN COMPONENT CELLSTAB OF STRUCTURE TO . = IT_CELLSTAB.ENDLOOP.动态SQL10SELECT (column_s