topic Re: Database view in Application Development and Automation Discussions

Database view

Former Member — Sun, 31 Aug 2008 12:02:56 GMT

Hi Abappers,

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

Regards,

simba.

Re: Database view

Former Member — Sun, 31 Aug 2008 12:57:48 GMT

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

Re: Database view

Former Member — Sun, 31 Aug 2008 14:20:14 GMT

HI Simba,

Check this link it will help u out

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm

Re: Database view

uwe_schieferstein — Sun, 31 Aug 2008 17:01:42 GMT

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

Re: Database view

Former Member — Tue, 02 Sep 2008 11:13:29 GMT

This message was moderated.