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
How can we decide weather we can enhance the standard infotype or not ? : abap hr
Name the abap/4 modularization techniques?
How many types of tables exist and what are they in data dictionary?
What are the functional areas? User groups? And how does abap/4 query work in relation to these?
How to transfer the objects? Have to transferred any objects?
What is the max. No. Of structures that can be included in a table or structure? : abap data dictionary
Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subarc after perform?
wat are the process that can be executed & tracked in a workflow?
what next in SAP-ABAP/4 is it going to be change?
What are the different functions used in sap script? What are the parameters used in each function?
What is the significance of the memory table ‘screen’?
How do you use tab sets in layout sets?
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul
What are null values?
What is the use of enqueue function module? : sap abap data dictionary