Skip to Content
avatar image
Former Member

Create database view with outer join

Hello Experts,

I have created a database view but couldnu2019t specify outer join conditionu2026 How to create view with using outer join? Please suggest meu2026.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jan 07, 2010 at 07:18 AM

    Hi Vickee,

    i think we can only create inner join condition in Database view

    Regards,

    Kumar M.

    Edited by: Kumar M on Jan 7, 2010 8:39 AM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Sir,

      You can only create databse view with inner join. But if you want to create a view with outer join you can create maintainence view for the same. Moreover, it is not recommended to use outer join in the view due to data inconsistency might raise in the Database.

      Regards,

      Kapil.

  • avatar image
    Former Member
    Jan 08, 2010 at 05:22 AM

    Hi,

    A Database View always implements an Inner Join. If it is made from only a single table, then you can use it for maintainance also. But if you use a Maintainance View, then it implements an Outer Join.

    Have a look at the following link

    http://help.sap.com/saphelp_nw04s/helpdata/en/cf/21ecdf446011d189700000e8322d00/frameset.htm

    Hoe this will help.

    Thanks,

    Samantak.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2010 at 08:39 AM

    Hello,

    Please go through the link below, it describes you about using joins in view.

    http://help.sap.com/erp2005_ehp_04/helpdata/EN/cf/21ed2d446011d189700000e8322d00/frameset.htm

    Regards,

    Varun.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 23, 2010 at 03:48 PM

    Hi,

    Database view always uses inner join.

    so if u want to use outer join then go for HELP VIEW.

    Rgds/Abhi

    Add comment
    10|10000 characters needed characters exceeded