I want to create Database view using tables mara,stko,stpo,
Follow the Link to crete a Database View
Now the 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 .