|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Creating Database Views
pressing 'Table fields' button we get a popup likewise shown below. Choose the
table whose fields we want to include in our view. Another popup will be shown
select the fields we want to include and press 'Copy'.
repeat the above step to include below shown fields from table YZ14_ACCOUNTS.
In above steps do not
include 'MANDT' & 'BRANCH_ID' twice. While activating the view, it will lead
to an error.
shown, we have the below fields in our view.
can also formulate the selection criteria using 'Selection Conditions' tab
likewise coded below. Here we have
entered the condition for account type and status. All the data in the base
table satisfying the below condition will be selected based on other condition
save the view by pressing
present in standard tool bar. Then activate the view with
in application tool bar. Once view got activated, press
see the contents. Below screen gets displayed, do not enter any value, just
of the condition we have put on acc_typ & status fields, entries in the base
table got filtered. We can see that all the entries have account type as
'CURRENT' & status as 'X'.
Above steps demonstrate how to create
database view from multiple tables having foreign key relationships.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards