Field-Groups ; How does it work with loops

prabhu_s2 — Fri, 15 Jul 2011 12:13:47 GMT

Hi ,

I had been with couple of examples on field groups but one thing i couldnt understand is how it is working with the loops and sort. is there any documentation you can help me with please? some of the post i really found it repetitive or being posted again b copying from other thread and no useful info provided....

Regards

Prabhu

Re: Field-Groups ; How does it work with loops

Sandra_Rossi — Fri, 15 Jul 2011 19:55:04 GMT

Hi Prabhu,

a little summary of how work extracts (that's the official name, field groups are one of the components):

- FIELD-GROUPS fieldGroupName defines the name of a field group. There's a special group named "header" that is important for sorting, all its fields will be implicitly part of all field groups.

- INSERT globvar1 globvar2 ... INTO fieldGroupName defines (once for each field group, at the top of the program) which global variables are assigned to a field group (see them as a transmission of their data references). Note that you may share the same global variables as the ones of the "header" field group, so that to sort them

- EXTRACT fieldGroupName writes one "line" to the extract dataset, which contains the field group name and the contents of all its assigned global variables

- The program must have generated the whole extract dataset first, so that to then be able to read it, once (EXTRACT after SORT will dump)

- SORT BY globvar1 ... sorts the extract dataset by these global variables which must belong to the "header" field group (must have been defined by INSERT)

- LOOP (without any keyword) starts reading the extract, one "line" at a time. That fills the global variables of the corresponding field group

- Within the loop, you may use AT fieldGroupName to process data based on the filled global variables, and you may also use AT globvar1 which have been defined in the SORT command.

I hope to be clear enough.

Sandra

PS: extracts are obsolete (but still widely used in R/3)

Edited by: Sandra Rossi , 2 minutes later

Doc: [SAP Library: Extract|http://help.sap.com/saphelp_nw70/helpdata/en/9f/db9ed135c111d1829f0000e829fbfe/frameset.htm]

topic Field-Groups ; How does it work with loops in Application Development and Automation Discussions

Field-Groups ; How does it work with loops

Re: Field-Groups ; How does it work with loops