This wiki page describes the methods and possibilities to retrieve the POWL result set using HANA Database.
You can use /SAPSRM/BD_POWL_SRCH_DBSYS_OPT Business Add-In to retrieve the search results for a query requested by an end user and format the results as required. This BAdI method enables a high-performance POWL results list to be retrieved and returned to the application. If the BAdI /SAPSRM/BD_POWL_SRCH_DBSYS_OPT is active, the equivalent routines in the standard program are no longer processed. For activating this BAdI you may require a Developer / Registration key.
Follow-on document type
Gets the POWL Result Set
POWL on HANA was implemented using a BAdI instead of a switch, because according to Suite on HANA guidelines the coding changes have to be implemented in a filter-based BAdI implementation as the changes are HANA-specific optimizations and these are not valid for other Database Types.
GET_POWL_SEARCH_RESULT is used to determine the results of the POWL search that are returned based on the search criteria. This ensures that the search routine uses the optimal procedure to search and retrieve results. Any BAdI implementation must ensure that the data for the POWL search results correspond to that of the standard program. You can also use this method to determine if the archived data has to be retrieved.
To fetch role of user
Name of Current User
|IS_SEARCHFIELDS_HANA||Importing||DATA||List of search criteria as requested by the user|
|CHAR2||Business Transaction Category|
|BBP_SUBOBJECT_CATEGORY_DB||Business Transaction Category|
|ET_RESULT_TABLE||Exporting||DATA||Result list based on the search criteria provided|
|EV_ARCHIVING||Exporting||BOOLEAN||X=True, - =False, Space=Unknown|
|CO_MESSAGE_HANDLER||Changing||/SAPSRM/IF_PDO_MSG_CONSUMER||Methods for message handling|
|EV_SKIP_RESULT||Exporting||/SAPSRM/SKIP_RESULT||Flag to Skip the Result|
* business object (CTR, PO, QTE,RFQ,SC, etc.)
Related SAP Notes/KBAs
SAP Note: 1984426 Interface changes: for Personal Object Worklist(POWL) on HANA for PO POWL to display Purchase Orders
SAP Note: 1945127 Interface changes: for Personal Object Worklist(POWL) on HANA for Shopping Cart
SAP Note: 2057414 Status and purch org not shown in POWL for contracts
SAP Note: 1984691 Interface changes: for Personal Object Worklist(POWL) on HANA for Bidder POWL to display the RFx
SAP Note: 1981570 Interface changes: for Personal Object Worklist(POWL) on HANA for RFx
SAP Note: 2039522 POWL on HANA downport