A tool to review detail of all saved queries for a given user

简介: Created by Jerry Wang, last modified on Jun 08, 2015

requirement: you have created many saved queries and you would like to get a list of all of them. By double clicking the list item, you can navigate to the detail of each.


image.png

image.png

image.png

report source code:



*&---------------------------------------------------------------------*


*& Report  ZVIEW_SAVED_QUERY


*&


*&---------------------------------------------------------------------*


*&


*&


*&---------------------------------------------------------------------*


REPORT zview_saved_query.



DATA: lt_saved_query TYPE STANDARD TABLE OF crmd_shortcut,


     ls_saved_query LIKE LINE OF lt_saved_query,


     ls_d_query     TYPE crmt_dyn_query,


     lv_guid        TYPE char4 VALUE 'guid',


     lv_type        TYPE char4 VALUE 'type',


     lv_app         TYPE char10 VALUE 'application',


     lv_desc        TYPE string VALUE 'description'.



START-OF-SELECTION.


 SELECT * INTO TABLE lt_saved_query FROM crmd_shortcut WHERE owner_key = sy-uname.



 WRITE: lv_guid COLOR COL_NEGATIVE, lv_type COLOR COL_POSITIVE, lv_app COLOR


 COL_GROUP, lv_desc COLOR COL_KEY.


 LOOP AT lt_saved_query INTO ls_saved_query.


   WRITE: / ls_saved_query-guid UNDER lv_guid, ls_saved_query-type,


   ls_saved_query-application, ls_saved_query-description.


   HIDE ls_saved_query-guid.


 ENDLOOP.



AT LINE-SELECTION.


 PERFORM display_detail USING ls_saved_query-guid.



FORM display_detail USING iv_guid TYPE crmd_shortcut-guid.


 READ TABLE lt_saved_query ASSIGNING FIELD-SYMBOL(<hit>)


   WITH KEY guid = iv_guid.


 ASSERT sy-subrc = 0.



 SELECT SINGLE * INTO ls_d_query FROM crmt_dyn_query


    WHERE query_id = <hit>-parameter_.



   ASSERT sy-subrc = 0.



   cl_demo_output=>display_xml( ls_d_query-selection_param ).


ENDFORM.


相关文章
This job is stuck, because the project doesn‘t have any runners online assigned to it. Go to Runners
This job is stuck, because the project doesn‘t have any runners online assigned to it. Go to Runners
This job is stuck, because the project doesn‘t have any runners online assigned to it. Go to Runners
|
SQL Oracle 关系型数据库
Troubleshooting: Missing Automatic Workload Repository (AWR) Snapshots and Other Collection Issues (Doc ID 1301503.1)
Troubleshooting: Missing Automatic Workload Repository (AWR) Snapshots and Other Collection Issues (Doc ID 1301503.1)
729 0
We cannot activate inspection type for article master in transaction code MM41?
We cannot activate inspection type for article master in transaction code MM41?
We cannot activate inspection type for article master in transaction code MM41?
|
测试技术
Note tool
Sent: Monday, March 23, 2015 2:56 PM https://dewdfgwd:2030/sap/bc/ui5_ui5/sap/znotetool/index.html?sap-client=001&sap-ui-language=EN&sap-ui-appcache=false 把Opportunity,(或者lead,Appointment,task)ID输入,点submit,就能看到下面挂着的note全部的technical information了 后台只能连AG3哈,这个是拿来做单元测试的。 GM6/001 tcode SE80:
Note tool
just found out why the group by does not work for my app, but work for SCN exercise
just found out why the group by does not work for my app, but work for SCN exercise
165 0
just found out why the group by does not work for my app, but work for SCN exercise
why My Lead OPA test add Lead fails
why My Lead OPA test add Lead fails
124 0
why My Lead OPA test add Lead fails
How does ABAP check table work
Created by Wang, Jerry, last modified on Jan 06, 2017
117 0
How does ABAP check table work