Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Database view

Hi Abappers,

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



Former Member
Former Member replied


Follow the Link to crete a Database View

[database view|]

Now the Projection view

[Projection View|]

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 .



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question