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 a batch input session? : abap hr

1135


What is off cycle payroll run

2417


What is the difference between a substructure and an append structure? : abap data dictionary

1077


What is the difference between field-group header and other field groups?

941


What is the difference between table and template?

998


What is lock objects? : sap abap data dictionary

1062


What is the lock object?

1029


How are the function code handles in flow logic?

1044


What is design pattern? Provide example .Why are we using it?

1408


What are two methods of modifying sap standard tables? : abap data dictionary

1257


Can i have some Realtime Scenarios on Reports.

2318


What are the parameters in bdc_insert? : abap bdc

1271


What is the different between abap and ooabap? Why do we use ooabap?

1152


Explain how to create any functions? How to go about it?

978


Explain what are the events used for logical database?

944