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
- 14954 Views
- Satyam, TCS, Wipro, I also Faced
- E-Mail Answers
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 |
What are the types of subroutines?
How did you test the form u developed? How did you taken print?
i have a requirement.there are 2 fields and one check box on my selection screen.initially first field sud be mandatory, when we click on check box the first field which was mandatory sud now be optional and second field sud be mandatory?please provide me the solution asap.Thank you
What Is Roll Area In ABAP?
What is logical data base
What are the two ways of producing a list within a transaction?
The loop-endloop on extract datasets can be used without any kind of errors. State true or false. : abap modularization
What are the Text – elements inscripts. Where you declare this. What is the use to this.
Table maintainence -- Transaction Code?
How do you display a data in a detail list?
If your project is support project ? when is your implementation has completed ?
why we have to define function group?
-
SAP Basis (1262) - SAP ABAP (3939)
- SAPScript (236)
- SAP SD (Sales & Distribution) (2716)
- SAP MM (Material Management) (911)
- SAP QM (Quality Management) (99)
- SAP PP (Production Planning) (523)
- SAP PM (Plant Maintenance) (252)
- SAP PS (Project Systems) (138)
- SAP FI-CO (Financial Accounting & Controlling) (2766)
- SAP HR (Human Resource Management) (1180)
- SAP CRM (Customer Relationship Management) (432)
- SAP SRM (Supplier Relationship Management) (132)
- SAP APO (Advanced Planner Optimizer) (92)
- SAP BW (Business Warehouse) (896)
- SAP Business Workflow (72)
- SAP Security (597)
- SAP Interfaces (74)
- SAP Netweaver (282)
- SAP ALE IDocs (163)
- SAP Business One (110)
- SAP BO BOBJ (Business Objects) (388)
- SAP CPS (Central Process Scheduling) (14)
- SAP GTS (Global Trade Services) (21)
- SAP Hybris (132)
- SAP HANA (700)
- SAP PI (Process Integration) (113)
- SAP PO (Process Orchestration) (25)
- SAP BI (Business Intelligence) (174)
- SAP BPC (Business Planning and Consolidation) (38)
- SAP BODS (Business Objects Data Services) (49)
- SAP BODI (Business Objects Data Integrator) (26)
- SAP Ariba (9)
- SAP Fiori (45)
- SAP EWM (Extended Warehouse Management) (58)
- Sap R/3 (150)
- SAP FSCM Financial Supply Chain Management (101)
- SAP WM (Warehouse Management) (31)
- SAP GRC (Governance Risk and Compliance) (64)
- SAP MDM (Master Data Management) (0)
- SAP MRS (Multi Resource Scheduling) (0)
- SAP ESS MSS (Employee Manager Self Service) (13)
- SAP CS (Customer Service) (0)
- SAP TRM (Treasury and Risk Management) (0)
- SAP Web Dynpro ABAP (198)
- SAP IBP (Integrated Business Planning) (0)
- SAP OO-ABAP (Object Oriented ABAP) (70)
- SAP S/4 HANA Finance (Simple Finance) (143)
- SAP FS-CD (Collections and Disbursements) (0)
- SAP PLM (Product Lifecycle Management) (0)
- SAP SuccessFactors (33)
- SAP Vistex (0)
- SAP ISR (IS Retail) (28)
- SAP IdM (Identity Management) (0)
- SAP IM (Investment Management) (0)
- SAP UI5 (59)
- SAP SCM (Supply Chain Management) (51)
- SAP XI (Exchange Infrastructure) (49)
- SAP Cloud Platform (34)
- SAP Testing (89)
- SAP SolMan (Solution Manager) (63)
- SAP MaxDB (116)
- SAP GUI (15)
- SAP AllOther (329)
