- 浏览: 169079 次
- 性别:
- 来自: 成都
文章分类
source:http://www.sap-img.com/abap/what-is-the-different-types-and-usage-of-views.htm
The followings are different types of views:
- Database View (SE11)
Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.
In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.
- Help View ( SE54)
Help views are used to output additional information when the online help system is called.
When the F4 button is pressed for a screen field, a check is first made on whether a matchcode is defined for this field. If this is not the case, the help view is displayed in which the check table of the field is the primary table. Thus, for each table no more than one help view can be created, that is, a table can only be primary table in at most one help view.
- Projection View
Projection views are used to suppress or mask certain fields in a table (projection), thus minimizing the number of interfaces. This means that only the data that is actually required is exchanged when the database is accessed.
A projection view can draw upon only one table. Selection conditions cannot be specified for projection views.
- Maintenance View ( SE54 )
Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.
The followings are different types of views:
- Database View (SE11)
Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.
In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.
- Help View ( SE54)
Help views are used to output additional information when the online help system is called.
When the F4 button is pressed for a screen field, a check is first made on whether a matchcode is defined for this field. If this is not the case, the help view is displayed in which the check table of the field is the primary table. Thus, for each table no more than one help view can be created, that is, a table can only be primary table in at most one help view.
- Projection View
Projection views are used to suppress or mask certain fields in a table (projection), thus minimizing the number of interfaces. This means that only the data that is actually required is exchanged when the database is accessed.
A projection view can draw upon only one table. Selection conditions cannot be specified for projection views.
- Maintenance View ( SE54 )
Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.
发表评论
-
DISABLE button(FCODE) from the GUI-Status
2014-08-04 15:54 5721. Goto-> Attributes->Pus ... -
Handy SAP function module to automate user events
2013-11-28 09:49 694*Begin-Auto triggers ENTER comm ... -
set Billing block to blank for Sals Order
2013-04-17 15:16 737FM: SD_WF_ORDER_DEL_BILLING_BLO ... -
set Billing block to blank for Sals Order
2013-04-17 15:16 710FM: SD_WF_ORDER_DEL_BILLING_BLO ... -
Unpermitted combination of business object BUS2032 and sales doc. category H
2013-01-25 14:20 4046Q: create New Sales Order using ... -
Function Module: get all users who have specific role
2013-01-25 14:16 585CALL FUNCTION 'RSRA_USERS_O ... -
Create a SELECT-OPTIONS in a module pool screen
2012-03-07 15:35 983source:http://abap-explorer.blo ... -
Converting OTF data from script to Spool Request
2012-03-06 17:25 0source:http://forums.sdn.sap.co ... -
Calculate the days, months and years between 2 dates.
2012-02-21 16:14 791FORM compute_2date_diff. DAT ... -
Retrieving Domain fixed values
2012-02-16 11:13 782source:http://www.saptechnical. ... -
If 1 equals 2, what’s the purpose?
2012-02-16 10:59 793source:http://sapport.blogspot. ... -
get status name for batch input session
2012-01-31 14:47 884Line 601 in program SAPMSBDC_CC ... -
create zip folder with cl_abap_zip
2011-12-05 18:11 1173REPORT ztest. DATA: gv_file ... -
MIRO
2011-11-29 10:39 2027from: http://help-sap.blogspot. ... -
Create Vendor or Customer_master Data
2011-11-23 16:22 2844To Create or Change Vendor_mast ... -
Pay attention to the following points when using append structures
2011-10-27 13:43 1271You cannot create append str ... -
Help Views
2011-10-20 10:46 689source:http://help.sap.com/saph ... -
Upload a Comma Delimited CSV file that contains commas in data
2011-09-23 17:22 2185source:http://wiki.sdn.sap.com/ ... -
What is the difference between SET SCREEN and CALL SCREEN ?
2011-09-19 21:50 697source:http://www.saptechies.co ... -
cl_gui_frontend_services=>file_open_dialog
2011-09-09 09:21 1373CALL METHOD cl_gui_frontend_ser ...
相关推荐
1. What is the IP address and TCP port number used by the client computer (source) that is transferring the file to gaia.cs.umass.edu? To answer this question, it’s probably easiest to select an ...
What is the State of the Art of Computer Vision-Assisted Cytology A Systematic Literature Review.pdf
1. What are the different types of Mathematics found in Quantitative Finance? 20 2. What is arbitrage? 25 3. What is put-call parity? 28 4. What is the central limit theorem and what are its ...
It focuses on the function and design of the various components necessary to process information digitally. We present computing systems as a series of layers, starting with low-level hardware and ...
(b) the name of the table, the names of the table's attributes, the data types of the table's attributes, the formats of the table's attributes, and the maximum number of rows that the table can have...
• What are the different types of specialised information system 1.1 Introduction In business, System Analysis and Design refers to the process of examining a business situation with the intent of...
What the Corpus is, and why s u m m a r y A summary of the compression test results d e t a i l s More detailed results, including some statistical analysis c o r p o r a Descriptions of the various ...
What is Nucleus C++ FILE? Nucleus C++ FILE is a C++ class interface into Nucleus FILE, a FAT16/FAT32 TM ... Then, a set of classes is used to create, edit, and manage devices, files, and subdirectories.
What is the capital of EgyptPPT教案学习.pptx
I am working on the conceptual architecture level and the real implementation is very complicated due to too many types of service from different content providers to different types of devices based...
This text starts with the history of painting and presents an integrated view of the arts, image science, and technology leading to today's HDR. It ends with a discussion of possibilities for the ...
what is the mindset of funcational programming - chinese edition
The book explains what types of laser to use for different purposes and how a laser can be modified to improve its performance in a given application. With a unique combination of clarity and ...
Architecture – how the different types of data and the different needs for data are fitted together, in a holistic and a cohesive way. It is one thing to recognize the different needs of perspectives...
It addresses the question of what is geometry, how are its various facets connected with each other, and how are geometry and group theory involved in physics. Besides Lie and Klein, the names of ...
You will learn about process tracing, and will explore the different types of Linux and UNIX viruses, and how you can make use of ELF Virus Technology to deal with them. The latter half of the book ...
What is the difference: between o(log n) and o(log n^2), where both log arithems have base 2 . a. o(log n^2) is bigger b. o(log n) is bigger c. no difference 3. For a class what would happen if we ...
Learn the different types of indexes available and when each is best applied. Recognize when queries aren’t using indexes as you intend. Manage your indexing for maximum performance. Confidently use...
It will then teach you about the types of patterns and the principles of software development, and explain the various aspects of distributed computing to keep your applications effective and ...