1 / 6

SAP ABAP Database Table

SAP ABAP database tables are collection of fields, in which fields are made up of columns and rows. In SAP more than 8000 tables are defined. When table is created, its columns are named and data type is supplied for each columns. There can be only one data value in each column of each row in a table.<br><br>https://www.ducatindia.com/Best-sap-erp-training/

ducathub
Download Presentation

SAP ABAP Database Table

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. WELCOME TO DUCAT INDIA Language | Industrial Training | Digital Marketing | Web Technology | Testing+ | Database |  Networking | Mobile Application | ERP | Graphic | Big Data | Cloud Computing SAP ABAP Database Tables 7070905090 info@ducatindia.com

  2. SAP ABAP Database Tables SAP ABAP database tables are collection of fields, in which fields are made up of columns and rows. In SAP more than 8000 tables are defined. When table is created, its columns are named and data type is supplied for each columns. There can be only one data value in each column of each row in a table. To define tables in ABAP dictionary, you need to define fields first, so to define a field, you need to specify data type, length and description. Field = Data Element + Domain Domain = Data type + Length Data Element = Description

  3. Types of ABAP database tables • Transparent tables • Pool Tables • Cluster tables Transparent tables Transparent tables are used to stare the application’s master data and transaction data.It is a one to one relationship with the tables in database (SAP database, SQL, Oracle, etc) i.e. the name of table, field names and the number of fields are similar in both DDIC and database (DB). In real time, an organization mostly works with transparent tables.

  4. Pool Tables Pools tables are one to many relationship with the database tables. The system follows binary search while accessing the pool tables. These pool tables are used to store the internal controlling information. Cluster tables Cluster tables are many to on relationship with the database tables. The system follows linear search while accessing the cluster tables.

  5. What is binary search and linear search? Binary search : – The system divides total records into two equal parts, then the system starts searching in second half, if the record in not found in second half the system starts searching in first half. Linear search : – The system starts searching the record from 1st record until the required record in found. Once the system finds the record, it stops the search.

  6. THANK YOU SAP ABAP Database Tables 7070905090 info@ducatindia.com

More Related