differences between the sorted ,standard, hashed tables.
Answers were Sorted based on User's Feedback
Answer / ektagalani
1.Standard Internal Tables: These tables have a linear index
and can be accessed using the index or the key. The response
time is in linear relationship with number of table entries.
These tables are useful when user wants to address
individual table entries using the index.
2.Sorted Internal Tables: These tables also have an index
and the key. But, the response time is in logarithmic
relationship with number of table entries, since it uses
binary search algorithm instead of linear search. These
tables are useful when user wants the table to be sorted
while additional entries have to be added.
3.Hashed Internal Tables: These tables have no index, but
have the key. The response time is constant irrespective of
number of table entries, since it uses a Hash algorithm.
These tables are useful when user wants to access the
entries with key only.
| Is This Answer Correct ? | 22 Yes | 4 No |
Answer / madhana mohan
INTERNAL TABLE TYPES, ATTRIBUTES IN VER. 4.X
============================================
A N Y T A B L E
| |
INDEXED NON INDEXED
TABLES TABLES - HASHED TABLES
| |
STANDARD SORTED
TABLES TABLE
SY-TABIX SY-TABIX SY-TABIX INOPERTIVE (NO
INDEXED
OPERATIONS)
L SEARCH B SEARCH HASHED ALGO FOR SEARCH
B SEARCH
IF SORTED
& SPECFIED
ACCESS TIME DEPENDS ACCESS TIME INDEPENDENT OF
ENTRIES
ON NO OF ENTRIES
S,D KEY D KEY DEFINED KEY
N UNIQUE N UNIQUE UNIQUE KEY
UNIQUE
RESORT NO RESORT RESORT
| Is This Answer Correct ? | 12 Yes | 3 No |
Where the payroll results are stored
What is the maximum number of structures that can be included in a table or structure
How to Raise a Particular Ticket in Realtime ?
Define external layer? : abap data dictionary
What are the advantages of logical databases?
which one is efficient in following command to copy data from one itab1to another itab2 . both itab table has same structure. 1. move itab1 to itab2 2.move corresponding field of itab1 to itab2 3. itab2[] = itab2[] 4.appends line of itab1 to itab2..
A window is missing while copying a sapscript from one client to another client. What should be done?
what is a binary search ? and how it is useful in a sorted internal table ?
What are plan versions used for? : sap abap hr
Does the table can have multiple foreign keys?
How to display or know if the value entered contains records or not?
How to maintain the table control in BDC?
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)