Data Extracter

[Former Member]

Hi ,

What is Data Extracter, How to do that one , on which type of area we can do extract. Please give example.

Thanks & Regards

Raghava

[Former Member]

Hello,

REPORT DEMO.

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.

END-OF-SELECTION.

LOOP.

AT FIRST.

WRITE / 'Start of LOOP'.

ULINE.

ENDAT.

AT FLIGHT_INFO WITH FLIGHT_DATE.

WRITE: / 'Info:',

SPFLI-CARRID, SPFLI-CONNID, SFLIGHT-FLDATE,

SPFLI-CITYFROM, SPFLI-CITYTO.

ENDAT.

AT FLIGHT_DATE.

WRITE: / 'Date:',

SPFLI-CARRID, SPFLI-CONNID, SFLIGHT-FLDATE.

ENDAT.

AT LAST.

ULINE.

WRITE / 'End of LOOP'.

ENDAT.

ENDLOOP.

tables: mara.

types : begin of str_mara,

matnr type matnr,

mtart type mtart,

meins type meins,

matkl type matkl,

ernam type ernam,

mbrsh type mbrsh,

bstme type bstme,

end of str_mara.

data: wa_mara type str_mara,

it_mara type standard table of str_mara.

field-groups: fld_grp.

start-of-selection.

insert mara-matnr mara-mtart mara-meins

mara-matkl mara-ernam into fld_grp.

insert mara-mbrsh mara-bstme into fld_grp.

select matnr mtart meins matkl ernam mbrsh bstme from mara into

correspoNDING FIELDS OF mara.

extract fld_grp.

endselect.

clear mara.

loop.

at fld_grp .

wa_mara-matnr = mara-matnr.

wa_mara-mtart = mara-mtart.

wa_mara-meins = mara-meins.

wa_mara-matkl = mara-matkl.

wa_mara-ernam = mara-ernam.

wa_mara-mbrsh = mara-mbrsh.

wa_mara-bstme = mara-bstme.

append wa_mara to it_mara.

endat.

endloop.

sort it_mara by matnr.

loop at it_mara into wa_mara.

write:/ wa_mara-matnr, wa_mara-mtart, wa_mara-meins, wa_mara-bstme.

endloop