Give the syntax of Inner,outer Join?"
Answer Posted / navneet
inner join :
select P~<fieldname> d~<fieldname> into corresponding
fields of table <internaltable> from ( <table> as p inner
join <table> as d on <join condition> and <cond>.
outer join:
select P~<fieldname> d~<fieldname> into corresponding
fields of table <internaltable> from ( <table> as p left
outer join <table> as d on <join condition> and <cond>.
| Is This Answer Correct ? | 29 Yes | 3 No |
Post New Answer View All Answers
What are spa/gpa parameters (sap memory)?
What is the maximum number of match code id's that can be defined for one match code object ?
What is a logical database?
What is function group?
Explain how to create any functions? How to go about it?
What is lock objects? : sap abap data dictionary
Explain the advantages of logical databases?
What are the differences between se01, se09 and se10?
there are 2 selection screens. material num in screen 200 and plant in screen 300. so how can you write in INITIALISATION event?
What are the different types of data dictionary objects? : abap data dictionary
1/ How do u apprach if error occur in sending idocs ? 2/ where u assigned process code ?
How to create report in SD open sales order which covers all Organization, delivery status, shipping details and partner function details. plz mention the detail coding Tahnks, Rahul
How do you validate the selection criteria of a report? And how do you display initialvalues in a selection screen?
What is the different type of projects? : sap abap hr
What is locking? : abap data dictionary