08-31-2008 1:02 PM
Hi Abappers,
I want to create Database view using tables mara,stko,stpo,
Regards,
simba.
08-31-2008 1:57 PM
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
08-31-2008 1:57 PM
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
08-31-2008 3:20 PM
HI Simba,
Check this link it will help u out
http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm
08-31-2008 6:01 PM
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
09-02-2008 12:13 PM