What is an index ? Types of index and there uses ?
Answers were Sorted based on User's Feedback
Answer / suman
2 types of indexes
1. Basic index - default it will exist for tables.
2. Secondary index - we need to create on requirement.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / aditya sharma
There are two types of indexes:
1.Primary Index
2.Secondary Index.
While creating a table or in an existing standard table the
key fields are the default primary indexes.
If we require to fetch records from non key fields we need
to provide Secondary Indexes.i.e., we need to explicitly
make non key fields as indexes.
This can be done by clicking on Index and adding the fields
for secondary index.
For Some major standard table SAP has provided secondary
Indexes like
Eg: BSEG table. As BSEG is a cluster table data retreival
using non key fields like Customer/vendor/GL account data
makes the response slower.So SAP has provided standard indexes.
Secondary index tables:
For Customer BSID and BSAD.
For Vendor BSIK and BSAK
For Material BSIM
For GL AccountBSIS
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / yarru sreenivasa rao
grouping of fields
index contain idexfields and pointer to data record in that
table
unique index
nonunique index
speed up the data retrieval due index fields r sorted
| Is This Answer Correct ? | 4 Yes | 0 No |
why scripts are client dependent and smart forms are client independent.?
What are the developments you have done with data dictionary?
What is repository info. Systems? : abap data dictionary
what is the Tcode BD87?
5 Answers Cibernetix Business Systems, Intel, SAP Labs,
How is the command suppress-dialog useful?
what is the difference between bdc and lsmw?
What are the different control break statements available inside a loop?
"I want to access one record, I don't know any key figures.How to do that"
what are views? And how many types of views are there?
looking for sap abap training with real time project, call @ 9972123004
differnce between screen exit, field exit and function exit
what is the difference bet ween the appened and insert statment.plz tell me the answer.
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 APO PPDS (50)
SAP AllOther (329)