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 is roll area?
Why we are using Macros instead of Function Modules
Explain what is the difference between sy-tabix and sy-index? Where it is used?
I need some information regarding Vcentric Test pattern ? with questions.
Module Pool Programming: Events and Table Control handling.
How can an internal table with header line and one without header line be distinguished when passed to a subroutine? : abap modularization
Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?
What is the difference between the exits created in M.M and S&D?
What is meant by a schema? : sap abap hr
What are the 2 other types of views, which are not allowed in release 3.0?
How can we determine a vendor is Bloc/Unblock from the table LFA1?
What is the function of a domain?
How do you do bdc for a table control? : abap bdc
what is call back in alv?
Double click function on the lists, identifying the line selected by the user on the list?