Hi i am surya, i have faced this questions plz give me the
answer.
I have requirement like this, i have two internal tbale like
itab and itab1 in itab i have 50 records, in itab1 100
records are there. When execute this question what will be
the output a]50 b]100 c]150? And how to join two internal
tables what is the syntax for that?

Answer Posted / sameer

hiii surya b clear wid the question first..

n buddy mahesh the synatx is wron for inner n outer joins..

syntax:

select tab1~fields
tab2~fields
into table <body>
from <tab1> inner join <tab2>
on <tab1~field1> = <tab2~field1>.

juz for outer join add in place of inner join.

Cheers.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the list of screen elements?

530


What is a match code? : abap data dictionary

643


What are the parameters in bdc_open_group? : abap bdc

607


What is the use of the statement leave to list-processing?

589


What is the use of a pretty printer?

613






What are the differences between table controls and step loops?

561


The commands through which an abap/4 module can “branch to “ or “call” the next screen are?

636


Why do we use logical blocks in abap program?

1450


What is a batch input session? : abap hr

662


What are the mandatory fields to be filled for BAPI_CUSTOMER_CREATEFROMDATA1

2895


What is the different type of projects? : sap abap hr

531


Explain pai and pbo.

716


What is meant by payscale structure? How did you configure pay scale structure? : sap abap hr

538


What does the insert statement in extract datasets do?

626


What is a report?

750