How to filter in odata and how to get fileter values in odata

-

Filter in OData some time requirement to fetch multi pal records behalf of condition
 so here solution to get multiple records behalf of the condition and helping a lot to get detail so happy to share the peace of code you and get a basic idea about how to get multiple records behalf of condition

    DATA : lt_filter TYPE /iwbep/t_mgw_select_option,
           ls_filter TYPE /iwbep/s_mgw_select_option,
           ls_so     TYPE /iwbep/s_cod_select_option.

******   Filter
    lt_filter = io_tech_request_context->get_filter( )->get_filter_select_options( ).

    LOOP AT lt_filter INTO ls_filter.
      CASE ls_filter-property.

a simple method to go for a filter with help of filter you get your values as per the requirements 
    DATA: lt_filter TYPE /iwbep/t_mgw_select_option,
          ls_filter TYPE /iwbep/s_mgw_select_option,
          ls_so     TYPE /iwbep/s_cod_select_option.

****   Filter
    lt_filter = io_tech_request_context->get_filter( )->get_filter_select_options( ).

    LOOP AT lt_filter INTO ls_filter.
      CASE ls_filter-property.
        WHEN 'ZRKNAME1'.
          LOOP AT ls_filter-select_options INTO ls_so.
            MOVE-CORRESPONDING ls_so TO rs_zzrkinfo.
            APPEND rs_zrkinfo TO rt_zzrkinfo.
          ENDLOOP.
        WHEN 'ZRKNAMETYP'.
          LOOP AT ls_filter-select_options INTO ls_so.
            MOVE-CORRESPONDING ls_so TO rs_zrkinfo.
            APPEND rs_zrkinfo TO rt_zzrkinfo.
          ENDLOOP.
        WHEN 'MATNR'.
          LOOP AT ls_filter-select_options INTO ls_so.
            MOVE-CORRESPONDING ls_so TO rs_matnr.
            APPEND rs_matnr TO rt_matnr.
          ENDLOOP.
        WHEN 'ERDAT'.
          LOOP AT ls_filter-select_options INTO ls_so.
            MOVE-CORRESPONDING ls_so TO rs_erdat.
            APPEND rs_erdat TO rt_erdat.
          ENDLOOP.
      ENDCASE.
    ENDLOOP.

Comments

Post a Comment

Popular posts from this blog

all user exit mv45afzz (implicit user exit )

-
MV45AFZZ this is included here all code put related to sales order creation while creating a sales order  va01 this exit trigger so as per your requirement we can write your code here I going to listed different type exit as per the real requirement you find the code and develop your business scenario INCLUDE MV45AFZZ . Modify Screen VA01/VA02/VA03 How to Activated and Deactivated Screen  Export Memory example While Creating a sales order  How to Call workflow While Creating a sales order  TYPES  :  BEGIN  OF  ty_vbak ,           KVGR1  TYPE  vbak - KVGR1 ,           KVGR2  TYPE  vbak - KVGR2 ,          END  OF  ty_vbak . DATA  :  ls_vbak  TYPE  ty_vbak . IF  sy - tcode  =  'VA02'  and  sy - uname  =  'FREDDIE' . BREAK freddie . *SELECT SINGLE KVGR1 KVGR2 *  FROM vbak *  INTO ls_vbak * WHERE vbeln = vbak-vbeln. * *IF vbak-KVGR1 <> ls_vbak-KVGR1 or vbak-KVGR2 <> ls_vbak-KVGR2. *  VBAK-FAKSK = '05'.
Read more

How to Give Dropdown in alv report in sap abap programming Language

-
   IF  p_fieldname  =  'REASONS' .     wa_fcat - f4availabl  =  'X' .    ENDIF .   PERFORM  dropdown_table  CHANGING  g_grid . FORM  dropdown_table  CHANGING  g_grid  TYPE  REF  TO  cl_gui_alv_grid .    DATA  : lt_dropdown  TYPE  lvc_t_drop  WITH  HEADER  LINE .    DATA :  gs_f4  TYPE  lvc_s_f4 ,         gt_f4  TYPE  lvc_t_f4 .    LOOP  AT  it_fcat  INTO  wa_fcat .      IF  wa_fcat - fieldname  =  'REASONS' .       wa_fcat - drdn_hndl  =  '1' .       wa_fcat - outputlen  =  20 .        MODIFY  it_fcat  FROM  wa_fcat .      ENDIF .    ENDLOOP . *CLEAR GT_F4. *  GS_F4-FIELDNAME  = 'REMARK'. *  GS_F4-REGISTER   = 'X'. *  GS_F4-GETBEFORE  = 'X'. *  GS_F4-CHNGEAFTER = 'X'. *  APPEND GS_F4 to GT_F4.    CALL  METHOD  g_grid -> register_f4_for_fields      EXPORTING       it_f4  =  gt_f4 .   lt_dropdown - handle  =  '1' .   lt_dropdown - value  =  'Loadability Issue' .    APPEND  lt
Read more

Long Text in input and output field in module pool

-
Image
display long text in input and output field then below code help you how to display long text your input and output fields in sap ************************************************************************ * Program Name      :  ZLONG_TEXT_EDITOR           Object ID:   p002    * * Description       :  Long text with function module                   * * Create Date       :  26.12.2018                                      * * FO Owner          :  Rohini kumar                                    * * Tech Owner        :  Rohini Kumar                                    * * Project Module    :  SD                                              * ************************************************************************ *                        Change Log                                    * ************************************************************************ *  REQ#         DATE         WHO            CHANGE_ID        DESCR     * *-------------------------------------------
Read more