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

Answer Posted / fawaz

select mara~matnr from mara.
select vbrk~arktx from vbrk where arktx = mara~matnr.
select ........
endselect

Is This Answer Correct ?    0 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

function modules are also external subroutines. State true or false. : abap modularization

607


What is the full form of spro? : sap abap hr

689


How do you validate the selection criteria of a report? And how do you display initial

596


Explain the sequences of event block?

560


We have got some values for Field F1 say 1,2,3,4 and F2 say 10,10,10,10.Now can you tell me what would be the output for F1 if we use At End Of event?and what would be the output for F2 if we use At Last event?Also i want to know what is the difference between Total calculation for At end event and grand total for At last event???

1680






What are the uses of the information in the data dictionary? : abap data dictionary

730


Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button

1774


What are base tables of an aggregate object?

625


How can end-of-selection be used?

636


What is is a match code? : abap data dictionary

687


What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?

750


What are indexes? : sap abap data dictionary

565


What will exactly the hide statement do?

578


What are subroutines? : abap modularization

630


What will be your approach towards optimizing legacy code? Will you suggest change in technology? Does OO ABAP bring any performance benefits? How will you deal with queries in a loop? How will you optimize nested loops?

908