Child pages
  • BD_POWL_SRCH_DBSYS_OPT - BAdI to retrieve the powl result set on HANA
Skip to end of metadata
Go to start of metadata

Purpose

This wiki page describes the methods and possibilities to retrieve the POWL result set using HANA Database.

Overview

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.

Method

Follow-on document type

GET_POWL_SEARCH_RESULT

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.

Methods

GET_POWL_SEARCH_RESULT

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.

Parameters

Type

Associated Type

Description

IV_USER_TYPE

Importing

BBP_IV_USER_TYPE

To fetch role of user

IV_USER

Importing

SY-UNAME

Name of Current User

IS_SEARCHFIELDS_HANAImportingDATAList of search criteria as requested by the user
IV_VARIANT

Importing

CHAR2Business Transaction Category
IV_OBJECT_TYPE

Importing

BBP_SUBOBJECT_CATEGORY_DBBusiness Transaction Category
ET_RESULT_TABLEExportingDATAResult list based on the search criteria provided
EV_ARCHIVINGExportingBOOLEANX=True, - =False, Space=Unknown
CO_MESSAGE_HANDLERChanging/SAPSRM/IF_PDO_MSG_CONSUMERMethods for message handling
EV_SKIP_RESULTExporting/SAPSRM/SKIP_RESULTFlag to Skip the Result

Reference Coding

Class

Method

 /SAPSRM/CL_PDO_SO_SEARCH_*

EXECUTE SEARCH

 * business object (CTR, PO, QTE,RFQ,SC, etc.)

Related Content

Related Documents

BD_POWL_CHNG_SEL_RSLT - Change Selection Result of POWL Search in Feeder

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