SAP Database

EXTRACT

Basic form
EXTRACT fg.
Effect
Writes all fields of the field group fg (see FIELD-GROUPS) as one record to a sequential dataset (paging). If a field group HEADER has been defined, its fields prefix each record to form a sort key. You can sort this dataset with SORT and process it with LOOP … ENDLOOP. After this, EXTRACT cannot be execuuted again.

Note
As soon as the first dataset for a field group has been extracted with EXTRACT , the field group cannot be expanded using INSERT . The field group HEADER , in particular, cannot be expanded after the first EXTRACT (regardless of field group).
Note
Runtime errors
* EXTRACT_AFTER_SORT/LOOP : EXTRACT after SORT or LOOP .
* EXTRACT_FIELD_TOO_LARGE : Occupied length of a single field is too long.
* EXTRACT_HEADER_NOT_UNIQUE : Field group HEADER was modified after records had been extracted with EXTRACT .
* EXTRACT_TOO_LARGE : Total data length of a record to be extracted (including HEADER fields) is too long.