3.2.05 Order form (typical kind of form: Header/ Tab.section/ Footer)

The introduction.


In the example we'll see how to create most common type of printing form, consisting of three sections :

SAP export to Excel

Here are that three sections in the form:

·         Header – rows from 1 to 13 inclusive .

·         Tabular section: row 14 (position), which was replicated several times (10 times in this case).

·         Footer – rows from 24 to 38.

Looking ahead, we note main highlights: 

When designing context, we will include two structureHEADER and FOOTER, which in turn consist of elementary fields providing values

To implement tabular section, the context contains a nested table POSITIONS, consisting of four elementary fields - in accordance with the table of the Excel-template.


When designing form, for each of the sections (Header / Positions / Footer) we need to create corresponding «Pattern»  . For what? As previously stated, «Pattern» refers to a cell range in Excel-template and describes formatting of cells.

To implement loop at positions, we use the component «Loopstep»  , which we associate with the context nested table POSITIONS. Inside the loop we will insert the «Pattern» LINE, which we associate to the row of the table section in the Excel-template.

So, we have 3 patterns in the form: HEADERLINE and FOOTER:

SAP 2 EXCEL export mapping