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 / 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 |
Post New Answer View All Answers
In delivery processing which step comes first picking, packing, posting goods issue ?
Can a domain, assigned to a data element be changed?
there are 2 selection screens. material num in screen 200 and plant in screen 300. so how can you write in INITIALISATION event?
When to use logical database?
What is the syntax for call transaction? : abap bdc
Cds views
What are the pooled and cluster tables?
Explain the difference between domain and data element? What are aggregate object?
How do you document ABAP programs? Do you use program documentation menu option?
What is abap?
What are the different types of mode (run code) in call transaction method?
Can you create an internal table dynamically?(at run time)
What is meant by read lock? : sap abap data dictionary
How to specify a client for database table processing?
How are BAPI different from normal function modules?