SAP Table PA0007
HR Master Record: Infotype 0007 (Planned Working Time)
PA0007 (HR Master Record: Infotype 0007 (Planned Working Time)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PA0007 to other SAP tables.
PA0007 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
PERNR
Personnel number
|
PERSNO | PA0003 |
NUMC
|
8 | 0 | |||||||
|
SUBTY
Subtype
|
SUBTY |
CHAR
|
4 | 0 | ||||||||
|
OBJPS
Object Identification
|
OBJPS |
CHAR
|
2 | 0 | ||||||||
|
SPRPS
Lock Indicator for HR Master Data Record
|
SPRPS |
CHAR
|
1 | 0 | ||||||||
|
ENDDA
End Date
|
ENDDA |
DATS
|
8 | 0 | ||||||||
|
BEGDA
Start Date
|
BEGDA |
DATS
|
8 | 0 | ||||||||
|
SEQNR
Number of Infotype Record with Same Key
|
SEQNR |
NUMC
|
3 | 0 | ||||||||
|
AEDTM
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||
|
UNAME
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||
|
HISTO
Historical Record Flag
|
HISTO |
CHAR
|
1 | 0 | ||||||||
|
ITXEX
Text Exists for Infotype
|
ITXEX |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
REFEX
Reference Fields Exist (Primary/Secondary Costs)
|
PRFEX |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ORDEX
Confirmation Fields Exist
|
ORDEX |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ITBLD
Infotype Screen Control
|
ITBLD |
CHAR
|
2 | 0 | ||||||||
|
PREAS
Reason for Changing Master Data
|
PREAS | T530E |
CHAR
|
2 | 0 | |||||||
|
FLAG1
Reserved Field/Unused Field
|
NUSED |
CHAR
|
1 | 0 | ||||||||
|
FLAG2
Reserved Field/Unused Field
|
NUSED |
CHAR
|
1 | 0 | ||||||||
|
FLAG3
Reserved Field/Unused Field
|
NUSED |
CHAR
|
1 | 0 | ||||||||
|
FLAG4
Reserved Field/Unused Field
|
NUSED |
CHAR
|
1 | 0 | ||||||||
|
RESE1
Reserved Field/Unused Field of Length 2
|
NUSED2 |
CHAR
|
2 | 0 | ||||||||
|
RESE2
Reserved Field/Unused Field of Length 2
|
NUSED2 |
CHAR
|
2 | 0 | ||||||||
|
GRPVL
Grouping Value for Personnel Assignments
|
PCCE_GPVAL |
CHAR
|
4 | 0 | ||||||||
|
SCHKZ
Work Schedule Rule
|
SCHKN |
CHAR
|
8 | 0 | ||||||||
|
ZTERF
Employee Time Management Status
|
PT_ZTERF | T555U |
NUMC
|
1 | 0 | |||||||
|
EMPCT
Employment percentage
|
EMPCT |
DEC
|
5 | 2 | ||||||||
|
MOSTD
Monthly hours
|
MOSTD |
DEC
|
5 | 2 | ||||||||
|
WOSTD
Hours per week
|
WOSTD |
DEC
|
5 | 2 | ||||||||
|
ARBST
Daily Working Hours
|
STDTG |
DEC
|
5 | 2 | ||||||||
|
WKWDY
Weekly Workdays
|
WARST |
DEC
|
4 | 2 | ||||||||
|
JRSTD
Annual working hours
|
JRSTD |
DEC
|
7 | 2 | ||||||||
|
TEILK
Indicator Part-Time Employee
|
TEILK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MINTA
Minimum number of work hours per day
|
MINTA |
DEC
|
5 | 2 | ||||||||
|
MAXTA
Maximum number of work hours per day
|
MAXTA |
DEC
|
5 | 2 | ||||||||
|
MINWO
Minimum weekly working hours
|
MINWO |
DEC
|
5 | 2 | ||||||||
|
MAXWO
Maximum number of work hours per week
|
MAXWO |
DEC
|
5 | 2 | ||||||||
|
MINMO
Minimum number of work hours per month
|
MINMO |
DEC
|
5 | 2 | ||||||||
|
MAXMO
Maximum number of work hours per month
|
MAXMO |
DEC
|
5 | 2 | ||||||||
|
MINJA
Minimum annual working hours
|
MINJA |
DEC
|
7 | 2 | ||||||||
|
MAXJA
Maximum Number of Working Hours Per Year
|
MAXJA |
DEC
|
7 | 2 | ||||||||
|
DYSCH
Create Daily Work Schedule Dynamically
|
DYSCH |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZTIM
Additional indicator for time management
|
KZTIM |
CHAR
|
2 | 0 | ||||||||
|
WWEEK
Working week
|
WWEEK | T559A |
CHAR
|
2 | 0 | |||||||
|
AWTYP
Reference Transaction
|
AWTYP |
CHAR
|
5 | 0 | ||||||||
PA0007 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| PA0007 | MANDT | PA0007 | MANDT |
T000
Clients
|
MANDT |
| PA0007 | PERNR | PA0007 | MANDT |
PA0003
HR Master Record: Infotype 0003 (Payroll Status)
|
MANDT |
| PA0007 | PERNR | PA0007 | PERNR |
PA0003
HR Master Record: Infotype 0003 (Payroll Status)
|
PERNR |
| PA0007 | PREAS | PA0007 | MANDT |
T530E
Reasons for Changes
|
MANDT |
| PA0007 | PREAS | 'NNNN' |
T530E
Reasons for Changes
|
INFTY | |
| PA0007 | PREAS | PA0007 | PREAS |
T530E
Reasons for Changes
|
PREAS |
| PA0007 | WWEEK | SYST | MANDT |
T559A
Working Weeks
|
MANDT |
| PA0007 | WWEEK | PA0007 | WWEEK |
T559A
Working Weeks
|
WWEEK |
| PA0007 | ZTERF | SYST | MANDT |
T555U
Employee Time Management status
|
MANDT |
| PA0007 | ZTERF | PA0007 | ZTERF |
T555U
Employee Time Management status
|
ZTERF |