Interested to Buy Any Domain ? << Click Here >> for more details...
how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 34620 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / anurag joshi
records can be fetched from 3 tables using a single select
statement using the CHAIN OPERATOR in select statement....
select : vbeln posnr matnr from VBAK into table i_abc1
where vbeln = s_vbeln,
vbeln1 posnr1 matnr1 from VBAk1 into table i_abc2
where posnr2 = s_posnr,
vbeln2 posnr2 matnr2 from VBAK2 into table i_abc3
where matnr2 = s_matnr2.
..the only difference which makes is the chain operator.
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Hi my dear friends,Please give the answers for the following link http://www.saptechnical.com/InterviewQ/interviewQ.htm
What is the structure of the bdc table? : abap bdc
How are the function code handles in flow logic?
List the events in abap/4 language?
What is the last entry in all bdc tables? : abap bdc
What does hide statement do?
Does sap handle multiple currencies?
What is netweaver???what is the relationship with ABAP?
Explain data dictionary in abap?
What are control tables? : abap data dictionary
When a function module is activated syntax checking is performed automatically. State yes or no. : abap modularization
in bdc session method. if u run the record in fore ground manually i have a 7 records but at the time of record processing first record produces the error how can u process records manually in fore ground please tell me any one knows?
after creating lock object if does n't access record by second user what should we do?
What is difference between float and packed data type?
What is payroll driver ? : abap hr
