Select single records behalf of condition

-
some time we get this type requirement to select single records behalf of condition so this code help to to write logic to select single records behalf of 
condition below code help to to show fetch URL TO database and display in export parameter  
FUNCTION zbanner_fm.
*"----------------------------------------------------------------------
*"*"Local Interface:
*"  EXPORTING
*"     VALUE(EX_BANNER_1_1) TYPE  /SAPSMOSS/URL
*"     VALUE(EX_BANNER_1_2) TYPE  /SAPSMOSS/URL
*"     VALUE(EX_BANNER_1_3) TYPE  /SAPSMOSS/URL
*"     VALUE(EX_BANNER_2_0) TYPE  /SAPSMOSS/URL
*"----------------------------------------------------------------------
  DATA : gt_zbanner_home TYPE STANDARD TABLE OF zbanner_home,
         gs_zbanner_home TYPE                  zbanner_home,
         lv_max          TYPE                             i.

* change by Rohini kumar date 4/08/2018
  SELECT MAX( seq_no ) FROM zbanner_home INTO gs_zbanner_home.
  lv_max = gs_zbanner_home-seq_no.
  CLEAR : gs_zbanner_home.
  SELECT SINGLE  seq_no  banner_1_1 banner_1_2 banner_1_3 banner_2_0
      FROM zbanner_home
      INTO ( gs_zbanner_home-seq_no, gs_zbanner_home-banner_1_1,gs_zbanner_home-banner_1_2,gs_zbanner_home-banner_1_3,gs_zbanner_home-banner_2_0 )
      WHERE seq_no = lv_max .
  IF sy-subrc IS INITIAL.
    ex_banner_1_1   = gs_zbanner_home-banner_1_1.
    ex_banner_1_2   = gs_zbanner_home-banner_1_2.
    ex_banner_1_3   = gs_zbanner_home-banner_1_3.
    ex_banner_2_0   = gs_zbanner_home-banner_2_0.
  ENDIF.
**************************** End of change *********************************************
ENDFUNCTION.


*********************************************************************************RICEF
Reports interface Converstion , Enhancements , Forms
Classical Reports ALV Programming, ALE/ IDOC
BDA Programming, Call Transcation , SAP Script, Smartforms, Adove forms,
SAP T-CODE
MM FLOW , SD FLOW , SE11,SE18 ,SE24,SE30, SM12,ST22, SE41, SE51, SE80,SE84
SE90,SE10,SE09,SE03,
Getway T-Code
/IWFND/GW_CLIENT
/IWFND/ERROR_LOG
/IWFND/APPS_LOG
/IWBEP/VIEW_LOG
/IWFND/CACHE_CLEANUP
/IWFND/TRACES


*********************************************************************************

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