ALL >> Technology,-Gadget-and-Science >> View Article
Online Training On Sap Abap
SAP ABAP (Advanced Business Application Programming) is one of the most sought-after modules of SAP. In accordance with its manifold returns the trend for training of SAP ABAP is constantly on a sharp upsurge. In the first phase of the Sap Abap Online Training the core emphasis is laid upon the general outline of the SAP. To get more specific, the learner is precisely told about the multifarious modules of the SAP (just a basic know-how, no detailed analysis).
When you create a database table in the ABAP Dictionary, you must specify the combination of fields that enable an entry within the table to be clearly identified. The key fields must be specified at the top of the table field list, and define them as key fields. A minimum of 1 key field and a maximum of 16 key fields can be defined.
When the table is activated, an index formed from all key fields is created on the database (with Oracle, Informix, DB2), in addition to the table itself. This index is called the primary index The primary index is unique by definition.
In addition ...
... to the primary index you can define one or more secondary indexes for a table in the ABAP Dictionary, and create them on the database. Secondary indexes can be unique or non-unique.
In the example above, two unique indexes (Index A and Index B) are shown for Table X. Index A and Index B point to table records. Index records and table records are organized in data blocks.
If you dispatch an SQL statement from an ABAP program to the database, the program searches for the data records requested either in the database table itself (full table scan) or by using an index ( index unique scan or index range scan). If all fields requested are found in the index using an index scan, the table records do not need to be accessed.
A data block shows the level of detail in which data is written to the hard disk or read from the hard disk. Data blocks can contain several data records. Conversely, a data record can extend over several data blocks.
DATA blocks can be index blocks or table blocks. The database organizes the index blocks in the form of a multi-level B tree. There is a single index block at root level, which contains pointers to the index blocks at branch level. The branch blocks contain either some of the index fields and pointers to index blocks at leaf level, or all index fields and a pointer to the table records organized in table blocks. The index blocks at leaf level contain all index fields and pointers to the table records from the table blocks.
The pointer that identifies one or more table records has a specific name. It is called, for example, ROWID for Oracle databases. The ROWID consists of the number of the database file, the number of the table block, and the row number within the table block.
The index records are stored in the index tree and sorted according to index field. This enables accelerated access using the index the table records in the table blocks are not sorted.
An index should not consist of too many fields. Having a few very selective fields increases the chance of reusability, and reduces the chance of the database optimizer selecting an unsuitable access path.
In the concluding stages database indexes are explained about a set of topics that are classified under “ABAP” Programming Language -Advanced II. Here is the time when learners are given considerably comprehensive exposure to other SAP modules like MM, FI, SD and others.
In the concluding stages of the Sap Abap Training online learners are explained about a set of topics that are classified under "ABAP Programming Language -Advanced II. Here is the time when learners are given considerably comprehensive exposure to the ABAP in general. Besides this, it also includes various SAP tables; and a bit of exposure to other SAP modules like MM, FI, SD and others. Furthermore learners commendably get used to with the core transactions in FI, and billing stream with transactions.
Add Comment
Technology, Gadget and Science Articles
1. Why Silent Pods Are Essential For Modern Open-plan Offices?Author: Silent Pod
2. Innovative Design, Unmatched Quiet: Explore Our New Pods
Author: Silent Pod
3. How Silent Pod Is Revolutionizing Workspaces In The Uae?
Author: Silent Pod
4. Discovering The Advantages Of Various Types Of Silent Pods
Author: Silent Pod
5. Drone Spraying: A Game Changer For Hard-to-reach Vineyards
Author: Alex Wilkinson
6. Comparative Analysis Of Glass Cloth Electrical Tape And Fiberglass Tape For Transformer Insulation
Author: jarod
7. Which Certification Is Best For A Java Full Stack Developer?
Author: Shankar Singh
8. Streamlining Operations With Heavy Equipment Tracking Solutions
Author: Asset Tracker
9. Why Choose Laravel : Explore Its Features & Benefits For Building Web Applications
Author: Rob Stephen
10. Why Your Business Needs An Inventory Management Software Solution
Author: nagaraj
11. What Thickness And Width Options Are Available For Polyimide Tape?
Author: jarod
12. Ứng Dụng Máy In Số Thứ Tự Trong Các điểm Giao Dịch Công
Author: xephangsmart
13. Navigating Challenges And Seizing Opportunities In Tech Development
Author: Yash Tamakuwala
14. Business Process Outsourcing Market Insights: The Impact Of Digital Marketing Strategies
Author: Grand View Research
15. Why Your Business Needs E-invoicing Software For Hassle-free Billing
Author: nagaraj