Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 12 Answers
- 18116 Views
- Satyam, TCS, Wipro, I also Faced
- E-Mail Answers
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
What is the role of ‘refresh’ in internal table?
In order to upload purchase order details, how you handle multiple values for a single field?
Did you use buffering?
What are hashed tables?
What does an exec sql statement do in abap? What is the disadvantage of using it?
How do you send files to the legacy systems from sap and vice versa? How does one know that the legacy files have come on to the sap server you are working on? : abap bdc
What is a type group?
Difference between domain and data element? What are aggregate object?
What is repository info. Systems? : abap data dictionary
What happens if a function module runs in an update task? : abap modularization
What are the prerequisites for creating foreign key relationship?
How to create a link between modified form and modified print program?
Can a domain, assigned to a data element be changed?
HOW TO TRANSFER VENDOR MASTER DATA FROM LEGACY SYSTEM TO SAP SYSTEM THRU LSMW (IN LSMW, USING DIRECT INPUT PROGRAM:RFBIKR00)
What is design pattern? Provide example .Why are we using it?
