Skip to Content
avatar image
Former Member

Badi 'FAV_DBHINT'

Hi,

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

Any one can xplain in detail ?

BR/

Maron

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 16, 2010 at 04:36 AM

    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 ACATEGORY_GUID ACATEGORY_ID A~NON_ASSIGNABLE

    BPRODUCT_TYPE BLOGSYS

    C~CATEGORY_TEXT

    APPENDING TABLE LT_CATEGORIES

    FROM COMM_CATEGORY AS A INNER JOIN COMM_PRCAT AS B

    ON BCATEGORY_GUID = ACATEGORY_GUID

    INNER JOIN COMM_CATEGORYT AS C

    ON CCATEGORY_GUID = ACATEGORY_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

    Add comment
    10|10000 characters needed characters exceeded