how can i fetch the records of 3 tables with a single select
query,without using join.
Answer Posted / subhasis
using nested select statement we can fectch the data from 3
table.
like
select f1 f2 f3 from table1 into table wa_t1
slect l1 l2 l3 from table2 into table wa_t2
select e1 e2 e3 from table3 into table wa_t2
endselect.
endselect.
endselect.
If I was wrong pls let me inform
Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
what are the various types of parameters and how are they distinguished from one another?
What is append structure?
What is the definition of modification in an sap system and how do they impact an upgrade?
Explain the difference between domain and data element?
What is the logo in sap script?
1.why dont use top of page. wat is the use? 2. wat is sub screen? 3. why u select the session method in bdc ? how many records wil be updated on that time? 4.why dont use start form in script? 5.wat is difference b/w dilldown and interactive report? 6. wat is pf status interactine report?
What is an update task? : abap modularization
What is an interactive report?
What is the relationship existing between the various data elements in data dictionary? : abap data dictionary
Do we have to migrate all sapscript forms to smart forms?
What are the data types of the abap/4 layer?
Is a logical database a requirement/must to write an abap/4 query?
What is a matchcode?
If I have put commit in badi implementation class after update, is it allowed? Also if some standard functionality already implemented an update and now i m doing update and if it fails, what will be the impact of commit?
Can a posting run be deleted? : sap abap hr