simple code for 'extract'

[Former Member]

Hi,
can anyone provide a simple code/algorithm for familiarizing 'extract' statements?
I can't get into a clear idea using the flight model in help.

[Former Member]

hi,

From my knowledge, we wont use extract often.. instead use Internal Tables.

Extract is a dynamical sequential datasets in which different line can have different structure..

procedure for doing it is,

first have to define it using field group,

then, fill dats using Insert keyword

then extract from db to field groups.

Usually, extract ll collect N no. of records with different structure.

the dats will compress by the system while storing.. as the result, the storage space ll get reduce..

Importantly, we can determine the structure during the flow of the program also.. No need to specify at the top of the program like what we do in Internal table..

refer this links for detailed info..

http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/db9ede35c111d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/db9f0535c111d1829f0000e829fbfe/content.htm

hope it helps,

Mathan R.