How to Create a Left Join View in SE11? + Explain Inner Join and Left Outer Join with Example
Question
How to create database view in SE11 with LEFT OUTER JOIN?
Original Question:
Can I create Search Help / VIEW with all the existing ICPNs + information about ORDER_ID from Ordered Items database table.
Required output:
|
ICPN |
MODEL |
STORE |
PRICE |
CURRENCY |
ORDER ID |
|
978-0997082302 |
SEDAN |
BRATISLAVA |
45.000,00 |
EUR |
12 |
|
978-0997082303 |
SEDAN |
BRATISLAVA |
50.000,00 |
EUR |
12 |
|
978-0997082304 |
SEDAN |
PRAHA |
1.250.000,00 |
CZK |
|
|
978-0997082305 |
HATCHBACK |
PRAHA |
1.000.000,00 |
CZK |
|
|
978-0997082306 |
HATCHBACK |
BRATISLAVA |
50.000,00 |
EUR |
|
|
978-0997082307 |
HATCHBACK |
BRATISLAVA |
50.000,00 |
EUR |
|
|
978-0997082308 |
HYBRID/EL |
BRATISLAVA |
51.000,00 |
EUR |
|
|
978-0997082309 |
HYBRID/EL |
BRATISLAVA |
48.000,00 |
EUR |
|
|
978-0997082310 |
HYBRID/EL |
PRAHA |
1.150.000,00 |
CZK |
|
|
978-0997082311 |
HATCHBACK |
PRAHA |
60.000,00 |
CZK |
|
|
978-0997082312 |
SEDAN |
PRAHA |
1.100.000,00 |
CZK |
|
|
978-0997082313 |
SEDAN |
PRAHA |
1.200.000,00 |
CZK |
|
Database Tables:
If I create a view which connects CAR and ORDERI tables:
.. output contains only ICPNs which were already ordered.
I miss here other car records.
How is it possible to create?
[sociallocker id=1191] Find the Answer is in this video:
Timetable of this mentioning in the video:
- 0:46 – explaining the database structure
- 2:44 – recreating & demonstrating how to create Inner Join in SAP view
- 6:30 – finding out if left outer join is possible to be done in SE11
- 8:30 – explanation of difference between Inner vs. Outer Join
- 9:35 – demonstrating how to create Outer join in SE11
- 12:38 – how to search for answers to such questions in future?
[/sociallocker]
What is & How to Create Function Module in ABAP?
What is Function Module? Notice: In this article, I will be using…
How to Change SAP Easy Access Screen Picture?
How to change SAP Easy Access Screen Picture Step By Step as…
