Ansicht
Dokumentation

SIMG_OHAX513 - Cumulate Identifiers

SIMG_OHAX513 - Cumulate Identifiers

ABAP Short Reference   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book

You need only carry out this step if you want to cumulate certain wage types (identifiers) for printing.

In some cases you may want to cumulate certain wage types for printing on a remuneration statement. This involves grouping individual wage types together into a cumulation identifier (otherwise called cumulation wage type).

This step describes cumulation in greater detail with respect to the following:

  1. 1 Printing options
  2. 2 General cumulation procedure
  3. 3 Special features of cumulation

The special features of cumulation are only relevant if your requirements extend past the normal limits of cumulation.

Since the functions described below only apply to wage types that are used in the remuneration statement, this section will use the term "wage types" instead of the more general term "identifier".

For a list of the abbreviations used in the examples, refer to "Abbreviations used" at the end of this step.

1,,Printing options

A cumulation wage type can be printed both in a window and in a fixed position (individual field).

2,,General cumulation procedure

Three possible cases can be distinguished within the general cumulation procedure:

  • 2.1,,Cumulation with unsplit wage types
  • 2.2,,Cumulation with split wage types

2.1,,Cumulation with unsplit wage types

The arithmetic symbol is used to specify whether each wage type used in cumulation is positive (+) or negative (-). You must also assign each cumulation wage type an identifier by which it can be addressed. This identifier (e.g. "1234", "1235") must have four characters and since the cumulation wage type is customer-specific, must be composed solely of numbers.

Example:

The payroll results (table "RT") contain the monthly values (total amounts) for the wage types "Standard pay" (MA10), "MA20" (Standard bonus) and "Voluntary bonus" (MA40):

Wage type Total amount
MA10 3,300.-
MA20 500.-
MA40 1,000.-

You want to group together the monthly values of these wage types in the cumulation wage type "Total payments". To do this you must make the following entries:

  1. Step 1

In the form editor, choose "Cumulation identifier", and then enter the following in the dialog box "Change cumulation identifier":

Id Long text   Short text Summand
1234 Total payments Total

Total payments

You are in the dialog box "Change cumulation identifier" of the form editor. Choose Details to access the dialog box "Change layout of cumulation identifier ...". Enter the following:

Table Id Ltext AS Conv Rule SSplit   DSplit
RT   MA10   ...,.., +
RT   MA20   ...   +
RT   MA40   ...   +

The cumulation wage type is then printed on the remuneration statement as follows:

1234 Total payments 4.800.-

2.2,,Cumulation with split wage types

You can include both split and unsplit wage types in a cumulation wage type. If split wage types are included, the existing wage type splits must be suppressed for cumulation. As in the compression procedure, a wage type split is suppressed by means of the DSplit (Delete split) field. Various indicators can be used in this field depending on the type of wage type split in question. For example, a work center/basic pay split can only be suppressed using the indicator "A" (work center/basic pay) or the placeholder "*" (all indicators). The placeholder "*" suppresses all existing splits of a wage type.

For a list of all indicators, select the Help function on the DSplitfield.

Example:

The payroll results (table "RT") contain the monthly values of the wage types "Standard pay" (MA10), "Standard bonus" (MA20) and "Voluntary bonus" (MA40) together with the specified monthly values (total amounts). Wage type MA10 has a cost accounting split ("KR") which includes several time specifications. These specifications are identified by two-digit numbers in the split column "KR":

KR Total amount
MA10 01 1.100.-
MA10 02 2.200.-
MA20   500.-
MA40   1.000.-

You want to group together the monthly values (total amounts) of these wage types into the cumulation wage type "Total payments". To do this you must make the following entries:

  1. Step 1

In the form editor, choose "Cumulation identifier", and then enter the following in the dialog box "Change cumulation identifier":

Id Long text   Short text   Summand
1234 Total payments Total

Total payments

You are in the dialog box "Change cumulation identifier" of the form editor. Choose Details to access the dialog box "Change layout of cumulation identifier ...". Enter the following:

Table   Id,..,Ltext   AS Conv Rule SSplit DSplit
RT   MA10   ...   +       K
RT   MA20   ...   +
RT   MA40   ...   +

In this case, the split for wage type MA10 is suppressed using the indicator "K" (cost distribution).

The cumulation wage type is then printed on the remuneration statement as follows:

1234 Total payments 4.800.-

3,,Special features of cumulation

You need only read this section if your requirements exceed the general scope of cumulation described above.

There are two further output options for cumulation of wage types:

  • A wage type split can be printed with a different text from that used in the payroll results (4.2).
  • Wage types which have at least one split in common can be cumulated into a cumulation wage type taking the split indicator into account (4.3).

