rsdb/prefer_fix_blocking SAP Parameter attribute - Set if fix blocking for FOR ALL ENTRIES is desired

rsdb/prefer_fix_blocking is a SAP Parameter attribute which is used to control Set if fix blocking for FOR ALL ENTRIES is desired information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the attributes values .

rsdb/prefer_fix_blocking profile paramerter attributes

Parameter Name: rsdb/prefer_fix_blocking
Description: Set if fix blocking for FOR ALL ENTRIES is desired
Default Value: -1
Parameter Type ( See IF_PARAMETER_TYPES): Integer(INT)
Restriction Values:
Parameter Unit:
Parameter Group: Database
CSN Component: BC-DB-DBI
System-Wide parameter: Yes
Dynamic Parameter: Yes
Vector Parameter: No
Has Sub-Parameters: No
Check Function Exists: No

Parameter documentation

This parameter is only intended for internal use and must not be changed without explicit instruction from SAP. An internal table [itab] with entry data is always returned to an ABAP SELECT query with the addition FOR ALL ENTRIES. If the number of entries in [itab] cannot be divided by the maximum blocking factor (that is, max_(in_)blocking_factor or the technical blocking factor limit), then fewer entries (conditions) land on the last statement that was created for the processing of the FOR ALL ENTRIES statement. A new statement is produced. If the same FOR ALL ENTRIES statement is executed very often with a different number of entries in the input table [itab] then different statements up to the maximum blocking factor can be created. This can be avoided by setting this parameter. If this parameter is set to '1' then a maximum of two differently long statements are produced. This occurs by the last entry in the input table being repeated as if [itab] has implicitly been filled to the blocking factor ([itab] is not really modified).

See SAP Parameter Documentation for full SAP documentation for this profile parameter.