SAP table PTARQ_UIA_REQUEST (Leave Request: Entry in Request List)

Field Description Data Type Length Decimals Checktable Data Element
REQUEST_ID Document ID CHAR 32 0 TIM_REQ_ID
FIRST_SUBM_DATE Date DATS 8 0 DATUM
FIRST_SUBM_TIME Field of type TIMS TIMS 6 0 TIMS
OWNER STRU 0 0 PTREQ_ACTOR_STRUC_FLAT
ACTOR_ID GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
ACTOR_TYPE Actor's Role CHAR 1 0 TIM_REQ_ACTOR_TYPE
G Group
O PD Object
P Personnel Number
USER Communication Identification/Number CHAR 30 0 SYSID
PLVAR Plan Version CHAR 2 0 * PLVAR
PERSONNEL_SUBAREA Personnel Subarea CHAR 4 0 * BTRTL
PERSA Personnel Area CHAR 4 0 * PERSA
PERNR Personnel Number NUMC 8 0 * PERSNO
OTYPE Object Type CHAR 2 0 * OTYPE
OBJID Object ID NUMC 8 0 OBJEKTID
NAME Formatted Name of Employee or Applicant CHAR 40 0 EMNAM
SNAME Employee's Name (Sortable by LAST NAME FIRST NAME) CHAR 30 0 SMNAM
MOLGA HCM Localization CHAR 2 0 * MOLGA
KOSTL Cost Center CHAR 10 0 * KOSTL
INTERNET_ADDRESS Communication: Long Identification/Number CHAR 241 0 COMM_ID_LONG
CONTROLRECORD_STATE Status of Control Record NUMC 1 0 VWSTA
0 New
1 Released for payroll
2 Payroll correction
3 Exit payroll
4 Check payroll results
9 Deleted
CONTROLRECORD_DATE End Date DATS 8 0 ENDDA
BUKRS Company Code CHAR 4 0 BUKRS
FST_NAME_K First name (Katakana) CHAR 24 0 P22J_FNAMK
LST_NAME_K Last Name (Katakana) CHAR 24 0 P22J_LNAMK
FST_NAME_R First name (Romaji) CHAR 24 0 P22J_FNAMR
LST_NAME_R Last name (Romaji) CHAR 24 0 P22J_LNAMR
BIRTHNME_K Name of Birth (Katakana) CHAR 24 0 P22J_NABIK
BIRTHNME_R Name of Birth (Romaji) CHAR 24 0 P22J_NABIR
NICKNAME_K Nickname (Katakana) CHAR 24 0 P22J_NICKK
NICKNAME_R Nickname (Romaji) CHAR 24 0 P22J_NICKR
NEXT_PROCESSOR STRU 0 0 PTREQ_ACTOR_STRUC_FLAT
ACTOR_ID GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
ACTOR_TYPE Actor's Role CHAR 1 0 TIM_REQ_ACTOR_TYPE
G Group
O PD Object
P Personnel Number
USER Communication Identification/Number CHAR 30 0 SYSID
PLVAR Plan Version CHAR 2 0 * PLVAR
PERSONNEL_SUBAREA Personnel Subarea CHAR 4 0 * BTRTL
PERSA Personnel Area CHAR 4 0 * PERSA
PERNR Personnel Number NUMC 8 0 * PERSNO
OTYPE Object Type CHAR 2 0 * OTYPE
OBJID Object ID NUMC 8 0 OBJEKTID
NAME Formatted Name of Employee or Applicant CHAR 40 0 EMNAM
SNAME Employee's Name (Sortable by LAST NAME FIRST NAME) CHAR 30 0 SMNAM
MOLGA HCM Localization CHAR 2 0 * MOLGA
KOSTL Cost Center CHAR 10 0 * KOSTL
INTERNET_ADDRESS Communication: Long Identification/Number CHAR 241 0 COMM_ID_LONG
CONTROLRECORD_STATE Status of Control Record NUMC 1 0 VWSTA
0 New
1 Released for payroll
2 Payroll correction
3 Exit payroll
4 Check payroll results
9 Deleted
CONTROLRECORD_DATE End Date DATS 8 0 ENDDA
BUKRS Company Code CHAR 4 0 BUKRS
FST_NAME_K First name (Katakana) CHAR 24 0 P22J_FNAMK
LST_NAME_K Last Name (Katakana) CHAR 24 0 P22J_LNAMK
FST_NAME_R First name (Romaji) CHAR 24 0 P22J_FNAMR
LST_NAME_R Last name (Romaji) CHAR 24 0 P22J_LNAMR
BIRTHNME_K Name of Birth (Katakana) CHAR 24 0 P22J_NABIK
BIRTHNME_R Name of Birth (Romaji) CHAR 24 0 P22J_NABIR
NICKNAME_K Nickname (Katakana) CHAR 24 0 P22J_NICKK
NICKNAME_R Nickname (Romaji) CHAR 24 0 P22J_NICKR
STATUS Document Status CHAR 12 0 TIM_REQ_STATUS
APPROVED Approved
DELETED Deleted from the Database
DRAFT Raw Version
ERROR Has Errors
NEW New
POSTED Posted
REJECTED Rejected
SENT Sent
STOPPED Stopped Automatically
WITHDRAWN Withdrawn
STATUS_TEXT Short Text for Fixed Values CHAR 60 0 VAL_TEXT
CURR_NOTICE Note for Request STRG 0 0 TIM_REQ_NOTICE
PAST_NOTICE Note for Request STRG 0 0 TIM_REQ_NOTICE
REQUEST_OR_ATTABS Switch: Request or Attendance/Absence CHAR 1 0 PT_ARQ_REQUEST_OR_ATT_ABS
A Absence
P Attendance
R Request
INS_ITEM STRU 0 0 PTARQ_UIA_ITEM
ITEM_ID GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
OPERATION Infotype operation CHAR 20 0 IOPER
INFOTYPE Infotype CHAR 4 0 INFTY
BEGIN_TIME Start Time TIMS 6 0 BEGTI
END_TIME End Time TIMS 6 0 ENDTI
ATTABS_HOURS Absence hours DEC 7 2 ABSTD
PERNR Personnel Number NUMC 8 0 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
VTKEN Previous Day Indicator CHAR 1 0 VTKEN
ABWTG Attendance and Absence Days DEC 6 2 ABWTG
KALTG Calendar days DEC 6 2 KALTG
HRSIF Set number of hours CHAR 1 0 HRS_INPFL
ALLDF Record is for Full Day CHAR 1 0 ALLDF
ABRTG Payroll days DEC 6 2 ABRTG
ABRST Payroll hours DEC 7 2 ABRST
UMSKD Code for description of illness CHAR 6 0 UMSKD
UMSCH Description of illness CHAR 20 0 UMSCH
OBJECT_TYPE Object Type CHAR 2 0 OTYPE
OBJ_ID Object ID NUMC 8 0 OBJEKTID
COMP_CODE Company code CHAR 4 0 PW_BUKRS
COSTCENTER Cost Center CHAR 10 0 KOSTL
ORDER_ID Order Number CHAR 12 0 AUFNR
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
LGART Wage Type CHAR 4 0 LGART
VERSL Overtime Compensation Type CHAR 1 0 VRSCH
EXBEL External Document Number CHAR 8 0 EXBEL
WTART Work tax area CHAR 4 0 WTART
FAPRS Evaluation Type for Attendances/Absences CHAR 2 0 FAPRS
KEPAU No break CHAR 1 0 TIM_KEPAU
EXPAU Breaks Specified Explicitly CHAR 1 0 TIM_EXPAU
PBEG1 Start of Break TIMS 6 0 PDBEG
PEND1 End of Break TIMS 6 0 PDEND
PBEZ1 Paid Break Period DEC 4 2 PDBEZ
PUNB1 Unpaid Break Period DEC 4 2 PDUNB
PBEG2 Start of Break TIMS 6 0 PDBEG
PEND2 End of Break TIMS 6 0 PDEND
PBEZ2 Paid Break Period DEC 4 2 PDBEZ
PUNB2 Unpaid Break Period DEC 4 2 PDUNB
ANRTG Days credited for continued pay DEC 6 2 ANRTG
LFZED End of continued pay DATS 8 0 LFZED
KRGED End of sick pay DATS 8 0 KRGED
KBBEG Certified start of sickness DATS 8 0 KBBEG
RMDDA Date on which illness was confirmed DATS 8 0 RMDDA
KENN1 Indicator for Subsequent Illness DEC 2 0 KENN1
KENN2 Indicator for repeated illness DEC 2 0 KENN2
CUSTOMER01 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER02 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER03 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER04 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER05 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER06 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER07 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER08 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER09 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER10 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
SUBTYPE_DESCRIPTION Type of Leave CHAR 40 0 PTARQ_UIA_AWART_TEXT
DEL_ITEM STRU 0 0 PTARQ_UIA_ITEM
ITEM_ID GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
OPERATION Infotype operation CHAR 20 0 IOPER
INFOTYPE Infotype CHAR 4 0 INFTY
BEGIN_TIME Start Time TIMS 6 0 BEGTI
END_TIME End Time TIMS 6 0 ENDTI
ATTABS_HOURS Absence hours DEC 7 2 ABSTD
PERNR Personnel Number NUMC 8 0 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
VTKEN Previous Day Indicator CHAR 1 0 VTKEN
ABWTG Attendance and Absence Days DEC 6 2 ABWTG
KALTG Calendar days DEC 6 2 KALTG
HRSIF Set number of hours CHAR 1 0 HRS_INPFL
ALLDF Record is for Full Day CHAR 1 0 ALLDF
ABRTG Payroll days DEC 6 2 ABRTG
ABRST Payroll hours DEC 7 2 ABRST
UMSKD Code for description of illness CHAR 6 0 UMSKD
UMSCH Description of illness CHAR 20 0 UMSCH
OBJECT_TYPE Object Type CHAR 2 0 OTYPE
OBJ_ID Object ID NUMC 8 0 OBJEKTID
COMP_CODE Company code CHAR 4 0 PW_BUKRS
COSTCENTER Cost Center CHAR 10 0 KOSTL
ORDER_ID Order Number CHAR 12 0 AUFNR
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
LGART Wage Type CHAR 4 0 LGART
VERSL Overtime Compensation Type CHAR 1 0 VRSCH
EXBEL External Document Number CHAR 8 0 EXBEL
WTART Work tax area CHAR 4 0 WTART
FAPRS Evaluation Type for Attendances/Absences CHAR 2 0 FAPRS
KEPAU No break CHAR 1 0 TIM_KEPAU
EXPAU Breaks Specified Explicitly CHAR 1 0 TIM_EXPAU
PBEG1 Start of Break TIMS 6 0 PDBEG
PEND1 End of Break TIMS 6 0 PDEND
PBEZ1 Paid Break Period DEC 4 2 PDBEZ
PUNB1 Unpaid Break Period DEC 4 2 PDUNB
PBEG2 Start of Break TIMS 6 0 PDBEG
PEND2 End of Break TIMS 6 0 PDEND
PBEZ2 Paid Break Period DEC 4 2 PDBEZ
PUNB2 Unpaid Break Period DEC 4 2 PDUNB
ANRTG Days credited for continued pay DEC 6 2 ANRTG
LFZED End of continued pay DATS 8 0 LFZED
KRGED End of sick pay DATS 8 0 KRGED
KBBEG Certified start of sickness DATS 8 0 KBBEG
RMDDA Date on which illness was confirmed DATS 8 0 RMDDA
KENN1 Indicator for Subsequent Illness DEC 2 0 KENN1
KENN2 Indicator for repeated illness DEC 2 0 KENN2
CUSTOMER01 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER02 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER03 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER04 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER05 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER06 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER07 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER08 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER09 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
CUSTOMER10 Customer Field CHAR 20 0 PTREQ_CUSTOMER_FIELD
SUBTYPE_DESCRIPTION Type of Leave CHAR 40 0 PTARQ_UIA_AWART_TEXT
DEDUCTION TTYP 0 0 PTARQ_UIA_DEDUCT_TAB