This tutorial is part of our free SAP HCM course and you are welcome to check out other lessons of this course.
Every infotype must be assigned a time constraint in order to define:
- Whether a record must exist for each employee for that infotype.
- Whether two or more records can exist for an employee for that infotype in the same period.
Types of SAP Time Constraints
There are four SAP time constraints which are used for most infotypes in personnel administration. This section covers these time constraints and identifies a few other, lesser-used time constraints.
Time Constraint 1
This time constraint is used for infotypes in which information must be available throughout the employment period. This time constraint also indicates that one and only one record must be valid for an employee on any given day. This implies that:
- A gap is only permitted between the hire date and the start date of the first record. Subsequently, gaps are not allowed.
- Overlapping of records is not permitted. That is, on any given date, there can be only one valid record for an employee.
Time Constraint 2
This time constraint is used for infotypes in which information need not be available throughout the employment period, however only one record can be valid at any point in time. This implies that:
- Gaps are permitted as these infotypes are used to store optional information.
- Overlapping of records is not permitted. That is, on any given day, there can be only one valid record for an employee.
Time Constraint 3
This time constraint is used for infotypes in which information does not need to be available throughout the employment period and several records can be valid at any point in time. This implies that:
- Gaps are permitted as these infotypes are used to store optional information.
- Overlapping of records is permitted. That is, on any given day, there can be any number of valid records for an employee.
Time Constraint T
This time constraint is used when the time constraint depends on a subtype. It will be assigned to the infotype, and the actual SAP time constraints (1,2 or 3) will be assigned at subtype level. Time constraint T is required when different subtypes of the same infotype have different properties regarding the information they hold.
Note that all standard SAP infotypes come with pre-assigned time constraints. This means that SAP has already assigned the recommended time constraint to every infotype, based on HR best practices.
When a customer-specific infotype is developed for your company, you need to assign a suitable time constraint. Use the following flowchart as a guide to determine which time constraint should be assigned to any infotype:
Other SAP Time Constraints
The following SAP time constraints are seldom used, so we will only covered their definition here.
Time Constraint A
An infotype with this time constraint can have only one record with the maximum date range allowed in the system, with start date of 01/01/1800 and end date of 31/12/9999. This record cannot be deleted.
Time Constraint B
An infotype with this time constraint can have only one record with the maximum date range allowed in the system, with start date of 01/01/1800 and end date of 31/12/9999. This record can be deleted.
Examples of SAP Time Constraints
In this section, we’ve listed out some standard infotypes and included a brief description of what information is stored in each infotype. Again, the time constraints for these infotypes are pre-assigned by SAP. For each example, before reading the explanation, try to reason out which time constraint is most appropriate using the flowchart above. The purpose of this section is to help you understand the rationale behind the time constraint assignment.
Personal Data (Infotype 0002)
This infotype stores an employee’s personal details like name, birthday and marital status.
Explanation: Since this information is mandatory, that is, it should be available for an employee throughout his/her employment period, time constraint 1 is used.
Address (Infotype 0006)
This infotype stores the address data of an employee. It has various subtypes such as permanent address and mailing address.
Explanation: This information may be mandatory or optional depending on the subtype. Hence the time constraint is T.
Applying the same process for each subtype, you can arrive at the time constraint for each one as explained below:
- Permanent address subtype – This is mandatory information, thus this subtype is assigned time constraint 1.
- Mailing address subtype – This information is optional. It needs to be stored only if the employee requests that correspondence be sent to an address other than his/her permanent address. There can be only one record valid for any period. Therefore, the time constraint is 2.
Planned Working Time (Infotype 0007)
This infotype stores an employee’s work schedule and planned daily, weekly, monthly and annual working hours.
Explanation: Since this information should be available for an employee throughout his/her employment period, it is mandatory. Time constraint 1 is used.
Family Members/Dependents (Infotype 0021)
This infotype stores data about an employee’s family members. It has various subtypes such as spouse, child, father, mother and domestic partner.
Explanation: This information is optional. Two or more records may or may not be allowed for the same day depending on the subtype. Hence, the time constraint is T.
Applying the same process for each subtype, you can arrive at the time constraint for each one.
Education (Infotype 0022)
This infotype stores an employee’s education details and training qualifications.
Explanation: This information is optional. Two or more records are allowed for the same day. For example, it is possible that an employee pursued a part-time diploma along with a correspondence course. Hence the time constraint is 3.
Previous Employers (Infotype 0023)
This infotype stores an employee’s previous employment information along with validity of each previous employment.
Explanation: This information is optional. Two or more records are allowed for the same day. For example, it is possible that an employee held two part-time jobs during the same period. Time constraint 3 is assigned.
Impact of SAP Time Constraints on System Behavior
This section demonstrates how the system behavior is dependent on time constraint when data is maintained for an infotype using transaction code PA30.
Time Constraint 1
We have seen that Personal data (Infotype 0002) has time constraint 1. This means that a record must exist in this infotype.
Let’s try to delete the personal data infotype record for an employee. On clicking Delete, the system gives the error message “Record cannot be deleted (time constraint 1)”:
Hence, to ensure the existence of the record, deletion is forbidden.
For this same infotype, we know that only one record can be valid in any given period. Let us try to create another record for the same period. Note the warning message “This entry deletes a record”:
This ensures that only one record is valid for the infotype for this period. If we press Enter to proceed and save the new record, the new data will overwrite the existing data.
Assume that we do not want to overwrite the data, but we want to create a new record effective on a certain date. For example, let’s change the marital status effective 01/01/2015 from Single to Married. Note the Warning message, “Record valid from 01/05/1979 to 12/31/9999 delimited at end”:
This means that since our new record starts from 01/01/2015, the system automatically assigns the previous record with an end date of 12/31/2014, as you can see in the overview screen below:
Time Constraint 2
We have seen that the subtype “Mailing Address” of Address (Infotype 0006) has time constraint 2. This means that a record does not always exist in this subtype, however there can be only one valid record in any given period.
Let us try to delete the subtype record for an employee:
The record is deleted successfully:
For this same subtype we know that only one record can be valid in any given period. Let us first create a record from 0101/2015 through 31/12/9999.
Now let’s try to create another record for the same period. Note the Warning message “This entry deletes a record”:
This ensures that only one record is valid for the infotype for this period. If we press Enter to proceed and save the new record, the new data will overwrite the existing data.
Time Constraint 3
We have seen that Previous Employers (Infotype 0023) has time constraint 3. This means that a record does not need to exist in this infotype. Also, multiple records are allowed for the same period.
Let’s try to delete the infotype record for an employee:
The record is deleted successfully:
For this same infotype, we know that multiple records can be valid in the same period. Let’s try to create two records for the same period. Let’s assume, for example, that the employee has worked as a freelancer with two organizations in the same period. Create the first employer record for the period 01/01/2016 through 02/01/2016:
Create the second employer record for the same period as shown below:
Both records are successfully created as can be seen in the overview below:
—
Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully it’s something we can address for you in improvement of our free SAP HR tutorials.
Navigation Links
Go to next lesson: SAP HR Personnel Actions
Go to previous lesson: SAP Infotype Header Configuration
Go to overview of the course: SAP HR Training
View Comments (1)
the simplest way of your explanation is the key point... Thanks much, Author