ABAP by Ajay

  Maintenance view      *  Maintenance  view is defined to maintain multiple tables data using the transaction code SM30.

 Help View     *  Help view pick the data from left hand side table. Even though there is no match in the right-hand side table.     *  Help view always involve in two data base tables.     *  Help view is used as a selection method in an elementary search help to provide the possible entries from multiple tables. Steps to create the help view: -          *  Execute SE11.           *  Select the radio button view.           *  Provide the help view name.  Click on create.           *  Select the radio button help view.           *  Enter. Provide short description.           *  Provide the initial table.           *  Click on relationships button.           *  Select the required table check box.           *  Enter. Click on view fields tab.           *  Click on table fields. Select each  table. Click on choose.           *  Select the required fields.           *  Enter. Save, check, activate.

 Database view *  If you want to display the data from more than one table then we pick the data from        each table & merge its & display it.   Then it's  better to create database view.  *  Database view is always involved with more than one table. Steps to create database view: -          *  Execute SE11.           *  Select the radio button view.           *  Provide the data base view name.           *  Click on create. Enter.           *  Provide short description.           *  Provide the related tables in left table. Select all tables. Click on relationships.           * Select the check box. Enter.           *  Click on view fields tab.           *  Click on table fields button.           *  Select each  table. Click on choose.           *  Select the required fields.           *  Enter. Save, check, activate. Refer code REPORT  ZRP_DATA_VIEW . select  zst_id ,         zst_name ,         zst_dept ,         zst_fee ,         zst_loc ,         zst_phone          f

     1.  Projection view          *   If you want to display the part of data from single database table, it's better to create projection view.          *   Projection view is always involving single database table.          *   Fetching the data from view is faster than fetching the data from database table.          Steps to create projection  view.               *  Execute SE11.               *   Select the radio button view.                *  Provide the projection view name.                *  Click on create.                *  Select the radio button projection view.                *  Enter. Provide short description.               *   Provide the basis table.                *  Click on table fields button.                *  Select the required fields check box. Enter. Save, check, activate.                Code  REPORT  ZRP_PROJ_VIEW . TABLES : zajay_zstu . data :  it_zstu  type  table  of  zajay_zstu ,       wa_zstu  type  zajay_zstu . select  zst_id         zst_name        

Views      *   Views are logical databases. It doesn't contain the data permanently.       *  At run time only view contains the data.     *  There are 4 types of views.           1. Projection view           2. Data base view           3. Help view           4. Maintenance view   

  Create a basic module pool programming to print message. 1. Goto se80. 2. Select program from dropdown and give program name and click on create. 3. Select the top include and give top include name and select package and save.          * Declare input field like this " DATA :  INPUT ( 20 )  TYPE  C"  in top include . 4.   Right click on program and create screen and give screen number and press enter and give short description. 5. Once check and activate the program. 6. Expand screen and double click on screen number. 7. Click on layout select text field and give name.     * Click on input/output and drag and give name.     * Create button click on push button and give name and fctcode.     *  Create button click on push button and give name and fctcode.          * Click on save and exit. 8. Right click on screen and create screen give screen number press enter and give short description. 9. click on screen 200 and click on layout and design like this using text and push bu

 Module pool programming      * It is used to display custom input screens and output screens.     *   Also called dialog programming     * M odule pool is a collection of screens, flow logic, menu bars, and abap code that you used to build application.     *  It is a special type of programming which is used to create custom sap screen.     *  T code - SE80     * * PBO-process before output. > triggered before mpp screen is displayed.     **  PAI - Process after input > process after mpp screen is displayed.     **  POV - Process onvalue request > triggered when user clicks on search on help or f4 button.     **  POH - process on help request   > triggered when user clicks on search on help or f1 button.

* HIDE SOME BUTTONS IN ALV USING OOPS. REPORT  zajay_oops_alv_demo . TABLES : zajay_zstu . TYPES :  BEGIN  OF  ty_stu ,          zst_id    TYPE  zajay_zstu - zst_id ,          zst_name  TYPE  zajay_zstu - zst_name ,          zst_dept  TYPE  zajay_zstu - zst_dept ,          zst_fee   TYPE  zajay_zstu - zst_fee ,         END  OF  ty_stu . DATA  : it_stu     TYPE  TABLE  OF  ty_stu ,       wa_stu     TYPE  ty_stu ,       grid       TYPE  REF  TO  cl_gui_alv_grid ,       container  TYPE  REF  TO  cl_gui_custom_container ,       it_fcat    TYPE  lvc_t_fcat ,       wa_fcat    TYPE  lvc_s_fcat . DATA : t_fun   TYPE  ui_functions ,      fs_fun  TYPE  ui_func . DATA :  ls_layout  TYPE  lvc_s_layo . DATA  :   i_events  TYPE  slis_t_event ,   w_events  LIKE  LINE  OF  i_events . SELECT-OPTIONS :  s_id  FOR  wa_stu - zst_id . START-OF-SELECTION .    PERFORM  datafetch .    IF  it_stu  IS  NOT  INITIAL .      CALL  SCREEN  100 .    ELSEIF  it_stu  IS  INITIAL .      MESSAGE  'data not found'