abap语言中是不能使用select语句直接从维护视图(maintenance view)中抽取数据的,会报错说维护视图在数据字典中不存在,如下:
"YEKKO" 没有在 ABAP 字典中定义为表、映射视图或数据库视图。
<img class="alignnone size-full wp-image-6090" src="http://www.baidusap.com/wp-content/uploads/2018-08-07_14-06-54.jpg" alt="" width="480" height="145" />这时可以通过函数VIEW_GET_DATA来读取维护视图中的数据。
<img class="alignnone size-full wp-image-6091" src="http://www.baidusap.com/wp-content/uploads/2018-08-07_14-26-19.jpg" alt="" width="863" height="360" srcset="http://www.baidusap.com/wp-content/uploads/2018-08-07_14-26-19.jpg 863w, http://www.baidusap.com/wp-content/uploads/2018-08-07_14-26-19-740x309.jpg 740w, http://www.baidusap.com/wp-content/uploads/2018-08-07_14-26-19-768x320.jpg 768w" sizes="(max-width: 863px) 100vw, 863px" />下面通过一个简单例子说明如何使用此函数。
首先在系统中SE11创建一个维护视图YEKKO
<img class="alignnone size-full wp-image-6092" src="http://www.baidusap.com/wp-content/uploads/2018-08-07_14-10-17.jpg" alt="" width="923" height="291" srcset="http://www.baidusap.com/wp-content/uploads/2018-08-07_14-10-17.jpg 923w, http://www.baidusap.com/wp-content/uploads/2018-08-07_14-10-17-740x233.jpg 740w, http://www.baidusap.com/wp-content/uploads/2018-08-07_14-10-17-768x242.jpg 768w" sizes="(max-width: 923px) 100vw, 923px" />SE54为维护视图创建表维护。
<img class="alignnone size-full wp-image-6093" src="http://www.baidusap.com/wp-content/uploads/2018-08-07_14-09-05.jpg" alt="" width="681" height="486" />例子代码如下:
REPORT ytest_select_maintenance_view. DATA:go_tab TYPE REF TO data. FIELD-SYMBOLS:<fs_tab> TYPE table. START-OF-SELECTION. CREATE DATA go_tab TYPE TABLE OF ('YEKKO'). IF go_tab IS BOUND. ASSIGN go_tab->* TO <fs_tab>. CHECK <fs_tab> IS ASSIGNED. ELSE. EXIT. ENDIF. CALL FUNCTION 'VIEW_GET_DATA' EXPORTING view_name = 'YEKKO' with_authority_check = 'X' TABLES data = <fs_tab> EXCEPTIONS no_viewmaint_tool = 1 no_authority = 2 no_auth_for_sel = 3 data_access_restricted = 4 OTHERS = 5. IF sy-subrc <> 0. MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4. ENDIF.
运行后,debug模式下能看到field symbol <FS_TAB>中保存了抽取的数据结果集。
&lt;img class="alignnone size-full wp-image-6094" src="http://www.baidusap.com/wp-content/uploads/2018-08-07_14-31-04.jpg" alt="" width="648" height="397" /&gt;以上。