SAP ABAP Table PTREQ_EMAIL_REQUESTS_STRUCT (Structure for E-Mail Reports)
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_EMAIL_REQUESTS_STRUCT | Table Relationship Diagram |
Short Description | Structure for E-Mail Reports |
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 | .INCLUDE | 0 | 0 | Structure of Request Attributes | |||||
3 | VERSION_NO | TIM_REQ_VERSION | INT4 | INT4 | 10 | 0 | Document Version | ||
4 | STATUS | TIM_REQ_STATUS | TIM_REQ_STATUS | CHAR | 12 | 0 | Document Status | ||
5 | RESPONSIBLE | 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 | OWNER | 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 | NEXT_PROCESSOR | PTREQ_ACTOR_STRUC_FLAT | STRU | 0 | 0 | ||||
58 | ACTOR_ID | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
59 | ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | CHAR | 1 | 0 | Actor's Role | ||
60 | USER | SYSID | CHAR30 | CHAR | 30 | 0 | Communication Identification/Number | ||
61 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | * | |
62 | PERSONNEL_SUBAREA | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | * | |
63 | PERSA | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | * | |
64 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | * | |
65 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
66 | OBJID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
67 | NAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
68 | SNAME | SMNAM | CHAR30 | CHAR | 30 | 0 | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
69 | MOLGA | MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | * | |
70 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
71 | INTERNET_ADDRESS | COMM_ID_LONG | COMM_ID_LONG | CHAR | 241 | 0 | Communication: Long Identification/Number | ||
72 | CONTROLRECORD_STATE | VWSTA | VWSTA | NUMC | 1 | 0 | Status of Control Record | ||
73 | CONTROLRECORD_DATE | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
74 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
75 | FST_NAME_K | P22J_FNAMK | P22J_NAME | CHAR | 24 | 0 | First name (Katakana) | ||
76 | LST_NAME_K | P22J_LNAMK | P22J_NAME | CHAR | 24 | 0 | Last Name (Katakana) | ||
77 | FST_NAME_R | P22J_FNAMR | P22J_NAME | CHAR | 24 | 0 | First name (Romaji) | ||
78 | LST_NAME_R | P22J_LNAMR | P22J_NAME | CHAR | 24 | 0 | Last name (Romaji) | ||
79 | BIRTHNME_K | P22J_NABIK | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Katakana) | ||
80 | BIRTHNME_R | P22J_NABIR | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Romaji) | ||
81 | NICKNAME_K | P22J_NICKK | P22J_NAME | CHAR | 24 | 0 | Nickname (Katakana) | ||
82 | NICKNAME_R | P22J_NICKR | P22J_NAME | CHAR | 24 | 0 | Nickname (Romaji) | ||
83 | INITIATOR | PTREQ_ACTOR_STRUC_FLAT | STRU | 0 | 0 | ||||
84 | ACTOR_ID | GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID in 'CHAR' Format in Uppercase | ||
85 | ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | TIM_REQ_ACTOR_TYPE | CHAR | 1 | 0 | Actor's Role | ||
86 | USER | SYSID | CHAR30 | CHAR | 30 | 0 | Communication Identification/Number | ||
87 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | * | |
88 | PERSONNEL_SUBAREA | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | * | |
89 | PERSA | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | * | |
90 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | * | |
91 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
92 | OBJID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
93 | NAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
94 | SNAME | SMNAM | CHAR30 | CHAR | 30 | 0 | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
95 | MOLGA | MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | * | |
96 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
97 | INTERNET_ADDRESS | COMM_ID_LONG | COMM_ID_LONG | CHAR | 241 | 0 | Communication: Long Identification/Number | ||
98 | CONTROLRECORD_STATE | VWSTA | VWSTA | NUMC | 1 | 0 | Status of Control Record | ||
99 | CONTROLRECORD_DATE | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
100 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
101 | FST_NAME_K | P22J_FNAMK | P22J_NAME | CHAR | 24 | 0 | First name (Katakana) | ||
102 | LST_NAME_K | P22J_LNAMK | P22J_NAME | CHAR | 24 | 0 | Last Name (Katakana) | ||
103 | FST_NAME_R | P22J_FNAMR | P22J_NAME | CHAR | 24 | 0 | First name (Romaji) | ||
104 | LST_NAME_R | P22J_LNAMR | P22J_NAME | CHAR | 24 | 0 | Last name (Romaji) | ||
105 | BIRTHNME_K | P22J_NABIK | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Katakana) | ||
106 | BIRTHNME_R | P22J_NABIR | P22J_NAME | CHAR | 24 | 0 | Name of Birth (Romaji) | ||
107 | NICKNAME_K | P22J_NICKK | P22J_NAME | CHAR | 24 | 0 | Nickname (Katakana) | ||
108 | NICKNAME_R | P22J_NICKR | P22J_NAME | CHAR | 24 | 0 | Nickname (Romaji) | ||
109 | ITEM_TAB | PTREQ_ITEMS_TAB_FLAT | TTYP | 0 | 0 | ||||
110 | WORKITEM_ID | SWW_WIID | SWW_WIID | NUMC | 12 | 0 | Work item ID | * | |
111 | ADMIN_CURR_NOTICE | TIM_REQ_NOTICE | STRING | STRG | 0 | 0 | Note for Request | ||
112 | CURR_NOTICE | TIM_REQ_NOTICE | STRING | STRG | 0 | 0 | Note for Request | ||
113 | PAST_NOTICE | TIM_REQ_NOTICE | STRING | STRG | 0 | 0 | Note for Request | ||
114 | APPROVAL | PT_ARQ_APPROVAL_FLAG | BOOLE | CHAR | 1 | 0 | ESS Leave Request: Request Is Subject to Approval | ||
115 | APPROVAL_PROCESS | PTREQ_PROCESS | PTARQ_PROCESS | CHAR | 1 | 0 | ESS: Process for Processing | ||
116 | MOD_TIMESTAMP | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
117 | MOD_TIMEZONE | TIMEZONE | TZNZONE | CHAR | 6 | 0 | Time Zone | * |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 500 |