Multiple joins example

loop at gt_equip_work.

select
               ekkn~aufnr             "order
               ekkn~ablad             "Order by
               afih~iwerk             "Plant
               ekko~ebeln             "PO number
               ekko~bedat             "document date
               ekpo~matnr             "material no
               ekpo~txz01             "material description
               ekpo~menge             "Quantity
               ekpo~meins
               ekpo~banfn             "PO requisition
               mara~mtart             "material type
               eket~eindt             "delivery date
*             aufk~objnr             "object number on order
        into  (gi_pmord-aufnr
             , gi_pmord-ablad
             , gi_pmord-iwerk
             , gi_pmord-ebeln
             , gi_pmord-bedat
             , gi_pmord-matnr
             , gi_pmord-txz01
             , gi_pmord-menge
             , gi_pmord-meins
             , gi_pmord-banfn
             , gi_pmord-mtart
             , gi_pmord-eindt)
           , gi_pmord-objnr)
       from ekkn as ekkn
       join aufk as aufk
         ON aufk~aufnr = ekkn~aufnr
       join afih as afih
         ON afih~aufnr = aufk~aufnr
       join ekko as ekko
         on  ekko~ebeln = ekkn~ebeln
       join ekpo as ekpo
         on  ekpo~ebeln = ekko~ebeln
         and ekpo~ebelp = ekkn~ebelp
       join mara as mara
         on  mara~matnr = ekpo~matnr
       join eket as eket
         on  eket~ebeln = ekko~ebeln
         and eket~ebelp = ekpo~ebelp
       WHERE ekkn~aufnr = gt_equip_work-aufnr.
        append gi_pmord.

      endselect.
      sort gi_pmord by eindt.
    endloop.

Comments

Post a Comment

Popular posts from this blog

Export data to xls using OOPS

* REPORT  ZDEMO_EXCEL20 * Demo for method zcl_excel_worksheet-bind_alv: * export data from ALV (CL_GUI_ALV_GRID) object to excel *--------------------------------------------------------------------* REPORT  zdemo_excel20. *----------------------------------------------------------------------* *       CLASS lcl_handle_events DEFINITION *----------------------------------------------------------------------* * *----------------------------------------------------------------------* CLASS lcl_handle_events DEFINITION.   PUBLIC SECTION.     METHODS:       on_user_command FOR EVENT added_function OF cl_salv_events         IMPORTING e_salv_function. ENDCLASS.                    "lcl_handle_events DEFINITION *---------------------------------------------------------------------...
Read more

Factory method ALV sap abap

DATA lo_salv TYPE REF TO cl_salv_table , lo_functions TYPE REF TO cl_salv_functions_list , lo_columns TYPE REF TO cl_salv_columns_table , lo_columns2 TYPE REF TO cl_salv_columns_table , lo_column TYPE REF TO cl_salv_column_table , l_short TYPE scrtext_s , l_long TYPE scrtext_l , l_medium TYPE scrtext_m , lo_display TYPE REF TO cl_salv_display_settings , l_header_text TYPE lvc_title , not_found TYPE REF TO cx_salv_not_found , data_error TYPE REF TO cx_salv_data_error , l_string TYPE string , text TYPE string , oref TYPE REF TO cx_root . CONSTANTS : lc_info TYPE c VALUE 'I' , wc_error TYPE c VALUE wc_e . CLEAR : lo_salv , lo_functions . IF w_alv IS NOT INITIAL . * Use factory method TRY . CALL METHOD cl_salv_table => factory EXPORTING list_display = if_salv_c_bool_sa...
Read more

Delete Selected Record in ALV Report

form delete_selected_information.        data : i_lines type i.      *       Reading the index of the selected row in the ALV grid.   call method addressbook_grid->get_selected_rows        importing             et_index_rows = i_index_rows.      *       Check whether a row is selected or not. If not it popups a *       dialog box as warning to select a row.   describe table i_index_rows lines i_lines.        if i_lines = 0.     message i002.     exit.   endif.      *        Reads the selected rows into work area for display   loop at i_index_rows into i_selected_row.     if sy-tabix = 1.   ...
Read more