Skip to Content
avatar image
Former Member

Database view

Hi Abappers,

I want to create Database view using tables mara,stko,stpo,

Regards,

simba.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 31, 2008 at 12:57 PM

    Hi,

    Follow the Link to crete a Database View

    [database view|http://safari.oreilly.com/0201703661/ch11]

    Now the Projection view

    [Projection View|http://help.sap.com/saphelp_40b/helpdata/en/cf/21ed20446011d189700000e8322d00/content.htm]

    step1: Go to SE11 and select view ,after that mention namestarting with zXXXXXX and choose create button.

    step2: A screen will be displayed containing db view,projection view,maintenace view and helpview.inthat select db view or projection view according to ur choice,choose enter .

    step2: A DBview is created and displays a screen,give short text and choose table /join conditions and mention table name in the left column and choose relationships.all the relations regarding the table will be displayed.

    step3: Choose valid join condition and choose enter .

    step4: same procedure for projectionview also.

    DBview : implements innerjoin.we can only read DBviews with more than one table.

    Projection view: created on a single table and for restricting the existing table fields in the table.

    ex: let a table has 100 field ,we want only 10 fields in our view .in this case we can use this view selection .

    Regards,

    Harish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 31, 2008 at 02:20 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 31, 2008 at 05:01 PM

    Hello Simba

    The DB view EXPO_BOM_2_MAT (on ERP 6.0) fulfils your requirement partially by connecting MARA and STKO. Perhaps you use this DB view as template to create your own DB view which connects STPO as well.

    Regards

    Uwe

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 11:13 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded