Join in s4 hana fething inner joine three table

-
Getting the records of the three table 
************************************************************************
* Program Name      :  ZSELECT_HANA1               Object ID:   oo01    *
* Description       :  hana reports                                     *
* Create Date       :  24.10.2018                                      *
* FO Owner          :  rohini kumar                                    *
* Tech Owner        :  Rohini Kumar                                    *
* Project Module    :  SD                                              *
************************************************************************
*                        Change Log                                    *
************************************************************************
*  REQ#         DATE         WHO            CHANGE_ID        DESCR     *
*-----------------------------------------------------------------------
*  001                                                      Initial    *
************************************************************************
REPORT ZSELECT_HANA1.

TYPES: BEGIN OF ty_final,
       vblen type vbeln,
       price   TYPE NETWR_AK,
       matnr type matnr,
      a_matnr type matnr,

      END OF     ty_final.


data: gt_final type STANDARD TABLE OF ty_final,
      gs_final type                   ty_final.


SELECT a~vbeln,a~NETWR,b~matnr,c~matnr
                   FROM zrkvbak AS a
                   INNER JOIN zrkvbap AS b
                   ON a~vbeln = a~vbeln
                   INNER JOIN zrkmara AS c
                   ON b~matnr = c~matnr into TABLE @gt_final
                   WHERE c~matnr = 'LTFA'.
  IF sy-subrc eq 0.
  MESSAGE 'get data success' TYPE 'I'.
 ELSE.
    MESSAGE 'get data not success' TYPE 'I'.
ENDIF.






************************************************************************
* Program Name      :  ZSELECT_HANA1               Object ID:   oo01    *
* Description       :  hana reports                                     *
* Create Date       :  24.10.2018                                      *
* FO Owner          :  rohini kumar                                    *
* Tech Owner        :  Rohini Kumar                                    *
* Project Module    :  SD                                              *
************************************************************************
*                        Change Log                                    *
************************************************************************
*  REQ#         DATE         WHO            CHANGE_ID        DESCR     *
*-----------------------------------------------------------------------
*  001                                                      Initial    *
************************************************************************
REPORT ZSELECT_HANA1.

TABLES: vbak,vbap,mara.

TYPES: BEGIN OF ty_final,
       vblen type vbeln,
       matnr type matnr,
      a_matnr type matnr,
      END OF     ty_final.


data: gt_final type STANDARD TABLE OF ty_final,
      gs_final type                   ty_final.


SELECT A~vbeln AS Sales_Docuemnt,
 B~matnr AS Materail,
 C~matnr AS material_descprtion
 FROM zrkvbak AS A
 INNER JOIN zrkvbap AS B
 ON A~vbeln = B~vbeln
 INNER JOIN zrkmara AS C
 ON B~matnr = C~matnr into TABLE @gt_final
 WHERE C~matnr = 'LTFA'.
  IF sy-subrc eq 0.
  MESSAGE 'get data success' TYPE 'I'.
 ELSE.
    MESSAGE 'get data not success' TYPE 'I'.
ENDIF.

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