SAP ABAP Data Element DMC_FETCH_PACKAGE_SIZE (Package Size for FETCH statement)

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_FETCH_PACKAGE_SIZE
Short Description	Package Size for FETCH statement

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	7
Decimal Places	0
Output Length	7
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	pack size
Medium	18	fetch package size
Long	20	fetch package size
Heading	20	fetch package size

Documentation

Definition

The generated function modules for access plan calculation and data selection use a cursor to select the data of the only or top-level table of a migration object (if reading type 7 is used, for the select of the child table). By default, the FETCH NEXT CURSOR statement will use a package size of 1000 records. In some cases, if a "flat" conversion object is selected, or if reading type 7 is used, it might be more efficient to select a higher number of records in each FETCH statement. On the other hand, if the FOR ALL ENTRIES approach should be used to select all child table records for a certain set of header table records, it might be necessary to select a smaller number of header table records, to make sure that the maximum portion size will not be exceeded. (For details on the FOR ALL ENTRIES option, see DMC_FOR_ALL_ENTRIES).

This parameter allows assigning, for a specific migration object, the optimal number of records to be selected with one FETCH NEXT CURSOR statement.

Use

Dependencies

Example

History

Last changed by/on	SAP	20141029
SAP Release Created in