SAP ABAP Data Element NEUA_DCIDX (Flag: "Delete/Set Up Secondary Indices" for LIS Stat. Setup)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
Data Element NEUA_DCIDX
Short Description Flag: "Delete/Set Up Secondary Indices" for LIS Stat. Setup  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type FLAG    
Data Type CHAR   Character String 
Length 1    
Decimal Places 0    
Output Length 1    
Value Table      
Further Characteristics
Search Help: Name    
Search Help: Parameters    
Parameter ID   
Default Component name    
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short 10 Flg_Idx 
Medium 15 Flag_Index 
Long 20 Flag_Index LIS setup 
Heading 24 Flag_Index LIS setup 
Documentation

Use

If you set this indicator, any secondary indices of all information structure(s) to be set up that may exist are deleted before the setup of statistical data and are created again after the setup.

This procedure improves performance levels for the statistical setup.

Note

Performance is only improved if the data volume to be processed is at least 10 - 15% of the total dataset of the information structure(s) in question.

If, for instance, the information structure contains 100,000 data records and 30,000 new records are added by means of the statistical setup, it makes sense to use this option.

On the other hand, there is no point in using this option if only 5,000 new records are added by means of the statistical setup, as performance is not significantly influenced.

Additional Information

The 'primary index' is also generated automatically for the key fields of each information structure. In addition, a secondary index is automatically generated for "customer", "vendor", and "material", when these fields are contained in the information structure.

In general, you have the option of creating your own secondary indices for all characteristics and for all selection key figures (CHARACTER-Kennzahlen) to suit your own reporting requirements.

History
Last changed by/on SAP  20130529 
SAP Release Created in