how can i fetch the records of 3 tables with a single select
query,without using join.

Answer Posted / pratima

You can create a View table and use only one select
statement.

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are types of select statements?

822


What is new enhancement framework?

1118


What is a 'z' report?

866


1. If I send 5 entries of table from one system to another system, if the only 4 entries there in the target system what I have to do? 2. If I send the customer master IDOC from one SAP system to another system, if one field is missing in target table what is the steps? 3. If I want to access the 4th row 3rd column in the hashed table how to do it? 4. Whether there is any other statement than MODIFY statement to modify the content of internal table?

1677


Tell me a scenario where did you use secondary index?

843


How to get that a secondary index is attached to a select query?

1153


What are the advantages of abap query tool?

764


How to eliminate duplicate entries in internal tables?

914


What is the differences between structure and table in data dictionary in abap?

826


How to convert the Unit for 'Distance' (The value from one Unit to another).

1692


What are the screen elements.

764


When a program is created and need to be transported to prodn does selection texts always go with it? If not how do you make sure? Can you change the cts entries? How do you do it?

804


Differentiate between static and dynamic step loops?

803


What is the procedure you followed to upload the data?

779


what precautions or prerequisites do you follow to update a record into database table and how

5667