user commonds get data with join comparing another table in sap abap

Well i going to cover all senario below topic
Reports     : Alv Reports, Classical Report And interactive Reports
Forms       : Scripts and Smart Forms Adove Forms
Interface   : RFC BAPI ALE/IDCS
Converstion : BDC LSMW BAPI

Enhancement : User-EXITS BADI, Customer Exit 

  WHEN 'SUMMARY'.
      LOOP AT gt_vbak INTO gs_vbak.

*    READ TABLE gt_vbak INTO gs_vbak with key vbeln = gs_vbak-vbeln."INDEX selfield-tabindex.
        SELECT a~vbeln b~zieme  b~kwmeng  b~netpr
             INTO TABLE gt_sum
             FROM vbak AS a INNER JOIN vbap AS b
             ON a~vbeln = b~vbeln
             WHERE a~vbeln = gs_vbak-vbeln.
        APPEND LINES OF gt_sum TO gt_final1.
        CLEAR: gt_sum.
      ENDLOOP.
      gt_sum1 = gt_final1.
      CLEAR: gt_final1 , gs_final1.
      LOOP AT gt_sum1 INTO gs_sum1.
        COLLECT gs_sum1 INTO gt_final1.
      ENDLOOP.
      PERFORM f_fieldcatalog4 TABLES gt_final1.
      CLEAR: gt_final1, gt_fcat3, gt_sum , gs_sum.

Comments

Popular posts from this blog

all user exit mv45afzz (implicit user exit )

MB_MIGO_BADI THIS BADI USED TO POSTING DATA IN MIGO

Long Text in input and output field in module pool