SAP ABAP IMG Activity BW_MPP (Optimize SID generation for MPP databases)
Hierarchy
SAP_BW (Software Component) SAP Business Warehouse
   BW-WHM (Application Component) Warehouse Management
     RSIMG (Package) IMG Texts and Release Notes
IMG Activity
ID BW_MPP Optimize SID generation for MPP databases  
Transaction Code S_BRA_16000023   (empty) 
Created on 20100326    
Customizing Attributes BW_MPP   Optimize SID generation for MPP databases 
Customizing Activity BW_MPP   Optimize SID generation for MPP databases 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name BW_MPP    

Use

You use this activity to define a threshold value for the number of records that triggers mass access.

If more values are simultaneously selected than the threshhold value allows, mass access is executed. If the threshold value is not exceeded, the records are selected individually. You should follow SAP's recommendations.

SID tables are usually buffered on a record-by-record basis. If a large number of values needs to be read in the SID table, then single record access (select single) is considerably faster than mass access (select for all entries), provided that all the values to be read are contained in the single record buffer. If the values are not contained in the buffer, mass access is considerably faster than single record access. The relative access times depend very much on the database used.

Requirements

Standard settings

Activities

Example

Business Attributes
ASAP Roadmap ID 262   Technical and Graphical Settings 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG BW_MPP 0 ARS0000022 Warehouse Management 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
RSADMINCV33 V - View RSCUSTV33  
History
Last changed by/on SAP  20100326 
SAP Release Created in 730