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,

Regards,

simba.

Former Member
Former Member replied

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

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