Skip to Content
author's profile photo Former Member
Former Member

extract st.

hai ....

Can u explain what is an Extract statement and also how is it usefull in the program?

thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 05:19 AM

    HI,,

    From f1 help....

    EXTRACT

    Basic form

    EXTRACT fg.

    Effect

    Writes all fields of the field group fg (FIELD-GROUPS) as an entry in asequential dataset. If you have defined a field group HEADER,its fields precede each entry as a sort key. Afterwards, you canuse SORT and LOOP ... ENDLOOP to sort or process the datasetrespectively. No further EXTRACT statements are possible afterthis.

    Notes

    General:

    As soon as you have extracted a dataset using EXTRACT, you canno longer extend the field group using INSERT. In particular, you cannot change the HEADERfield group at all after the first EXTRACT (regardless of thefield group to which it applied).

    Large extract datasets are not stored in main memory. Instead, theyare kept in an external auxiliary file. You can set the directory inwhich this file is created using the SAP profile parameterDIR_EXTRACT. The default directory is the SAP data directory(SAP profile parameter DIR_DATA).

    Notes

    Runtime errors:

    EXTRACT_AFTER_SORT/LOOP: EXTRACT after SORT, orLOOP. EXTRACT_BUFFER_NO_ROLL: Unable to create the required main

    EXTRACT_FIELD_TOO_LARGE: Occupied length of a field is toolarge.

    EXTRACT_HEADER_NOT_UNIQUE: Field group HEADER wasmodified after an EXTRACT statement.

    EXTRACT_OPEN_EXTRACTFILE_OPEN:

    Error opening the external extract dataset file.

    EXTRACT_RESOURCEHANDLER_FAILED: Error deleting the externalextract dataset file.

    EXTRACT_TOO_LARGE: Total length of the entry for extraction(including HEADER fields) is too large.

    Additional help

    Filling anExtract with Data

    Regards,

    Kish.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 05:17 AM

    Hi Pavan,

    EXTRACT <fg>.

    When the first EXTRACT statement occurs in a program, the system creates the extract dataset and adds the first extract record to it. In each subsequent EXTRACT statement, the new extract record is added to the dataset.

    Each extract record contains exactly those fields that are contained in the field group <fg>, plus the fields of the field group HEADER (if one exists). The fields from HEADER occur as a sort key at the beginning of the record. If you do not explicitly specify a field group <fg>, the EXTRACT statement is a shortened form of the statement extracts used in field groups (version 2.x - obsolete these days as noone uses field groups anymore), and collect is used to accumulate the contents of a field if X no. of keys are the same.

    EXTRACT HEADER.

    When you extract the data, the record is filled with the current values of the corresponding fields. As soon as the system has processed the first EXTRACT statement for a field group <fg>, the structure of the corresponding extract record in the extract dataset is fixed. You can no longer insert new fields into the field groups <fg> and HEADER. If you try to modify one of the field groups afterwards and use it in another EXTRACT statement, a runtime error occurs.

    By processing EXTRACT statements several times using different field groups, you fill the extract dataset with records of different length and structure. Since you can modify field groups dynamically up to their first usage in an EXTRACT statement, extract datasets provide the advantage that you need not determine the structure at the beginning of the program.

    Example: REPORT demo_extract_extract.

    NODES: spfli, sflight.

    FIELD-GROUPS: header, flight_info, flight_date.

    INSERT: spfli-carrid spfli-connid sflight-fldate

    INTO header,

    spfli-cityfrom spfli-cityto

    INTO flight_info.

    START-OF-SELECTION.

    GET spfli.

    EXTRACT flight_info.

    GET sflight.

    EXTRACT flight_date.

    Reward if useful!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 05:19 AM

    Hi,

    Check this.

    http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/extract.htm

    Reward if useful

    Suruchi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 30, 2007 at 12:22 PM

    hi pavan,

    extract dataset is made up of a dynamic number of lines. Sizes of up to 2 GB

    chk out this example or refer abapdocu tcode.

    NODES: spfli, sflight.

    FIELD-GROUPS: header, flight_info, flight_date.

    INSERT: spfli-carrid spfli-connid sflight-fldate

    INTO header,

    spfli-cityfrom spfli-cityto

    INTO flight_info.

    thanks '

    jaideep

    if solved reward points and close the thread

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.