HOW DO WE JOIN TWO INTERNAL TABLES USING READT STATEMENT??
Answer Posted / geeta
Hi This I searched on sdn and thought to post .
data: wa_gfsb like line of i_gfsb,
wa_gfsbdata like line of i_gfsbdata,
lv_tabix type sy-tabix.
* Sort Table by Plant.
sort i_gfsbdata by matnr.
loop at i_gfsb into wa_gfsb.
read table i_gfsbdata into wa_gfsbdata
with key matnr = wa_gfsb-matnr binary search.
if sy-subrc is initial.
lv_tabix = sy-tabix.
loop at i_gfsbdata into wa_gfsbdata
from lv_tabix.
if wa_gfsbdata-matnr ne wa_gfsb-matnr.
exit.
else.
wa_gfsbdata-werks = wa_gfsb-werks.
wa_gfsbdata-verpr = wa_gfsb-verpr.
wa_gfsbdata-peinh = wa_gfsb-peinh.
modify i_gfsbdata from wa_gfsbdata.
endif.
clear wa_gfsbdata.
endloop.
endif.
endloop.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What function does data dictionary perform?
What is Group by in Select statement?
Some Realtime Examples on Exits .
What are the aggregate objects in the dictionary? : abap data dictionary
what are the various types of parameters and how are they distinguished from one another?
How to upload more than 2GB file from External Source to SAP?
How do you document ABAP programs? Do you use program documentation menu option?
Where the payroll results are stored
Can multiple abap systems connect to abap database?
Example of table cluster and cluster tables.
Explain buffering
What is the difference between dialog program and a report?
What are types of select statements?
how to see the table output?
what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.