difference between primary index and secondary index.when we
use secondary index in reports?
Answers were Sorted based on User's Feedback
Answer / sivaramakrishna
when we want to get the details based on a field in select
statement we should use always primary key fields to
improve the performence. but in any case needed to get
detais based on non primary key fields then we go for
secondary index . ie based on which non primary key fields
we need to fetch the data using select st for those fields
we create secondary index in sell.
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / abaprajaram
For Perfomance perspective to use two keys to read the data
in to the internal tables
| Is This Answer Correct ? | 1 Yes | 3 No |
1.How to pass the variables to form? 2. How did you test the form you developed? 3.what are the outpout types and tcodes? 4.what mean by performance analysis?
i have to fetch the data based on non primary key field from a pooled or clustered table, but for pooled and clustered tables we can't create secondary index then to achieve the performance what to do?
What will you code in start-of-selection & end-of-selecton & why?
Differentiate between report and dialog program
How do you read the data from clusters
What is the mandatory event in LDBs.
I want to disable a field in selection screen so that it does not appear while displaying.How can i do that?wat wud be the code?
How do you set up background jobs in sap? What are the steps? What are the event driven batch jobs?
1.How can u set more than one selection screen for one report? 2.Where u can provide initial values other than in INITIALIZATION event?
How does the system handle roll areas for external program components?
what is difference between include structure and append structure?
What are the things you did in ALV grid display?
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)