SAP ABAP Data Element DMC_MAX_IN_BLOCK (Value for MAX_IN_BLOCKING_FACTOR DB Hint)

Hierarchy

☛ DMIS (Software Component) DMIS 2011_1
   ⤷ CA-EUR (Application Component) European Monetary Union: Euro
     ⤷ CNV_DMCM (Package) Data Mapping and Conversion: Maintenance

Basic Data

Data Element	DMC_MAX_IN_BLOCK
Short Description	Value for MAX_IN_BLOCKING_FACTOR DB Hint

Data Type

Category of Dictionary Type		Direct Type Entry
Type of Object Referenced		No Information
Domain / Name of Reference Type
Data Type	NUMC	Character string with only digits
Length	3
Decimal Places	0
Output Length	3
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	MAX_IN_BL
Medium	15	MAX_IN_BLOCK
Long	22	MAX_IN_BLOCKING_FACTOR
Heading	22	MAX_IN_BLOCKING_FACTOR

Documentation

Definition

If the generated function modules for access plan calculation or data selection make use of the option to read all child table records for a set of header table records with the FOR ALL ENTRIES selection, it might improve the performance to add a DB optimizer hint for the MAX_INT_BLOCKING_FACTOR. By default, the value is only 5, which means that only 5 child table records are selected in one DB operation. It is sometimes advisable to increase this number.

For details on the MAX_IN_BLOCKING_FACTOR DB hint, see SAP note 881083 (what is described there for Oracle also applies to other DB systems).

For details on the FOR ALL ENTRIES selection option, see DMC_FOR_ALL_ENTRIES

Use

Dependencies

Example

History

Last changed by/on	SAP	20141029
SAP Release Created in