sapdev logo background
sapdev logo sapdev logo
Comments

ABAP EXTRACT Statement syntax, information and example SAP source code



Return to Statement index



EXTRACT

Short Reference

ABAP Syntax(Obsolete) EXTRACT [ header | field_group ].

What does it do? This statement appends the current content of the fields previously included in the field group header or field_group
using the statement INSERT to the extract dataset of the program. If there is no field group specified after EXTRACT , the field group header is added implicitly.
The extract dataset is created the first time EXTRACT is executed and the first row added. Once an EXTRACT statement is executed, no other fields can be included in the specified field group field_group using INSERT . If not, an unhandleable exception is raised by the next EXTRACT statement for the same field group.

Latest notes: The field group header is the initial part and sort key of every field group, which means that no more fields can be included in header after EXTRACT is executed for the first time.
The rows of an extract dataset cannot be deleted explicitly and are persisted as long as the internal mode
of the program.
In global classes, no field groups can be defined or edited. In methods of local classes of programs other than class pools, the sta
tement EXTRACT is possible for globally defined field groups.
Extracts are obsolete. Internal tables are recommended instead.

Example ABAP Coding This example continues the example under INSERT . The fields of the field groups flight_info and flight_date are filled in a nested
LOOP and appended to the extract dataset.
REPORT ...

DATA: spfli_wa TYPE spfli,
sflight_wa TYPE sflight,
spfli_tab LIKE TABLE OF spfli_wa,
sflight_tab LIKE TABLE OF sflight_wa.

FIELD-GROUPS: header, flight_info, flight_date.

START-OF-SELECTION.
INSERT: spfli_wa-carrid spfli_wa-connid sflight_wa-fldate
INTO header,
spfli_wa-cityfrom spfli_wa-cityto
INTO flight_info.

SELECT *
FROM spfli
INTO TABLE spfli_tab.

SELECT *
FROM sflight
INTO TABLE sflight_tab.

LOOP AT spfli_tab INTO spfli_wa.
sflight_wa-fldate ='--------'.
EXTRACT flight_info.
LOOP AT sflight_tab INTO sflight_wa
WHERE carrid = spfli_wa-carrid AND
connid = spfli_wa-connid.
EXTRACT flight_date.
ENDLOOP.
ENDLOOP.
Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved




EXPORT_NAMETAB
EXTRACT_EXCEPTIONS




comments powered by Disqus