3.1,,Printing options

Wage type splits are printed using both output options. Split (cumulation) wage types can only be printed in a window.

3.2,,Changing wage type text when there is a wage type split

In some cases, you may need to print a wage type that has been split one or several times with a text different from that in the payroll results. This can be done by cumulating the split wage type. In a second step, you can assign the cumulation wage type a wage type text which you can define yourself.

Example:

The payroll results (table "RT") contain the monthly value (total amount) of the wage type "Standard pay" (MA10) with a cost accounting split ("KR") and a work center/basic pay split ("WP"). Both splits include several time specifications. These specifications are identified by two-digit numbers in split columns "KR" and "WP":

KR WP Total amount
MA10 01 01 1.000.-
MA10 02 01 500.-
MA10 02 02 700.-
MA10 03 02 1.100.-

You want the wage type split to be printed on the remuneration

statement with the text "Monthly payment" rather than "Standard pay". To achieve this, you must make the following entries:

02

In the form editor, choose "Cumulation identifier", and then enter the following in the dialog box "Change cumulation identifier":

Id Long text   Short text   Summand
1234 Monthly payment   ...

 

You are in the dialog box "Change cumulation identifier" of the form editor. Choose Details to access the dialog box "Change layout of cumulation identifier ...". Enter the following

Table Id Ltext AS Conv Rule SSplit   DSplit
RT   MA10   ...   +

The cumulation wage type is then printed on the remuneration statement as follows:

1234 Monthly payment 1.000.-
1234 Monthly payment 500.-
1234 Monthly payment 700.-
1234 Monthly payment 1.100.-

3.3,,Cumulation of split wage types taking account of splits

Split wage types can be cumulated taking split indicators into account if they have at least one split in common. This means that the specification (period) and the type of split (e.g. cost accounting split, payroll type split) are identical.

Three different cases can be distinguished among split wage types:

  • 3.3.1,,Cumulation of wage types where all splits are identical
  • 3.3.2,,Cumulation of wage types where some splits are identical and others are not

3.3.3,,Cumulation of a wage type split several times taking account of part of the split

3.3.1,,Cumulation of wage types where all splits are identical

Wage types where all splits are identical can be cumulated taking the split indicator into account by grouping them together into a cumulation wage type.

Example:

The payroll results (table "RT") contain the monthly values (total amounts) for the wage types "Standard pay" (MA10) and "Standard bonus" (MA10) with a cost accounting split ("KR") and a work center/basic pay split ("WP"). Both splits have the same time specifications. These specifications are identified by two-digit numbers in split columns "KR" and "WP":

KR WP Total amount
MA10 01 01 1.100.-
MA10 02 02 2.200.-
MA20 01 01 300.-
MA20 02 02 500.-

You want to cumulate the wage types into the cumulation wage type Total payments taking the split indicators into account. To achieve this you must first make the following entries:

  1. Step 1

In the form editor, choose "Cumulation identifier", and then enter the following in the dialog box "Change cumulation identifier":

Id Long text   Short text   Summand
1234 Total payments   ....

 

You are in the dialog box "Change cumulation identifier" of the form editor. Choose Details to access the dialog box "Change layout of cumulation identifier ...". Enter the following

Table   Id   Ltext   AS Conv Rule SSplit DSplit
RT   MA10   ...   +
RT   MA20   ...   +

The cumulation wage type is then printed on the remuneration statement as follows:

1234 Total payments 1.400.-
  (= total of MA10 split 01 and MA20 split 01)
1234 Total payments 2.700.-
  (= total of MA10 split 02 and MA20 split 02)

3.3.2,,Cumulation of wage types where some splits are identical and others are not

If some splits are identical and others are not, these must be suppressed using the fields DSplit(Delete split) and, if applicable, SSplit(Set split) in order for cumulation to take place. There are two possible methods of doing this.

Method 1

The DSplitfield lists the indicators for each wage type split in the payroll results which are not identical for all wage types you want to cumulate.

Example:

The payroll results (table "RT") contain the monthly values (total amounts) for the wage types "Standard pay" (MA10) and "Standard bonus" (MA20) with cost accounting splits ("KR") which include the same time specification for both. Wage type "MA10" also has a work center/basic pay split ("WP") with several time specifications:

KR WP Total amount
MA10 01 01 1.100.-
MA10 02 02 2.000.-
MA10 02 03 200.-
MA20 01   300.-
MA20 02   500.-

You want to cumulate the wage types into the cumulation wage type "Total payments" taking the split indicators into account. In this case you must make the following entries:

  1. Step 1

In the form editor, choose "Cumulation identifier", and then enter the following in the dialog box "Change cumulation identifier":

