SAP ABAP Table PTARQ_UIA_REQLIST_STRUC (UIA List of Requests)
Hierarchy
☛
EA-HRRXX (Software Component) Sub component EA-HRRXX of EA-HR
⤷ PT (Application Component) Personnel Time Management
⤷ PAOC_TIM_ABSENCE_REQ_UIA (Package) Leave Request: UIA Layer
⤷ PT (Application Component) Personnel Time Management
⤷ PAOC_TIM_ABSENCE_REQ_UIA (Package) Leave Request: UIA Layer
Basic Data
Table Category | INTTAB | Structure |
Structure | PTARQ_UIA_REQLIST_STRUC | Table Relationship Diagram |
Short Description | UIA List of Requests |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Leave Request: Header of Request | |||||
2 | REQUEST_ID | TIM_REQ_ID | SYSUUID_C | CHAR | 32 | 0 | Document ID | ||
3 | FIRST_SUBM_DATE | DATUM | DATUM | DATS | 8 | 0 | Date | ||
4 | FIRST_SUBM_TIME | TIMS | TIME | TIMS | 6 | 0 | Field of type TIMS | ||
5 | OWNER | PTREQ_ACTOR_STRUC_FLAT | STRU | 0 | 0 | ||||
6 | ACTOR_ID | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
7 | ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | CHAR | 1 | 0 | Actor's Role | ||
8 | USER | SYSID | CHAR30 | CHAR | 30 | 0 | Communication Identification/Number | ||
9 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | * | |
10 | PERSONNEL_SUBAREA | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | * | |
11 | PERSA | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | * | |
12 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | * | |
13 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
14 | OBJID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
15 | NAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
16 | SNAME | SMNAM | CHAR30 | CHAR | 30 | 0 | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
17 | MOLGA | MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | * | |
18 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
19 | INTERNET_ADDRESS | COMM_ID_LONG | COMM_ID_LONG | CHAR | 241 | 0 | Communication: Long Identification/Number | ||
20 | CONTROLRECORD_STATE | VWSTA | VWSTA | NUMC | 1 | 0 | Status of Control Record | ||
21 | CONTROLRECORD_DATE | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
22 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
23 | FST_NAME_K | P22J_FNAMK | P22J_NAME | CHAR | 24 | 0 | First name (Katakana) | ||
24 | LST_NAME_K | P22J_LNAMK | P22J_NAME | CHAR | 24 | 0 | Last Name (Katakana) | ||
25 | FST_NAME_R | P22J_FNAMR | P22J_NAME | CHAR | 24 | 0 | First name (Romaji) | ||
26 | LST_NAME_R | P22J_LNAMR | P22J_NAME | CHAR | 24 | 0 | Last name (Romaji) | ||
27 | BIRTHNME_K | P22J_NABIK | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Katakana) | ||
28 | BIRTHNME_R | P22J_NABIR | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Romaji) | ||
29 | NICKNAME_K | P22J_NICKK | P22J_NAME | CHAR | 24 | 0 | Nickname (Katakana) | ||
30 | NICKNAME_R | P22J_NICKR | P22J_NAME | CHAR | 24 | 0 | Nickname (Romaji) | ||
31 | NEXT_PROCESSOR | PTREQ_ACTOR_STRUC_FLAT | STRU | 0 | 0 | ||||
32 | ACTOR_ID | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
33 | ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | CHAR | 1 | 0 | Actor's Role | ||
34 | USER | SYSID | CHAR30 | CHAR | 30 | 0 | Communication Identification/Number | ||
35 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | * | |
36 | PERSONNEL_SUBAREA | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | * | |
37 | PERSA | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | * | |
38 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | * | |
39 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
40 | OBJID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
41 | NAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
42 | SNAME | SMNAM | CHAR30 | CHAR | 30 | 0 | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
43 | MOLGA | MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | * | |
44 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
45 | INTERNET_ADDRESS | COMM_ID_LONG | COMM_ID_LONG | CHAR | 241 | 0 | Communication: Long Identification/Number | ||
46 | CONTROLRECORD_STATE | VWSTA | VWSTA | NUMC | 1 | 0 | Status of Control Record | ||
47 | CONTROLRECORD_DATE | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
48 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
49 | FST_NAME_K | P22J_FNAMK | P22J_NAME | CHAR | 24 | 0 | First name (Katakana) | ||
50 | LST_NAME_K | P22J_LNAMK | P22J_NAME | CHAR | 24 | 0 | Last Name (Katakana) | ||
51 | FST_NAME_R | P22J_FNAMR | P22J_NAME | CHAR | 24 | 0 | First name (Romaji) | ||
52 | LST_NAME_R | P22J_LNAMR | P22J_NAME | CHAR | 24 | 0 | Last name (Romaji) | ||
53 | BIRTHNME_K | P22J_NABIK | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Katakana) | ||
54 | BIRTHNME_R | P22J_NABIR | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Romaji) | ||
55 | NICKNAME_K | P22J_NICKK | P22J_NAME | CHAR | 24 | 0 | Nickname (Katakana) | ||
56 | NICKNAME_R | P22J_NICKR | P22J_NAME | CHAR | 24 | 0 | Nickname (Romaji) | ||
57 | STATUS | TIM_REQ_STATUS | TIM_REQ_STATUS | CHAR | 12 | 0 | Document Status | ||
58 | STATUS_TEXT | VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Short Text for Fixed Values | ||
59 | CURR_NOTICE | TIM_REQ_NOTICE | STRING | STRG | 0 | 0 | Note for Request | ||
60 | PAST_NOTICE | TIM_REQ_NOTICE | STRING | STRG | 0 | 0 | Note for Request | ||
61 | REQUEST_OR_ATTABS | PT_ARQ_REQUEST_OR_ATT_ABS | PT_ARQ_REQUEST_OR_ATT_ABS | CHAR | 1 | 0 | Switch: Request or Attendance/Absence | ||
62 | .INCLUDE | 0 | 0 | Request Item for Attendances/Absences | |||||
63 | ITEM_ID | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
64 | OPERATION | IOPER | FCODE | CHAR | 20 | 0 | Infotype operation | ||
65 | INFOTYPE | INFTY | INFOTYP | CHAR | 4 | 0 | Infotype | ||
66 | BEGIN_TIME | BEGTI | UZEIT | TIMS | 6 | 0 | Start Time | ||
67 | END_TIME | ENDTI | UZEIT | TIMS | 6 | 0 | End Time | ||
68 | ATTABS_HOURS | ABSTD | JRSTD | DEC | 7 | 2 | Absence hours | ||
69 | .INCLUDE | 0 | 0 | Key for HR Master Data | |||||
70 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | PA0003 | |
71 | SUBTY | SUBTY | SUBTY | CHAR | 4 | 0 | Subtype | ||
72 | OBJPS | OBJPS | OBJPS | CHAR | 2 | 0 | Object Identification | ||
73 | SPRPS | SPRPS | SPRPS | CHAR | 1 | 0 | Lock Indicator for HR Master Data Record | ||
74 | ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
75 | BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
76 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
77 | .INCLUDE | 0 | 0 | Leave Request: Time Data | |||||
78 | VTKEN | VTKEN | XFELD | CHAR | 1 | 0 | Previous Day Indicator | ||
79 | ABWTG | ABWTG | TAGE4_2 | DEC | 6 | 2 | Attendance and Absence Days | ||
80 | KALTG | KALTG | TAGE4_2 | DEC | 6 | 2 | Calendar days | ||
81 | HRSIF | HRS_INPFL | XFELD | CHAR | 1 | 0 | Set number of hours | ||
82 | ALLDF | ALLDF | XFELD | CHAR | 1 | 0 | Record is for Full Day | ||
83 | ABRTG | ABRTG | TAGE4_2 | DEC | 6 | 2 | Payroll days | ||
84 | ABRST | ABRST | JRSTD | DEC | 7 | 2 | Payroll hours | ||
85 | UMSKD | UMSKD | CHAR6 | CHAR | 6 | 0 | Code for description of illness | T572B | |
86 | UMSCH | UMSCH | TEXT20 | CHAR | 20 | 0 | Description of illness | ||
87 | .INCLUDE | 0 | 0 | Leave Request: Additional Fields for Attendances/Absences | |||||
88 | OBJECT_TYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
89 | OBJ_ID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
90 | COMP_CODE | PW_BUKRS | BUKRS | CHAR | 4 | 0 | Company code | * | |
91 | COSTCENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
92 | ORDER_ID | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
93 | WBS_ELEMENT | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
94 | .INCLUDE | 0 | 0 | Leave Request: Attendance Data | |||||
95 | LGART | LGART | LGART | CHAR | 4 | 0 | Wage Type | * | |
96 | VERSL | VRSCH | VRSCH | CHAR | 1 | 0 | Overtime Compensation Type | * | |
97 | EXBEL | EXBEL | CHAR08 | CHAR | 8 | 0 | External Document Number | ||
98 | WTART | WTART | WRKAR | CHAR | 4 | 0 | Work tax area | * | |
99 | FAPRS | FAPRS | FAPRS | CHAR | 2 | 0 | Evaluation Type for Attendances/Absences | ||
100 | KEPAU | TIM_KEPAU | XFELD | CHAR | 1 | 0 | No break | ||
101 | EXPAU | TIM_EXPAU | XFELD | CHAR | 1 | 0 | Breaks Specified Explicitly | ||
102 | PBEG1 | PDBEG | UZEIT | TIMS | 6 | 0 | Start of Break | ||
103 | PEND1 | PDEND | UZEIT | TIMS | 6 | 0 | End of Break | ||
104 | PBEZ1 | PDBEZ | DEC2_2 | DEC | 4 | 2 | Paid Break Period | ||
105 | PUNB1 | PDUNB | DEC2_2 | DEC | 4 | 2 | Unpaid Break Period | ||
106 | PBEG2 | PDBEG | UZEIT | TIMS | 6 | 0 | Start of Break | ||
107 | PEND2 | PDEND | UZEIT | TIMS | 6 | 0 | End of Break | ||
108 | PBEZ2 | PDBEZ | DEC2_2 | DEC | 4 | 2 | Paid Break Period | ||
109 | PUNB2 | PDUNB | DEC2_2 | DEC | 4 | 2 | Unpaid Break Period | ||
110 | .INCLUDE | 0 | 0 | Leave Request: Continued Pay for Illness | |||||
111 | ANRTG | ANRTG | TAGE4_2 | DEC | 6 | 2 | Days credited for continued pay | ||
112 | LFZED | LFZED | DATUM | DATS | 8 | 0 | End of continued pay | ||
113 | KRGED | KRGED | DATUM | DATS | 8 | 0 | End of sick pay | ||
114 | KBBEG | KBBEG | DATUM | DATS | 8 | 0 | Certified start of sickness | ||
115 | RMDDA | RMDDA | DATUM | DATS | 8 | 0 | Date on which illness was confirmed | ||
116 | KENN1 | KENN1 | KNZAU | DEC | 2 | 0 | Indicator for Subsequent Illness | ||
117 | KENN2 | KENN2 | KNZAU | DEC | 2 | 0 | Indicator for repeated illness | ||
118 | .INCLUDE | 0 | 0 | Database of Requests: Customer Fields | |||||
119 | CUSTOMER01 | PTREQ_CUSTOMER_FIELD | PTREQ_CUSTOMER_FIELD | CHAR | 20 | 0 | Customer Field | ||
120 | CUSTOMER02 | PTREQ_CUSTOMER_FIELD | PTREQ_CUSTOMER_FIELD | CHAR | 20 | 0 | Customer Field | ||
121 | CUSTOMER03 | PTREQ_CUSTOMER_FIELD | PTREQ_CUSTOMER_FIELD | CHAR | 20 | 0 | Customer Field | ||
122 | CUSTOMER04 | PTREQ_CUSTOMER_FIELD | PTREQ_CUSTOMER_FIELD | CHAR | 20 | 0 | Customer Field | ||
123 | CUSTOMER05 | PTREQ_CUSTOMER_FIELD | PTREQ_CUSTOMER_FIELD | CHAR | 20 | 0 | Customer Field | ||
124 | CUSTOMER06 | PTREQ_CUSTOMER_FIELD | PTREQ_CUSTOMER_FIELD | CHAR | 20 | 0 | Customer Field | ||
125 | CUSTOMER07 | PTREQ_CUSTOMER_FIELD | PTREQ_CUSTOMER_FIELD | CHAR | 20 | 0 | Customer Field | ||
126 | CUSTOMER08 | PTREQ_CUSTOMER_FIELD | PTREQ_CUSTOMER_FIELD | CHAR | 20 | 0 | Customer Field | ||
127 | CUSTOMER09 | PTREQ_CUSTOMER_FIELD | PTREQ_CUSTOMER_FIELD | CHAR | 20 | 0 | Customer Field | ||
128 | CUSTOMER10 | PTREQ_CUSTOMER_FIELD | PTREQ_CUSTOMER_FIELD | CHAR | 20 | 0 | Customer Field | ||
129 | SUBTYPE_DESCRIPTION | SBTTX | TEXT40 | CHAR | 40 | 0 | Name of Subtype | ||
130 | DEDUCTION | CHAR40 | CHAR40 | CHAR | 40 | 0 | Character field of length 40 | ||
131 | DEDUCTION_TOOLTIP | CHAR64 | CHAR64 | CHAR | 64 | 0 | Character field, length 64 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PTARQ_UIA_REQLIST_STRUC | PERNR | PA0003 | PERNR | |||
2 | PTARQ_UIA_REQLIST_STRUC | UMSKD | T572B | DESCD |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |