Difference between Maintanance view, Help view, Data Base
View and Projection View?
Answer / uma mb
Maintenance View: Created by joining two or more related (by
foreign key) tables. Join conditions are always using the
foreign key. Data can be changed, viewed and created using
such maintenance views. This type of view implements outer
join (where those records that do not have a corresponding
entry in some of the tables participating in the view also
show up) against database views that implement inner joins
(where the user sees only records which have a corresponding
entry in all tables participating in the view).
In tcode SE54, generate table view, and select view type as
'maintenance view'. More information is available in
manuals/books on how to create a one step and two step
maintenance view.
A database view can be READ only (formed by joining two or
more tables) and of course, if the appropriate option is
selected while creating it, it could write into the
underlying table also. If a database view involves more than
one table, then it can only be a READ ONLY view.
Projection View is formed out of exactly only one table and
it is a projection view (selective columns are displayed
from the table).
Help views also implement an outer join in the tables
participating in the view. Typically these are used when one
creates a F4 help in a field of a data entry screen. A
database view could also be linked to a search help but must
be avoided because database views use an inner join and
therefore some records may get hidden and may not therefore
really HELP.
| Is This Answer Correct ? | 58 Yes | 2 No |
What is the tcode to create indexes?
If a Function module is defined as RFC enabled why the parameters should be pass by value not by reference in sap abap
How we can Hide buttons on application toolbar.?
Explain the relationship between a functional area, user group, and query when developing queries using the sap query tool?
in bdc which method best comape to call transaction and session method?with example?
1 Answers vCentric Technologies,
How do you handle in Call Transaction?
What do is landscape in sap project, I think its related to no. Of servers used, pls correct me if I am wrong, or what it is? : sap abap hr
Did u inherit any standard sap programs? what are they? and for what purpose you have done it?
how to create lock object
In se11 -->Tech. settings --> Data class. If I save table as Mater data OR Transaction data, what effect will it has for 'Storage' in Database after activation. or In Database how it will store in both the cases.
Does sap handle multiple languages?
what is the role of ST05 in performance tuning?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)