Maintaining Customizing Tables

Objectives

After completing this lesson, you will be able to:
  • Configure tables in the implementation guide to meet customization requirements
  • Delete existing table entries in the implementation guide
  • Set end dates on existing table entries

Customizing Tables in the IMG

You store employee data in infotypes. All entries that require specific texts come from tables that you can set up when you customize the system. The possible entries, which you can view by pressing F4, are a section of the IMG and enable you to see the data that the system stores in the corresponding table.

Customizing Tables: Key and Function Fields

As a personnel administrator, you need to create entries in Customizing tables to input employee master data and map the employees to the company data, such as enterprise structure, personnel structure and pay scale groups.

Every entry in a Customizing table has key and function fields. Key fields are grey and identify a unique entry, while function fields are white and describes an entry more precisely.

Note

There can be only one table entry with the same key fields. This ensures that all table entries are unique.

Customizing Tables Create/Copy

You can use the following methods to create entries in Customizing tables:

New entries:
When you use the New Entries option, you receive an empty input template in which you can enter both the key and the function fields.
Copy entries:
To copy an existing entry, select the entry that you want to copy and overwrite the entries in the key field, and if necessary, the function fields on the subsequent screen.

Remove Table Entries

Delimit Table Entries

You can also set end dates for table entries that are no longer valid after a certain date. This is called delimiting an entry. Delimiting invalidates an entry the day after the delimitation date.

To set an end date, choose the Delimit pushbutton and enter the delimitation date.

The system then automatically creates a new record, and you overwrite the function field. The old table entry is retained in system history.

Note

In time-dependent tables, the system only displays records that are currently valid. You can use the Expand-Collapse function to display all the records.

How to Delimit a Table Entry

DemoStart Demo

Use project IMG to delimit an entry.

Steps

  1. In the IMG, navigate to the Basic Pay node and start the IMG activity Revise Pay Scale Groups and Levels . This calls the pay scale table T510.

    1. In the IMG , choose Personnel Management→Personnel Administration→PayrollData→Basic Pay→Revise Pay Scale Groups and Levels .

      Enter the following values in the dialog box that appears:

      Country grouping99
      PS type90
      Pay scale area50

    2.  Choose the New Entries pushbutton and enter the following data, then copy the entry by choosing the Copy As pushbutton.

      Now create another entry with the following values:

      Grouping2
      Pay scale groupGR##
      Pay scale level01
      Wage typeany
      Start date01.01.2002
      End date31.12.9999
      Amountany
      CurrencyEUR

  2. During collective agreement negotiations, a decision was made to increase the value of the entry you have just created by 5%.

    Why can you not simply overwrite the old value using the change function?

    1. Highlight the entry and choose the Delimit pushbutton.

    2. Use today’s date.

    3. Change the amount value.

    4. Choose Enter , Save and then the Back pushbutton.

    5. Select entry and choose the Expand<->Collapse pushbutton to display the history.

      If you overwrite the old value, you also overwrite the history. Historical data can be important. For example, for retroactive accounting.

Delimit a Table Entry

ExerciseStart Exercise
ExerciseStart Exercise
ExerciseStart Exercise

Business Example

During collective agreement negotiations, a new value for a pay scale type and pay scale area was agreed upon and must be set up in the system.

A decision was later made to increase the value of the entry 5%.

You need to create an new value for a pay scale type and pay scale area for your pay scale group and level. You must then delimit the old entry and set up a new value which represents a 5% increase.

Use the project IMG to create and delimit the entry.

Steps

  1. In the IMG, navigate to the Basic Pay node and start the IMG activity Revise Pay Scale Groups and Levels. This calls the pay scale table T510.

    1. In the IMG , choose Personnel Management→Personnel Administration→Payroll Data→Basic Pay→Revise Pay Scale Groups and Levels .

      Enter the following values in the dialog box that appears:

      Grouping99
      PS type90
      Pay scale area50

    2.  Choose the New Entries pushbutton and enter the following data, then copy the entry by choosing the Copy As pushbutton.

      Now create another entry with the following values:

      Grouping2
      Pay scale groupGR##
      Pay scale level01
      Wage type 
      Start date01.01.2024
      End date31.12.9999
      Amountany
      CurrencyEUR

  2. During collective agreement negotiations, a decision was made to increase the value of the entry you have just created by 5%.

    Why should you not simply overwrite the old value using the change function?

    1. Highlight the entry and choose the Delimit pushbutton.

    2. Use today’s date.

    3. Change the amount value.

    4. Choose Enter , Save and then the Back pushbutton.

    5. Select entry and choose the Expand<->Collapse pushbutton to display the history .

      If you overwrite the old value, you also overwrite the history. History data are important, for example, for retroactive accounting.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn