SAP ABAP Table PTREQ_REQUEST_STRUC_FLAT (Structure of Request Versions)
Hierarchy
☛
EA-HRRXX (Software Component) Sub component EA-HRRXX of EA-HR
⤷ PT (Application Component) Personnel Time Management
⤷ PAOC_TIM_REQUEST (Package) Application Database and Application Objects
⤷ PT (Application Component) Personnel Time Management
⤷ PAOC_TIM_REQUEST (Package) Application Database and Application Objects
Basic Data
Table Category | INTTAB | Structure |
Structure | PTREQ_REQUEST_STRUC_FLAT | Table Relationship Diagram |
Short Description | Structure of Request Versions |
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 | REQUEST_ID | TIM_REQ_ID | SYSUUID_C | CHAR | 32 | 0 | Document ID | ||
2 | FIRST_SUBM_DATE | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
3 | FIRST_SUBM_TIME | TIME | CHAR6 | CHAR | 6 | 0 | Time in CHAR Format | ||
4 | VERSION | PTREQ_ATTRIBS_STRUC_FLAT | STRU | 0 | 0 | ||||
5 | VERSION_NO | TIM_REQ_VERSION | INT4 | INT4 | 10 | 0 | Document Version | ||
6 | STATUS | TIM_REQ_STATUS | TIM_REQ_STATUS | CHAR | 12 | 0 | Document Status | ||
7 | RESPONSIBLE | PTREQ_ACTOR_STRUC_FLAT | STRU | 0 | 0 | ||||
8 | ACTOR_ID | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
9 | ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | CHAR | 1 | 0 | Actor's Role | ||
10 | USER | SYSID | CHAR30 | CHAR | 30 | 0 | Communication Identification/Number | ||
11 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | ||
12 | PERSONNEL_SUBAREA | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | ||
13 | PERSA | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | ||
14 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | ||
15 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | ||
16 | OBJID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
17 | NAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
18 | SNAME | SMNAM | CHAR30 | CHAR | 30 | 0 | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
19 | MOLGA | MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | ||
20 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | ||
21 | INTERNET_ADDRESS | COMM_ID_LONG | COMM_ID_LONG | CHAR | 241 | 0 | Communication: Long Identification/Number | ||
22 | CONTROLRECORD_STATE | VWSTA | VWSTA | NUMC | 1 | 0 | Status of Control Record | ||
23 | CONTROLRECORD_DATE | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
24 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
25 | FST_NAME_K | P22J_FNAMK | P22J_NAME | CHAR | 24 | 0 | First name (Katakana) | ||
26 | LST_NAME_K | P22J_LNAMK | P22J_NAME | CHAR | 24 | 0 | Last Name (Katakana) | ||
27 | FST_NAME_R | P22J_FNAMR | P22J_NAME | CHAR | 24 | 0 | First name (Romaji) | ||
28 | LST_NAME_R | P22J_LNAMR | P22J_NAME | CHAR | 24 | 0 | Last name (Romaji) | ||
29 | BIRTHNME_K | P22J_NABIK | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Katakana) | ||
30 | BIRTHNME_R | P22J_NABIR | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Romaji) | ||
31 | NICKNAME_K | P22J_NICKK | P22J_NAME | CHAR | 24 | 0 | Nickname (Katakana) | ||
32 | NICKNAME_R | P22J_NICKR | P22J_NAME | CHAR | 24 | 0 | Nickname (Romaji) | ||
33 | OWNER | PTREQ_ACTOR_STRUC_FLAT | STRU | 0 | 0 | ||||
34 | ACTOR_ID | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
35 | ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | CHAR | 1 | 0 | Actor's Role | ||
36 | USER | SYSID | CHAR30 | CHAR | 30 | 0 | Communication Identification/Number | ||
37 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | ||
38 | PERSONNEL_SUBAREA | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | ||
39 | PERSA | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | ||
40 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | ||
41 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | ||
42 | OBJID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
43 | NAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
44 | SNAME | SMNAM | CHAR30 | CHAR | 30 | 0 | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
45 | MOLGA | MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | ||
46 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | ||
47 | INTERNET_ADDRESS | COMM_ID_LONG | COMM_ID_LONG | CHAR | 241 | 0 | Communication: Long Identification/Number | ||
48 | CONTROLRECORD_STATE | VWSTA | VWSTA | NUMC | 1 | 0 | Status of Control Record | ||
49 | CONTROLRECORD_DATE | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
50 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
51 | FST_NAME_K | P22J_FNAMK | P22J_NAME | CHAR | 24 | 0 | First name (Katakana) | ||
52 | LST_NAME_K | P22J_LNAMK | P22J_NAME | CHAR | 24 | 0 | Last Name (Katakana) | ||
53 | FST_NAME_R | P22J_FNAMR | P22J_NAME | CHAR | 24 | 0 | First name (Romaji) | ||
54 | LST_NAME_R | P22J_LNAMR | P22J_NAME | CHAR | 24 | 0 | Last name (Romaji) | ||
55 | BIRTHNME_K | P22J_NABIK | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Katakana) | ||
56 | BIRTHNME_R | P22J_NABIR | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Romaji) | ||
57 | NICKNAME_K | P22J_NICKK | P22J_NAME | CHAR | 24 | 0 | Nickname (Katakana) | ||
58 | NICKNAME_R | P22J_NICKR | P22J_NAME | CHAR | 24 | 0 | Nickname (Romaji) | ||
59 | NEXT_PROCESSOR | PTREQ_ACTOR_STRUC_FLAT | STRU | 0 | 0 | ||||
60 | ACTOR_ID | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
61 | ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | CHAR | 1 | 0 | Actor's Role | ||
62 | USER | SYSID | CHAR30 | CHAR | 30 | 0 | Communication Identification/Number | ||
63 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | ||
64 | PERSONNEL_SUBAREA | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | ||
65 | PERSA | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | ||
66 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | ||
67 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | ||
68 | OBJID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
69 | NAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
70 | SNAME | SMNAM | CHAR30 | CHAR | 30 | 0 | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
71 | MOLGA | MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | ||
72 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | ||
73 | INTERNET_ADDRESS | COMM_ID_LONG | COMM_ID_LONG | CHAR | 241 | 0 | Communication: Long Identification/Number | ||
74 | CONTROLRECORD_STATE | VWSTA | VWSTA | NUMC | 1 | 0 | Status of Control Record | ||
75 | CONTROLRECORD_DATE | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
76 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
77 | FST_NAME_K | P22J_FNAMK | P22J_NAME | CHAR | 24 | 0 | First name (Katakana) | ||
78 | LST_NAME_K | P22J_LNAMK | P22J_NAME | CHAR | 24 | 0 | Last Name (Katakana) | ||
79 | FST_NAME_R | P22J_FNAMR | P22J_NAME | CHAR | 24 | 0 | First name (Romaji) | ||
80 | LST_NAME_R | P22J_LNAMR | P22J_NAME | CHAR | 24 | 0 | Last name (Romaji) | ||
81 | BIRTHNME_K | P22J_NABIK | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Katakana) | ||
82 | BIRTHNME_R | P22J_NABIR | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Romaji) | ||
83 | NICKNAME_K | P22J_NICKK | P22J_NAME | CHAR | 24 | 0 | Nickname (Katakana) | ||
84 | NICKNAME_R | P22J_NICKR | P22J_NAME | CHAR | 24 | 0 | Nickname (Romaji) | ||
85 | INITIATOR | PTREQ_ACTOR_STRUC_FLAT | STRU | 0 | 0 | ||||
86 | ACTOR_ID | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
87 | ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | CHAR | 1 | 0 | Actor's Role | ||
88 | USER | SYSID | CHAR30 | CHAR | 30 | 0 | Communication Identification/Number | ||
89 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | ||
90 | PERSONNEL_SUBAREA | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | ||
91 | PERSA | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | ||
92 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | ||
93 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | ||
94 | OBJID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
95 | NAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
96 | SNAME | SMNAM | CHAR30 | CHAR | 30 | 0 | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
97 | MOLGA | MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | ||
98 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | ||
99 | INTERNET_ADDRESS | COMM_ID_LONG | COMM_ID_LONG | CHAR | 241 | 0 | Communication: Long Identification/Number | ||
100 | CONTROLRECORD_STATE | VWSTA | VWSTA | NUMC | 1 | 0 | Status of Control Record | ||
101 | CONTROLRECORD_DATE | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
102 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
103 | FST_NAME_K | P22J_FNAMK | P22J_NAME | CHAR | 24 | 0 | First name (Katakana) | ||
104 | LST_NAME_K | P22J_LNAMK | P22J_NAME | CHAR | 24 | 0 | Last Name (Katakana) | ||
105 | FST_NAME_R | P22J_FNAMR | P22J_NAME | CHAR | 24 | 0 | First name (Romaji) | ||
106 | LST_NAME_R | P22J_LNAMR | P22J_NAME | CHAR | 24 | 0 | Last name (Romaji) | ||
107 | BIRTHNME_K | P22J_NABIK | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Katakana) | ||
108 | BIRTHNME_R | P22J_NABIR | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Romaji) | ||
109 | NICKNAME_K | P22J_NICKK | P22J_NAME | CHAR | 24 | 0 | Nickname (Katakana) | ||
110 | NICKNAME_R | P22J_NICKR | P22J_NAME | CHAR | 24 | 0 | Nickname (Romaji) | ||
111 | ITEM_TAB | PTREQ_ITEMS_TAB_FLAT | TTYP | 0 | 0 | ||||
112 | WORKITEM_ID | SWW_WIID | SWW_WIID | NUMC | 12 | 0 | Work item ID | ||
113 | ADMIN_CURR_NOTICE | TIM_REQ_NOTICE | STRING | STRG | 0 | 0 | Note for Request | ||
114 | CURR_NOTICE | TIM_REQ_NOTICE | STRING | STRG | 0 | 0 | Note for Request | ||
115 | PAST_NOTICE | TIM_REQ_NOTICE | STRING | STRG | 0 | 0 | Note for Request | ||
116 | APPROVAL | PT_ARQ_APPROVAL_FLAG | BOOLE | CHAR | 1 | 0 | ESS Leave Request: Request Is Subject to Approval | ||
117 | APPROVAL_PROCESS | PTREQ_PROCESS | PTARQ_PROCESS | CHAR | 1 | 0 | ESS: Process for Processing | ||
118 | MOD_TIMESTAMP | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
119 | MOD_TIMEZONE | TIMEZONE | TZNZONE | CHAR | 6 | 0 | Time Zone |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 100 |