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?
Answers were Sorted based on User's Feedback
Answer / gvkondareddy
by using append lines of itab1 itasb2 to itab2
so the answer is 150 records
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / nandy
Hi surya..
please be clear..
because we cant get ur question..
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mahesh
be clear with TAB1 and TAB2 ..ok.. using two tables...
and about the Joins ..
Joins are two types
Inner Join or outer Join
Syntax :
Select * or columns from Table1
<(Jointype) inner join> Table2
ON <condition>
let me now if it is wrong........... about the syntax...
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ish
Hi ,
when u will used joining then the result is depend on which
type of joining ur r using andal so depend on data of both
table ,some data have same or differ.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / saravanan.p
U can't simply display the values of two tables itab and
itab1 without linking/merging it.
1.Linking:
If itab & itab1 requires only one loop then either itab or
itab1 should be read and append to itfinal.
2.Merging:
If itab & itab1 requires two separate loops,then u need to
merge those two internal table.
IF u want to merge it,u need to create itfinal or itab2 or
whatelse u wish,which should be declared by the fields of
both itab and itab1.
But while merging internal tables,those tables should have
atleast one linking fields.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sivaramakrishna
hai surya it is very simple a
append lines of itab from n1 to n2 to itab1.
now sort itab1.
or
appen lines of itab to itab1.
sort itab1.
select with joins is use to join multiple data base tables
to get the data from multiple db tables.
syntax.
select tab1~fields
tab2~fields
into table <body>
from <tab1> inner join <tab2>
on <tab1~field1> = <tab2~field1>.
or instead of using select with joins we can also use
select for all entries for better performence at run time.
or
use
loop at itab into wa_itab.
append wa_itab to itab1. ***but here two table must be of
same type.
end loop
sivasayini@yahoo.com
to transfer data from one itab to another itab.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ramjan shaik(rsrl)
hi..boss..this is ramjan shaik from regional software
research labs(rsrl)
first
ur executing what table
if u execute itab internal table details ,u wil get only 50
records.
if u execute itab1 details , u wil get 100 records
but if u want to merge itab and itab1 details into anothter
new table,u will execute 150 records.for that u have to
inner join two tables into one.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abhishek
use the statement "for all entries".
it joins two internal table at application server with non-
unique key.
but the first table should not be empty otherwise it may
give the dump error.
Abhishek Shrivastava
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ravikanth
@ Answer 8.
A Small Pievce of code not written..
That is,
use
loop at itab into wa_itab.
append wa_itab to itab1. ***but here two table must be of
same type.
CLEAR WA_ITAB.
end loop
Please note it.
Thankyou.
Is This Answer Correct ? | 0 Yes | 0 No |
Explain some essential objects in abap dictionary?
HOW TO DIFFERENT CALL TRANSACTION ON THE BASIS OF DOUBLE CLICKING ON DIFFERENT FIELD.
What is sap luw or update transaction?
if i want to take some matter from a smart form to another smart form .then how is it possible?
2-What is the difference between At New and On change Of inside a loop??I want inside a loop difference not basic difference??
Have you printed any report?
1.Which of the following is not an EXIT command? options: BACK, CANCEL, STOP, EXIT? 2.To write certain contents in sap script without skipping to the next page, which command is used? Options: ADDRESS...ENDADDRESS, PROTECT...ENDPROTECT, AT...ENDAT 3. When using a table control in module pool, which statement has to present in both PAI and PBO. options : FIELD, LOOP..ENDLOOP, CHAIN...ENDCHAIN 4. Lock objects are : options : FUNCTION MODULES, PROGRAMS, TABLES
How to add background picture/graphics in alv report?
How to Business addin function in Standars transactiion code. how it is steps
Explain the concept of clusters in payroll
5. What is the difference between report and script?
what are the Performance technic you used?