Ansicht
Dokumentation
SIMG_OHAX428 - Set Up Line Layout in Window
CL_GUI_FRONTEND_SERVICES - Frontend Services BAL_S_LOG - Application Log: Log header dataThis documentation is copyright by SAP AG.
This IMG activity enables you to set up the line layout in the window.
The layout of individual lines in a window can be identical. This means, for example, that a window could contain several lines in which the wage type text and then the wage type amount are displayed as of exactly the same columns. Information printed in a window is not, therefore, provided with print specifications such as column length and output length; instead, layouts are defined which structure the lines within the window. The layouts are assigned to individual wage types using an identifier in the step "Set up wage types in window".
By setting up line layouts, you can avoid repeating entries unnecessarily for:
- different information types (such as for wage type amounts, texts, and numbers)
- columns
- output length
- conversion
- field offsets
Such repetition may be avoided because layouts can be used time and time again, which means that you can assign them to all of the wage types that are printed in accordance with one specific schema.
GENERAL PROCEDURE
A layout is always line-oriented, ie. it determines the schema according to which a line is printed. The number of entries to be created for a layout is equal to the amount of information to be printed in a line. Each entry always refers to a specific piece of wage type information (such as wage type amount, key, text etc.). The entry determines how the wage type information is printed in each line. This means that it is possible for a layout to consist of one single entry. is more usual, however, for a layout to consist of more than one entry.
The following must be specified for each entry:
- Line type
- Column type
- Offset
- Output length
- Field name
You can also specify the following for every entry:
- Conversion
- Field offset for printout
- Rule for form editing
These specifications are explained below in so far as they are not self-explanatory.
Line type and column type
The combination of line type and column type identifies a layout.
The line type is a two-digit numeric value which can be chosen freely (01-99). All of the entries for a layout must always have the same line type.
The column type is one-digit long and it specifies which column of the window information should be printed in. Every window in the payroll account contains three different columns:
- text column
- The wage type and the wage type text or the end date of the in-period are printed in this column in standard form "DK01".
- totals column/column of averages
- This column displays the cumulative amount of a wage type for the periods shown, or the averages (= cumulative amount divided by the number of period columns in the line).
- period column
- The period column contains the total amount, the rate, or the wage type amount for a period. In certain countries, other values (such as tax bracket, religious denomination etc.) can also be displayed in the period column.
- The period column usually appears several times in a window. You can determine the maximum number of period columns allowed by entering the required number in the field Number of columns per page on the initial screen of the report for creating payroll accounts.
In accordance with these three different column types in the window, three different column types can be assigned to information:
- "X"
- You should use column type "X" for all information that should be printed in the text column of the window.
- "S"
- You should use column type "S" for all information that should be printed in the totals column or in the column of averages.
- "1"
- You should use column type "1" for all information that should be printed in the period column.
When creating a payroll account, please proceed as follows:
For every wage type, information with column type "X" is printed first. For this reason, column type "X" must be assigned to every required wage type in the IMG activity "Set up wage types in window". After this, information with column type "1" (period values) is printed. The total value is then determined from the period values.
In addition to the column types mentioned, there is another column type:
- "T"
- Column type "T" should be used only for initial group texts and final group texts (see: "Initial group texts and final group texts" at the end of this IMG activity).
- Example:
- You want to print the following wage type information in a line:
- the wage type key in the text column
- the wage type text in the text column
- the cumulative value of the wage type in the totals column
- the total amount of the wage type in the period column
- You must make four entries for this layout. For these entries, you must always choose the same line type (for example "01"). You should specify column type "X" for information in the text column, column type "S" for information in the totals column, and column type "1" for information in the period column.
Note
In addition to the individual entries for the required layouts, you must create three further entries. If these entries are missing, the output of information in the window has not been defined.
These three entries determine the following:
- the offset of the totals column and period column in the window
- the output length of information in the totals column and period column
- the distance between the individual period columns
The required entries should be as follows:
| LType | CType | Offs | Length | Field | FOffs | Conv | Rule | ||
|---|---|---|---|---|---|---|---|---|---|
| CO | S | ' | |||||||
| CO | 1 | ' | |||||||
| CO | 2 | ' | |||||||
You must enter the required values in the fields Offset and Output length. Choose values that will not cause the individual columns to overlap.
The first entry specifies the column where the totals column starts and its output length.
The second and third entries specify the column as of which the first and the second period column start and the output length for each period column. The system uses the offsets of the first and second period column to determine automatically the offset of any further periods. It is therefore not necessary to specify this.
In addition to the three entries mentioned, you can also create an entry with column type "CO" for the text column:
| LType | CType | Offs | Length | Field | FOffs | Conv | Rule | ||
|---|---|---|---|---|---|---|---|---|---|
| CO | X | ' | |||||||
At present, this entry is not mandatory (that is, the specifications as to the offset and output length of the text column are not taken into account when a payroll account is created). However, you can use these entries as information for arranging the columns in the payroll account.
Field name
The information itself is stored in the field Field name. In this field, you can enter either a constant, a text module identifier or a table field.
- Constant
- A constant is printed on a payroll account in exactly the same way as it is specified in the field Field name. Each constant must be preceded by an apostrophe, which identifies it as a constant.
- Example:
- You want to enter "-" as a constant in the field Field name. To do this, you must enter the following:
- '_
- Information in the totals column
-
The information in the totals column is not stored in any internal payroll table, but is determined
when a payroll account is created. Therefore, for information to be displayed in the totals column,
you must enter the constant
in the field Field name. Enter the constant as follows:
- '
- NB: Every piece of information that can be specified as a constant can also be defined as a text module. You MUST do this if the length of the information in question exceeds 10 and/or the information in question is required in several languages "Set up text modules").
- Text module identifier
- You can specify a text module identifier which you have already set up in the IMG activity "Set up text modules" as a field name (eg. "TEXT01"). There must always be a hyphen between the character string "TEXT" and the respective number of the text module.
- Example:
- You want to specify a text module with identifier "TEXT05" in the field Field name.
- TEXT-05
- Table field
-
You can also specify a table field as a field name. You must ALWAYS specify a table field if the information
to be set up is variable. An exception to this rule is information; you must specify the constant
for this. (see "Constant").
- In the overview "allowed tables", all of the tables flagged in column "T512D" contain fields which can be specified in the field Field name. The specific table fields which can actually be used are listed under the respective table names in the overview "Allowed field names".
- Table fields are specified in the field Field name by listing the table in which the field is stored, then a hyphen, and finally the field name itself.
- Example:
- You want to enter the total amount of a wage type. This is stored in the field BETRG in table "XRT". In this example, you must enter the following in the field Field name.
- XRT-BETRG
- Fields from table "SCHLW" are an exception. In the field Field name, you must enter them without a hyphen and without the name of the table.
- Example:
- They want to enter the date on which an employee was hired. This is stored in the field PHIRE in table "SCHLW". In this example, you must enter the following in the field Field name.
- PHIRE
- If you do not know which table contains the piece of information required, you can find out by taking careful note of the following:
- Information on wage types (including cumulation wage types), with the exception of the wage type text, ALWAYS comes from internal payroll table "XRT".
- The wage type text of a wage type comes from table "T512T" ("T512T-KZTXT", "T512T-LGTXT") UNLESS it was stored as a text module. Instead of printing the wage type text using the field names "T512T-KZTXT" or"T512T-LGTXT", you can also use the field name "XRT-T/E" (wage type text / end date of in-period) for this. If you specify this field name, then the text of a wage type is printed during an original payroll run (that is, 'in' period = 'for' period). However, during a retroactive accounting run, the end date of the 'in' period is printed.
- Initial group texts and final group texts always come from table "T512G" (see INITIAL AND FINAL GROUP TEXTS at the end of this IMG activity).
- Additional information (such as the bank number, cost center) may come from different internal payroll tables (such as "WPBP", "XBT"). The link between a wage type and a table is formed by the split indicator in the payroll results. If a wage type has split indicator "WP" in the payroll results, for example, additional information comes from internal payroll table "WPBP". Please note that additional information from internal payroll tables can only be printed for wage types which have a corresponding split indicator .
- You can determine the required fields of the named tables by following the IMG activity "Set up data in fixed positions" under the heading "Display Information: Table Field".
Output length and conversion
The output length that you specify for information is only taken into account for information with column type "X". Information with column types "S" and "1" are printed with the output length specified by the entry with line type "CO". To cater for possible changes and additions to the payroll account, you should specify an appropriate output length for information with column types
You should choose the output length of information as follows:
- Constant
- For constants, the output length of the field name is the same as the number of characters in the constant.
- Example:
- "-" has been specified as a constant, in the field Field name. In this instance, the output length of the field name is "01".
- Text module identifier
- For text module identifiers, the output length of the field name is the same as the number of characters in the text module represented by
- Example:
- The text module "total gross amount" is specified by the identifier "TEXT05" in the field Field name. The output length of the field name is "12" in this instance.
- Field name
- You can determine the output length of a field name using the overview "Allowed field names". This overview includes the field Output length which contains a default length for every listed field which you can then copy as output length.
- You can always decide to choose an output length that is shorter or longer than the specified default length. The former option involves the risk of information being cut off at the right. With regard to the latter option, you must ensure that the information can be output in full within the predefined field length.
- Information in the totals column
-
For this information (where the constant
must be the field name), you should choose as the output length the length that is specified in the global entry for the totals column (line type "CO", column type "S").
- Conversion
- For field names, it is possible to specify a conversion for the output of information.
- The overview "Allowed field names" contains a list of default conversions for certain fields. These conversions are included in the default length of the fields in question. If you choose a conversion which is not defined as a default, you must include it yourself in the output length of the field.
- The conversions that are allowed for information in windows are flagged in the column "T512D" in the overview "Allowed conversions". You can display explanations on the individual conversions by positioning the cursor on the number of the conversion within this overview and pressing the function key Help.
Offset
In this field, you specify the column as of which the information should be printed. Column counting starts with "0".
The offset that you specify for the information, is only taken into account for information with column type "X". Information with column types "S" and "1" are printed using the offset that is determined by the entry with line type "CO". To cater for possible changes and additions to the payroll account, you should specify an appropriate output length for information with column.
Field offset (part of a character string)
In certain instances, you may need a field to start being printed as of a specific character rather than from the very beginning. By making a appropriate entry in the field Field offset for printout, you can specify the character as of which the field is printed.
- Example:
- The field Account number has a default output length of 18 characters. The first three characters always consist of leading zeros which should not be printed. Therefore, you must enter "03" in the field Field offset for printout to ensure that the field is only printed as of the 4th character. You must also replace length 18 by length 15 in the field
Please take careful note of the following when specifying the field offset:
- The field offset always starts with "00". For this reason, offset "01" means that a field is only printed as of the second character.
- The field offset always stands with the output length of the direct context.
- The field offset is linked directly to the output length of the field.
- An entry can only be made in the field Offset if the field in question is of the type character.
If no entry is made in the field Offset, the default value "00" is set automatically by the system. This means that the field in question is always printed in full; i.e. as of the first character.
Rule for form editing
If information is not printed on a payroll account unless certain conditions have been met, this field enables you to specify the rule identifier which you must first determine in the IMG activity "Set up special processing rules". The rule determines whether or not the information is printed.
EXAMPLE
You will find a list of the abbreviations used in this example under the heading "Abbreviations used" at the end of this IMG activity.
Initial situation
For this example, it is presumed that the following entries already exist:
| LType | CType | Offs | Length | Field | FOffs | Conv | Rule |
|---|---|---|---|---|---|---|---|
| CO | S | 014 | 10 | ' | |||
| (CO | X | 000 | 14 | ') | |||
| CO | 1 | 024 | 09 | ' | |||
| CO | 2 | 033 | 09 | ' | |||
Example:
You want to set up the following line layout in the window:
- In the text column, the wage type key should be printed as of column "000" with output length "04", and the wage type text as of column "005" with output length "08".
- The cumulative value of the wage type should be printed in the totals column.
- The total amount of wage type should be printed in the period columns.
To do this, enter the following:
| LType | CType | Offs | Length | Field | FOffs | Conv | Rule | |
|---|---|---|---|---|---|---|---|---|
| 01 | 1 | 024 | 09 | XRT-BETRG | ||||
| 01 | S | 014 | 10 | ' | ||||
| 01 | X | 000 | 04 | XRT-LGART | ||||
| 01 | X | 005 | 08 | XRT-T/E | ||||
The same line type must always be chosen for all of the entries in a line layout. Line type "01" was chosen here.
Column type "1" specifies that the total amount of the wage type (stored in the field "XRT-BETRG") should
be printed in the individual period columns. Column type "S" specifies that the cumulative value of
the wage type(represented as the constant
The offset and the output length for the entries with column types "1" and "S" are not taken into account when the payroll account is created; however, it is recommended that you make this specification in case program changes occur at a later stage. The same values as those for the CO entries were chosen here.
The offset and the output length for information in the text column should be specified using the appropriate values.
INITIAL AND FINAL GROUP TEXTS
An appropriate layout must be set up for each initial and final group text defined in the IMG activity "Set up initial and final group texts in window". Please bear the following in mind:
- A layout for a group heading always consists of just one entry.
- The line type for this entry must be identical to the line type of the first piece of information of the respective group.
- The column type for this entry is always "T" (see line type and column.
- "T512G-TEXT" must always be chosen as the field name for this entry.
- Example:
- You want to set up a layout for an initial group text. The line type of the first piece of information of the respective group is "01". In this example, you must enter the following:
| LType | CType | Offs | Length | Field | FOffs | Conv | Rule | |
|---|---|---|---|---|---|---|---|---|
| 01 | T | 000 | 99 | T512G-TEXT | ||||
- The line type for an initial group text must always be identical to the line type of the first piece of information of the respective group. The fixed values explained above should be entered in the remaining fields.
If you have carried out the individual steps for the payroll account in the specified sequence, you will not yet have determined any initial or final group texts. Consequently, one of the following two procedures is recommended with regard to the layout of initial and final group texts:
- You must first perform the IMG activities "Set up wage types in window" and
- "Set up initial the layout for the initial and final group texts used.
- This is the preferred procedure if you only need initial and final group texts for a few groups in the window, or if you have not yet had any experience of groups or initial and final group texts.
- You set up one initial or final group text for every line type used.
- This is the preferred procedure if you need initial and final group texts for a large number of groups in the window.
Note
If you discover when performing the IMG activity "Set up wage types in window" that a particular line layout which you need to assign to a wage type has not been defined, you can return at any time to the IMG activity "Set up line layout in window" and then set up the line layout you require.
Abbreviations used
In the examples shown, the following abbreviations are used:
| LType | Line type |
| CType | Column type |
| Offs | Offset |
| Length | Output length |
| Field | Field name |
| FOffs | Field offset for printout |
| Conv | Conversion |
| Rule | Rule for form editing |
Activities
Set up the line layout in the window.
CPI1466 during Backup BAL Application Log Documentation
This documentation is copyright by SAP AG.
Length: 32442 Date: 20240523 Time: 204112 sap01-206 ( 469 ms )
