Badi 'FAV_DBHINT'

[Former Member]

Hi,

Wat is the use of the BADI 'BBP_FAV_DBHINT' in SRM ?

Any one can xplain in detail ?

BR/

Maron

[masa_139]

Hi,

It looks setting a flag to use DB side optimizer for F4 search. Please check the code IF_BBP_HIERARCHY_F4~SEARCH.

...

IF LV_X_USE_HINT = 'X'.

• hint usage requested

IF SY-DBSYS(3) = 'ORA'.

• force Oracle to use rule-based optimizer

SELECT A_{CATEGORY_GUID A}CATEGORY_ID A~NON_ASSIGNABLE

B_{PRODUCT_TYPE B}LOGSYS

C~CATEGORY_TEXT

APPENDING TABLE LT_CATEGORIES

FROM COMM_CATEGORY AS A INNER JOIN COMM_PRCAT AS B

ON B_{CATEGORY_GUID = A}CATEGORY_GUID

INNER JOIN COMM_CATEGORYT AS C

ON C_{CATEGORY_GUID = A}CATEGORY_GUID

AND C~LANGU = SY-LANGU

WHERE A~CATEGORY_GUID IN LRT_CATEGORY_TMP

AND A~HIERARCHY_GUID = LV_HIERARCHY

%_HINTS ORACLE 'rule'.

ELSEIF SY-DBSYS(3) = 'DB6'.

• tell DB6 to use optimizer level 0

...

Regards,

Masa