Id Long text   Short text   Summand
1234 Total payments   ...

 

You are in the dialog box "Change cumulation identifier" of the form editor. Choose Details to access the dialog box "Change layout of cumulation identifier ...". Enter the following

Table   Id   Ltext   AS Conv Rule SSplit DSplit
WType Tab ... WType AS ... DSplit ...
MA10 RT   1234 +   A
MA20 RT   1234 +

In this case the wage type split which is not identical is suppressed using the indicator "A" (work center/basic pay).

The cumulation wage type is printed on the remuneration statement as follows:

1234 Total payments 1.400.-
  (= total of MA10 split 01 and MA20 split 01)
1234 Total payments 2.700.-
  (= total of MA10 split 02 and MA20 split 02)

Method 2

An alternative method, safer in view of the possibility of changes to the splits, consists in deactivating all splits by entering the placeholder "*" (all indicators) in the DSplit field. You must then reset the indicators which are the same for all wage types to be cumulated and must therefore be taken into account during cumulation in the SSplit field.

Example:

As in the previous example the payroll results (table "RT") contain the monthly values (total amounts) for the wage types "Standard pay" (MA10) and "Standard bonus" (MA20) with cost accounting splits ("KR") which include the same time specifications for both. Wage type MA10 also has a work center/basic pay split ("WP") with several time specifications:

KR WP Total amount
MA10 01 01 1.100.-
MA10 02 02 2.000.-
MA10 02 03 200.-
MA20 01   300.-
MA20 02   500.-

You want to cumulate the wage types into the cumulation wage type "Total payments" taking account of the cost accounting split. To do this, you must make the following entries:

  1. Step 1

In the form editor, choose "Cumulation identifier", and then enter the following in the dialog box "Change cumulation identifier":

Id Long text   Short text   Summand
1234 Total payments   ...

 

You are in the dialog box "Change cumulation identifier" of the form editor. Choose Details to access the dialog box "Change layout of cumulation identifier ...". Enter the following:

Table Id Ltext AS Conv Rule   SSplit   DSplit
RT   MA10   ...   +   K   *
RT   MA20   ...   +

In this case the wage type split which is not identical is deactivated by entering the placeholder "*" in the DSplitfield and then explicitly reactivating the cost accounting split by entering the indicator "K" (cost accounting) in the SSplitfield.

The cumulation wage type is then printed on the remuneration statement as follows:

1234 Total payments 1.400.-
  (= total of MA10 split 01 and MA20 split 01)
1234 Total payments 2.700.-
  (= total of MA10 split 02 and MA20 split 02)

3.3.3,,Cumulation of a wage type split several times taking account of part of the split

If there is only one wage type which has been split several times, you can have the system print only part of the split on a remuneration statement using the DSplitand, if applicable, SSplit fields.

Example:

The payroll results (table "RT") contain the monthly value (total amount) of the wage type "Standard pay" (MA10) with a cost accounting split ("KR"), a work center/basic pay split ("WP") and a payroll type split ("AP"):

KR WP AP Total amount
MA10 01 01 01 1.100.-
MA10 01 02 01 1.500.-
MA10 02 02 02 700.-

You want to cumulate the wage type into the cumulation wage type "Total payments" taking account of the cost accounting split. To do this you must make the following entries:

  1. Step 1

In the form editor, choose "Cumulation identifier", and then enter the following in the dialog box "Change cumulation identifier":

Id Long text   Short text   Summand
1234 Total payments   ...

 

You are in the dialog box "Change cumulation identifier" of the form editor. Choose Details to access the dialog box "Change layout of cumulation identifier ...". Enter the following

Table   Id   Ltext   AS Conv Rule SSplit DSplit
RT   MA10   ...   +   K   *

In this case the wage type splits you do not wish to include are deactivated by entering the placeholder "*" in the DSplit field to deactivate all splits and then explicitly reactivating the cost accounting split by entering a "K" (cost accounting) in the SSplit field.

The cumulation wage type is then printed on the remuneration statement as follows:

1234 Total payments 2.600.- (= amount MA10 split 01)
1234 Total payments 700.- (= amount MA10 split 02)

4,,Abbreviations used

The following abbreviations were used in the above examples:

Table Table name
Id Identifier (wage type)
Ltext Long text
AS Arithmetic symbol
Conv Conversion
Rule Number of the rule
SSplit Column listing splits to be set
DSplit Column listing splits to be deleted

DSplit

Make the required entries using the form editor. Choose the activity for the form editor.






Vendor Master (General Section)   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 35953 Date: 20240523 Time: 203747     sap01-206 ( 279 ms )