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:

Detailed Explanation of this Question

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]

Comments

Add comment

Your email address will not be published. Required fields are marked *

 

Your personal information will be exclusively used for processing current comment only. Personal data protection policy

  • Download and Run Your SAP System Within Minutes After Download!
    Download-and-Run Your Own Local SAP System Within Minutes After Download
  • Newest Blog Posts
  • Most Popular Posts
  • Categories
  • Tags