Skip to Content
avatar image
Former Member

Need to enhance search query for Billing Due list

Dear Expert,

BSP Component: BEADLS_BILLDUE

View: BEADLS_BILLDUE/DLHeaderSQ

Context Node: SEARCHQUERY Base Entity DLDynamicSearch

I want to enhance search criteria for base entity DLDynamicSearch with attribute Sales Org and Service Org. I have added these field in structure BEAS_DL_DYNQUERY_IL, now sales org and service org field is coming in configuration, i have added these field in View configuration.

But we need to perform search based on sales org and service org so we have to implement Badi/ Enahncement Spot.

Can you please help me to find Badi/Enahncement Name for Billing document due list.

I have tried enhancement spot ES_CRM_RF_Q1O_SEARCH with filter DLDynamicSearch but it did not hit enhancement spot,

Regards,

Kapil Anand

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 20, 2017 at 07:57 AM

    Got solution of above query, Added field Sales org and service in structure BEAS_DL_DYNQUERY_IL, so these field are avalaible in customziation of view, drag this frild from lef to right.

    Table resposible to show result in billing due list item is /1BEA/CRMB_DLI, this table already has field sales org and service org, hence we have added these field in class CL_CRM_BEA_EXTENSIBILITY method GET_EXTENSION_FIELD under include structure INCL_EEW_BEA_DLI_QS and INCL_EEW_BEA_DLI by enhancing the class method.

    Now end user can serarch based on sales org and service org in Billing due list Item.

    Regards,

    Kapil Anand

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      PFA related to code changes class CL_CRM_BEA_EXTENSIBILITY method GET_EXTENSION_FIELD

      ENHANCEMENT 1 ZCRM_BILLDOC_SEARCH.
      data: ls_field type AXT_EXTINCLUDE_FIELDS.
      data: lv_field type FIELDNAME.
      IF iv_extensible_structure = 'INCL_EEW_BEA_DLI_QS' and et_fieldinfo is NOT INITIAL.
      clear: ls_field, lv_field.
      ls_field-EXTENSION_INCLUDE = 'INCL_EEW_BEA_DLI_QS'.
      ls_field-FIELDNAME = 'SALES_ORG'.
      ls_field-TYPE_KIND = 'C'.
      ls_field-LENGTH = '0014'.
      ls_field-DECIMALS = '0000'.
      APPEND ls_field to et_fieldinfo.

      lv_field = 'SALES_ORG'.
      append lv_field to ET_FIELDLIST.

      clear: ls_field, lv_field.
      ls_field-EXTENSION_INCLUDE = 'INCL_EEW_BEA_DLI_QS'.
      ls_field-FIELDNAME = 'SERVICE_ORG'.
      ls_field-TYPE_KIND = 'C'.
      ls_field-LENGTH = '0014'.
      ls_field-DECIMALS = '0000'.
      APPEND ls_field to et_fieldinfo.
      lv_field = 'SERVICE_ORG'.
      append lv_field to ET_FIELDLIST.
      ENDIF.

      IF iv_extensible_structure = 'INCL_EEW_BEA_DLI' and et_fieldinfo is NOT INITIAL.
      clear: ls_field, lv_field.
      ls_field-EXTENSION_INCLUDE = 'INCL_EEW_BEA_DLI'.
      ls_field-FIELDNAME = 'SALES_ORG'.
      ls_field-TYPE_KIND = 'C'.
      ls_field-LENGTH = '0014'.
      ls_field-DECIMALS = '0000'.
      APPEND ls_field to et_fieldinfo.

      lv_field = 'SALES_ORG'.
      append lv_field to ET_FIELDLIST.

      clear: ls_field, lv_field.
      ls_field-EXTENSION_INCLUDE = 'INCL_EEW_BEA_DLI'.
      ls_field-FIELDNAME = 'SERVICE_ORG'.
      ls_field-TYPE_KIND = 'C'.
      ls_field-LENGTH = '0014'.
      ls_field-DECIMALS = '0000'.
      APPEND ls_field to et_fieldinfo.
      lv_field = 'SERVICE_ORG'.
      append lv_field to ET_FIELDLIST.
      ENDIF.

      ENDENHANCEMENT.