SAP ABAP Data Element KALC_DB_SELECT (Database Selection Type for Periodic Allocations)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ KALC (Package) Cost Accounting allocations RK-S
BBPCRM (Software Component) BBPCRM⤷
CRM (Application Component) Customer Relationship Management⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages⤷
KALC (Package) Cost Accounting allocations RK-S
Basic Data
| Data Element | KALC_DB_SELECT |
| Short Description | Database Selection Type for Periodic Allocations |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | KALC_DB_SELECT | |
| Data Type | NUMC | Character string with only digits |
| 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 | Selec. typ |
| Medium | 15 | Selection type |
| Long | 21 | Selection type |
| Heading | 0 |
Documentation
Definition
Indicator to control database access.
As the optimal database access strategy is very dependent on the definition of a cycle, you can use this indicator to specify the type of database access. The settings selected are only valid for the current execution of the cycle, but can be saved in a variant. You can save your setting permanently using the "Save" icon.
The following methods of database selection are available:
- Cycle-Based Selection (Default-Setting, access strategy till now): for each corresponding field in the cycle (cost center, cost element, and so on), the highest and lowest value in the whole cycle is determined and used for the database selection. Advantage: There is just one database access. Disadvantage: There may be too many objects selected, which later have to be eliminated; The segment number should not be greater than 50.
- Optimized Cycle-Based Selection (only CO-OM): Database selection occurs only for the CO objects defined in the cycle. Advantage: Smaller number of hits; Disadvantage: Multiple database access. The segment number should not be greater than 50.
- Segment-Based Selection: For each corresponding field in the segment, the system determines the highest and lowest value in the segment. Advantage: Improved performance, as database selection with segment number is correlated almost in linear fashion and no longer exponentially: Disadvantage: Occasionally, the number of hits may be unnecessarily large.
History
| Last changed by/on | SAP | 19980428 |
| SAP Release Created in |
