SAP table PT0416 (Time Quota Compensation Infotype: Database Table)

SAP table PT0416 has 8 primary key fields being MANDT,PERNR,SUBTY,OBJPS,SPRPS,ENDDA,BEGDA,SEQNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PERNR Personnel Number NUMC 8 0 PA0003 PERSNO
SUBTY Subtype CHAR 4 0 SUBTY
OBJPS Object Identification CHAR 2 0 OBJPS
SPRPS Lock Indicator for HR Master Data Record CHAR 1 0 SPRPS
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
AEDTM Last Changed On DATS 8 0 AEDAT
UNAME Name of Person Who Changed Object CHAR 12 0 AENAM
HISTO Historical Record Flag CHAR 1 0 HISTO
ITXEX Text Exists for Infotype CHAR 1 0 ITXEX
REFEX Reference Fields Exist (Primary/Secondary Costs) CHAR 1 0 PRFEX
ORDEX Confirmation Fields Exist CHAR 1 0 ORDEX
ITBLD Infotype Screen Control CHAR 2 0 ITBLD
PREAS Reason for Changing Master Data CHAR 2 0 T530E PREAS
FLAG1 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG2 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG3 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG4 Reserved Field/Unused Field CHAR 1 0 NUSED
RESE1 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
RESE2 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
GRPVL Grouping Value for Personnel Assignments CHAR 4 0 PCCE_GPVAL
QCTYP Time quota compensation method CHAR 4 0 T556U TIM_QCTYP
STYPE Quota type (attendance/absence quota) CHAR 1 0 QTYPE
WAERS Currency Key CUKY 5 0 TCURC WAERS
QTYPE Absence Quota Type NUMC 2 0 * ABWKO
SRULE Rule for deduction sequence of quotas NUMC 3 0 T556R DEDRG
NUMBR Quota Number Compensated DEC 10 5 PTM_QSETTLED
AMONT Amount for time quota compensation CURR 9 2 ABBTR
WGTYP Wage Type CHAR 4 0 T512Z LGART
QUONR Counter for time quotas NUMC 20 0 PTM_QUONR
DOCSY Logical system for document (personnel time) CHAR 10 0 * PTM_DOCSY
DOCNR Document number for time data NUMC 20 0 PTM_DOCNR
NOPAY Do Not Account CHAR 1 0 NOLCOMP

PT0416 foreign key relationships

Table Field Check Table Check Field
0 PT0416 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
0 PT0416 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
1 PT0416 PREAS T530E Reasons for Changes MANDT
1 PT0416 PREAS T530E Reasons for Changes INFTY
1 PT0416 PREAS T530E Reasons for Changes PREAS
0 PT0416 QCTYP T556U Attendance/Absence Quota Compensation Types MANDT
0 PT0416 QCTYP T556U Attendance/Absence Quota Compensation Types MOPGK
0 PT0416 QCTYP T556U Attendance/Absence Quota Compensation Types MOZKO
1 PT0416 SRULE T556R Rules for Deduction Sequence for Absence Quotas MANDT
1 PT0416 SRULE T556R Rules for Deduction Sequence for Absence Quotas MOPGK
1 PT0416 SRULE T556R Rules for Deduction Sequence for Absence Quotas MOZKO
1 PT0416 SRULE T556R Rules for Deduction Sequence for Absence Quotas ENDDA
0 PT0416 WAERS TCURC Currency Codes MANDT
0 PT0416 WAERS TCURC Currency Codes WAERS
1 PT0416 WGTYP T512Z Permissibility of Wage Types per Infotype MANDT
1 PT0416 WGTYP T512Z Permissibility of Wage Types per Infotype INFTY
1 PT0416 WGTYP T512Z Permissibility of Wage Types per Infotype MOLGA
1 PT0416 WGTYP T512Z Permissibility of Wage Types per Infotype LGART
1 PT0416 WGTYP T512Z Permissibility of Wage Types per Infotype ENDDA