打印user在指定时间段内做过的personalization detail

97 阅读1分钟

Created by Jerry Wang, last modified on Oct 24, 2015

  • webdynpro configuration

点击Personalization icon:

创建一个新的group, 输入title信息后回车,trigger一个send到后台的OData request,成功执行( status code 201 - created )

user 手动输入的title信息作为request payload传入后台:


执行report:

显示输出:

report source code:

REPORT ZGET_PERSONALIZATION.
PARAMETERS: start TYPE WDY_CONF_USER-changedon OBLIGATORY default sy-datlo,
            end like start OBLIGATORY DEFAULT sy-datlo.
 DATA: lt_config TYPE TABLE OF wdy_conf_user,
       lt_text TYPE STANDARD TABLE OF WDY_CONF_USERt2,
       ls_text LIKE LINE OF lt_text.
 
START-OF-SELECTION.
 
    SELECT * INTO TABLE lt_config FROM WDY_CONF_USER WHERE changedon BETWEEN START and end
       and changedby = sy-uname.
 
    IF sy-subrc <> 0.
       WRITE: / 'no configuration found for given time period'.
       RETURN.
    ENDIF.
 
    SELECT * INTO TABLE lt_text FROM WDY_CONF_USERt2 FOR ALL ENTRIES IN lt_config
       WHERE config_id = lt_config-config_id.
    LOOP AT lt_text INTO ls_text.
       WRITE: / 'id: ', ls_text-config_id, ' description: ' , ls_text-description.
    ENDLOOP.
    BREAK-POINT.

将打印出的configuration guid 6BBE9D15576F539BA37A2C26D5E6D424抄下来,执行另一个report。
该report能够打印出此configuration guid对应的configuration detail:

REPORT ZREAD_WDY_CONF_USER.
PARAMETERS: guid type WDY_CONF_USER-config_id OBLIGATORY.
DATA: lt_config TYPE STANDARD TABLE OF WDY_CONF_USER.
START-OF-SELECTION.
  SELECT  * INTO TABLE lt_config FROM WDY_CONF_USER WHERE config_id = guid
    and changedby = sy-uname.
```要获取更多Jerry的原创文章,请关注公众号"汪子熙":
<img src="https://user-images.githubusercontent.com/5669954/61616089-2a87e180-ac9a-11e9-861d-c29c2cf897af.png">