1. Home
  2. Resources
  3. SAP Tables
  4. PTARQ_UIA_REQUEST - Leave Request: Entry in Request List

SAP Table PTARQ_UIA_REQUEST

Leave Request: Entry in Request List

PTARQ_UIA_REQUEST (Leave Request: Entry in Request List) 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 PTARQ_UIA_REQUEST to other SAP tables.

Source: PTARQ_UIA_REQUEST (Leave Request: Entry in Request List)

PTARQ_UIA_REQUEST table fields

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