Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is roll area?

1031


Why we are using Macros instead of Function Modules

2147


Explain what is the difference between sy-tabix and sy-index? Where it is used?

1052


I need some information regarding Vcentric Test pattern ? with questions.

2176


Module Pool Programming: Events and Table Control handling.

1394


How can an internal table with header line and one without header line be distinguished when passed to a subroutine? : abap modularization

1094


Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?

2076


What is the difference between the exits created in M.M and S&D?

2112


What is meant by a schema? : sap abap hr

1154


What are the 2 other types of views, which are not allowed in release 3.0?

1128


How can we determine a vendor is Bloc/Unblock from the table LFA1?

2105


What is the function of a domain?

1222


How do you do bdc for a table control? : abap bdc

1196


what is call back in alv?

2472


Double click function on the lists, identifying the line selected by the user on the list?

1048