Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Database view

Former Member
0 Kudos

Hi Abappers,

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

Regards,

simba.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

4 REPLIES 4

Former Member
0 Kudos

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

Former Member

uwe_schieferstein
Active Contributor
0 Kudos

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

Former Member
0 Kudos

This message was moderated.