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...
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                                      * * F...
Read more

MB_MIGO_BADI THIS BADI USED TO POSTING DATA IN MIGO

-
Here this badi used to how to work migo data migration and help to creating magi used to save  and validation of data  MB_DOCUMENT_UPDATE method  IF_EX_MB_MIGO_BADI ~ POST_DOCUMENT .    BREAK-POINT .    IF  is_mkpf - budat < is_mkpf - BLDAT .     sy - ucomm  =  'ENT1' .      MESSAGE  'Posting Date Should Not Be Less Than Document Date'   TYPE  'E'  .      SET SCREEN  syst - dynnr .      LEAVE SCREEN .    ENDIF . endmethod .
Read more