Ads

Types of Internal Table in ABAP

-

Types of Internal Table in ABAP

Internal tables are used to access a data in a fixed structure and storing it in working memory in ABAP. The data is stored line by line in memory, and each line(record) has the same structure.

Standard Internal Tables


Standard Internal Tables are default internal tables.

We can use either key or index operation to read an entry .

we can use either linear search or binary search to search for an entry, .

We can Apply sort operation.

If you are going to address the individual table entries using the index. Index access is the quickest possible access ,this is the best suitable table.

We can use insert and append to add records.

It have an internal linear index. 

The system can access records either by using the table index or the key. 

The response time for key access is proportional to the number of entries in the table. 

The key of a standard table is always non-unique. 

You cannot specify a unique key. 

This means that standard tables can always be filled very quickly, since the system does not have to check whether there are already existing entries.

Sorted Internal Tables


These are a special type of internal tables, where data is automatically sorted as you insert the record.

Sorted tables are always saved sorted by the key. 

They also have an internal index. 
The system can access records either by using the table index or the key. 

The response time for key access is logarithmically proportional to the number of table entries, since the system uses a binary search. 

The key of a sorted table can be either unique or non-unique. 

When you define the table, you must specify whether the key is to be UNIQUE or NON-UNIQUE. Standard tables and sorted tables are known generically as index tables.

We use either key or index operation to read a record .

This is the most suitable type if you want a table which is sorted as you fill it. You process sorted tables using the INSERT statement.

You use binary search as data is already sorted for searching an entry.

You can't sort as data is already sorted.

You can apply insert, not append.

Hashed Internal Tables


Hashed tables have no linear index. 

You can only access a hashed table using its key. 

The response time is independent of the number of table entries, and is constant, since the system access the table entries using a hash algorithm. 

The key of a hashed table must be unique. When you define the table, you must specify the key as UNIQUE.

These are used with logical databases i:e with all fields and all records.

Index operation is not possible, you only use key operation.

You use hashed algorithm to search for any entry.

Which are mostly used in ABAP with BI projects 

This is the most suitable  when you use operation is key access. 

You cannot access a hashed table using its index. 

The response time for key access remains constant, regardless of the number of table entries.




Types of Internal Table in ABAP,Internal Table Types,Internal Table,Table,SAP ABAP,ABAP.

Comments

Post a Comment

Popular posts from this blog

BADI Interview Questions in SAP ABAP

-
BADI Interview Questions in SAP ABAP A BAdI is an object-oriented enhancement option, which makes it the most sophisticated enhancement type. The main characteristic of a BAdI is that it provides a mechanism to change the functionality of a well-defined business function without making changes to the delivered source code. Future upgrades of the original business function can be applied without losing the customer-specific enhancements or the need to merge the changes.  If you want to become a professional and technical blogger practically, read these real-world practical SAP ABAP books . These books will help you to become a more flexible coding developer in future SAP technology. What is a BADI in SAP? BADI (Business Add-In) is a new SAP Object Oriented enhancement technique that is used to add our own business functionality to the existing SAP standard functionality.  BADI follows the Object-Oriented approach to make them reusable. A BADI can be used any number of times
Read more

Sample SAP ABAP Programming Examples for Practice

-
Sample SAP ABAP Programming Examples for Practice Are you a beginner at ABAP Language, you're looking for example programs for practice. Here I collected some sample programs from various objects in ABAP that are useful for beginners to improve their Technical skills. To familiar with coding and ABAP applications, you must be practice all applications. As per my experience, practice makes you perfect, as a technical consultant, should be ready to develop any object based on the need of the client, then only, we will get appreciation from the client and from our team side and it helps us to develop complex objects in SAP. ABAP Syntax ABAP Statements ABAP Program Types SAP ABAP Workbench Tools SAP Modules SAP Transaction Codes SAP Tables SAP ABAP Hello world Program Example ABAP- Simple ALV report Example ABAP- Interactive ALV Report Example ABAP- BDC Call Transaction Method Programming ABAP- BDC Session Method Programming Example ABAP- Smartforms
Read more

Module Pool Programming Interview Questions and Answers in SAP ABAP

-
Module Pool Programming(Dialog Programming)  Interview Questions and Answers in SAP ABAP As an ABAP Consultant, you should be strong in Module pool programming techniques as well as when you face the real-time or fresher interview, Questions, and answers to test your talent to select for the interview. For that purpose, I am sharing my interview experiences in which I faced the most of the times on these topics that are at exit command, events difference between set screen and call screen difference between call screen and set screen in module pool,chain-end chain in module pool. What is the transaction code for the screen painter? SE51. What is the transaction code for Menu painter? SE41. What is the transaction code for the screen painter? SE93. What are the main components of dialog programs? Screens Module pools Subroutines Menus Transactions What is Screen flow Logic? The screen flow logic is like an ABAP program in that it serves as a
Read more

Step by Step tutorial on BDC Session Method Program in SAP ABAP

-
Image
Step by Step tutorial on BDC Session Method Program in SAP ABAP BDC Session Method is used to upload data from Non-SAP to SAP System. Using Session method, we can transfer data through more than one Transaction, Unlike BDC Call Transaction Method Program . We are Processing Batch input Session From SM35 Transaction Code. Session method. 1) synchronous processing. 2) can transfer a large amount of data. 3) processing is slower. 4) error log is created 5) data is not updated until the session is processed. Call transaction Method. 1) asynchronous processing 2) can transfer a small amount of data 3) processing is faster. 4) errors need to be handled explicitly 5) data is updated automatically Go to SHDB and Press Enter Click on New Recording Button and Give the zrecord1 name and enter transaction code MM01 and click on the Start recording button. The system goes to the Create material screen, there give the industry sector and material type and selects ba
Read more

SAP ABAP Interview Questions and Answers for 10 Years Experienced

-
SAP ABAP Interview Questions and Answers for 10 Years Experienced This post will helpful for SAP ABAP experienced candidates who may have 3,4 5, 6,7, and 10 years of experience, all of them can be follow this interview pattern for their successful interview.  SAP Data Dictionary Realtime Interview Questions SAP BDC Realtime Interview Questions SAP ALV Reports  Real-time Interview Questions Module Pool Interview Questions SAP Smartforms Realtime Interview Questions SAP BADI Realtime Interview Questions SAP BAPI Realtime Interview Questions SAP  IDOC Realtime Interview Questions ABAP Check and Value Table Questions SAP SD MM FICO Flow Interview Questions SAP OOPs Realtime Interview Questions SAP OOPs Part One  Real-time Interview Questions SAP OOPs Part two Real time Interview Questions SAP OOPs Part three Realtime Interview Questions SAP OOPs Part four Realtime Interview Questions ABAP  Realtime Interview Questio
Read more