版權聲明：本文為部落客汪子熙原創文章，未經部落客允許不得轉載。 https://jerry.blog.csdn.net/article/details/90114298
Requirement
This question is asked by consultant during Jerry’s supporting as dev angel.
Partner wants to develop some report in the backend to track which users have performed what kinds of Fiori group personlization but he didn’t know the corresponding database table which contains the needed information, or available API which can return the necessary information.
How to analyze this requirement
點選Personalization icon：
建立一個新的group, 輸入title資訊後回車，trigger一個send到背景的OData request，成功執行( status code 201 - created )
user 手動輸入的title資訊作為request payload傳入背景：
Solution
Based on backend debugging on the OData request handling displayed above, we can write the following two simple reports.
first report
This report will display the personalization guid with given time period for current user.
顯示輸出：
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. 複制
the second report
将列印出的configuration guid 6BBE9D15576F539BA37A2C26D5E6D424抄下來，執行另一個report。
該report能夠列印出此configuration guid對應的configuration detail：
Source code:
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. 複制