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.
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
Post a Comment