SAP ABAP Table EAMS_S_SP_JOB_WORKITEM_POWL (EAMS - Structure for Joblist POWL in Work Item level)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ PM (Application Component) Plant Maintenance
⤷ EAMS_MDP_MISC (Package) Miscellaneous for Master Data Provider
⤷ PM (Application Component) Plant Maintenance
⤷ EAMS_MDP_MISC (Package) Miscellaneous for Master Data Provider
Basic Data
Table Category | INTTAB | Structure |
Structure | EAMS_S_SP_JOB_WORKITEM_POWL | Table Relationship Diagram |
Short Description | EAMS - Structure for Joblist POWL in Work Item level |
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 | Key which defines a Job Work Item precisely | |||||
2 | .INCLUDE | 0 | 0 | Workitem of Job - Identification | |||||
3 | EAMS_REF_DOC_OBJ_TYPE | /PLMB/GOS_OBJECT_TYPE | /PLMB/GOS_OBJECT_TYPE | CHAR | 10 | 0 | Object Type | * | |
4 | EAMS_REF_DOC_NO | EAMS_REF_DOC_NO | EAMS_REF_DOC_NO | CHAR | 12 | 0 | Reference Document Number | ||
5 | EAMS_WORKITEM_NO | EAMS_WORKITEM_NO | CHAR4 | CHAR | 4 | 0 | Work Item Number | ||
6 | .INCLUDE | 0 | 0 | Key which defines a job precisely | |||||
7 | .INCLUDE | 0 | 0 | Business Object Job - Identification | |||||
8 | EAMS_OBJECT_TYPE | EAMS_REF_DOC_OBJ_TYPE | /PLMB/GOS_OBJECT_TYPE | CHAR | 10 | 0 | Reference Document Object Type | * | |
9 | EAMS_LEAD_DOC_NO | EAMS_REF_DOC_NO | EAMS_REF_DOC_NO | CHAR | 12 | 0 | Reference Document Number | ||
10 | .INCLUDE | 0 | 0 | Parameters for Job | |||||
11 | EAMS_WORK_CENTER | EAMS_WORK_CENTER | ARBPL | CHAR | 8 | 0 | Work Center | ||
12 | EAMS_PLANT | EAMS_WKCTR_PLANT | WERKS | CHAR | 4 | 0 | Plant Associated with Work Center | T001W | |
13 | EAMS_PERSON_RESPONSIBLE | EAMS_PERSON_RESPONSIBLE | I_PARNR | CHAR | 12 | 0 | Person Responsible ID | ||
14 | EAMS_STATUS_JIPR | EAMS_STATUS_JIPR | EAMS_STATUS | CHAR | 1 | 0 | Status "Job Work Item in Process" | ||
15 | EAMS_STATUS_DONE | EAMS_STATUS_DONE | EAMS_STATUS | CHAR | 1 | 0 | Status "Job Work Item Done" | ||
16 | .INCLUDE | 0 | 0 | Job Attributes | |||||
17 | ORD_ID | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
18 | NTF_ID | QMNUM | QMNUM | CHAR | 12 | 0 | Message Number | * | |
19 | DOC_OBJ_TYP_ICON | /PLMB/GOS_ICON | /PLMB/GOS_CHAR64 | CHAR | 64 | 0 | Icon | ||
20 | DOC_OBJ_TYP_DESC | EAMS_REF_DOC_OBJ_TYPE_DESC | /PLMB/GOS_OTYPE_DESC | CHAR | 40 | 0 | Description of Reference Document Object Type | ||
21 | DOC_TYPE | EAMS_REF_DOC_TYPE | EAMS_DOC_TYPE | CHAR | 4 | 0 | Reference Document Subtype | ||
22 | DOC_TYPE_DESC | EAMS_REF_DOC_TYPE_DESC | CHAR40 | CHAR | 40 | 0 | Description of Reference Document Subtype | ||
23 | DOC_TEXT | EAMS_REF_DOC_DESC | TEXT40 | CHAR | 40 | 0 | Order/Notification Description | ||
24 | EAMS_START_DATE | EAMS_STRMN | DATUM | DATS | 8 | 0 | Start Date | ||
25 | EAMS_START_TIME | EAMS_STRUR | UZEIT | TIMS | 6 | 0 | Start Time | ||
26 | EAMS_END_DATE | EAMS_LTRMN | DATUM | DATS | 8 | 0 | End Date | ||
27 | EAMS_END_TIME | EAMS_LTRUR | UZEIT | TIMS | 6 | 0 | End Time | ||
28 | EAMS_WORK_CENTER_DESC | EAMS_MAIN_WKCTR_DESC | TEXT40 | CHAR | 40 | 0 | Work Center Description | ||
29 | EAMS_PLANT_DESC | EAMS_WKCTR_PLANT_DESC | TEXT30 | CHAR | 30 | 0 | Description of Plant Associated with Work Center | ||
30 | EAMS_PERSON_RESPONSIBLE_NAME | EAMS_PERSON_RESPONSIBLE_NAME | NAME | CHAR | 35 | 0 | Person Responsible Name | ||
31 | PRIOK | PRIOK | PRIOK | CHAR | 1 | 0 | Priority | * | |
32 | PRIOKX | EAMS_PRIOKX | TEXT20 | CHAR | 20 | 0 | Priority Description | ||
33 | .INCLUDE | 0 | 0 | Technical Object - Identification | |||||
34 | EAMS_TEC_OBJ_TYPE | /PLMB/GOS_OBJECT_TYPE | /PLMB/GOS_OBJECT_TYPE | CHAR | 10 | 0 | Object Type | /PLMB/GOS_OTYPE | |
35 | EAMS_TEC_OBJ_NO | EAMS_TEC_OBJ | EAMS_TEC_OBJ | CHAR | 40 | 0 | Technical Object | ||
36 | EAMS_TEC_OBJ_NO_EXT | EAMS_TEC_OBJ | EAMS_TEC_OBJ | CHAR | 40 | 0 | Technical Object | ||
37 | EAMS_TEC_OBJ_DES | KTX01 | TEXT40 | CHAR | 40 | 0 | Description of technical object | ||
38 | EAMS_TEC_OBJ_TYPE_ICON | /PLMB/GOS_ICON | /PLMB/GOS_CHAR64 | CHAR | 64 | 0 | Icon | ||
39 | EAMS_TEC_OBJ_TYPE_DESC | EAMS_TEC_OBJ_TYPE_DESC | /PLMB/GOS_OTYPE_DESC | CHAR | 40 | 0 | Description of Technical Object Type | ||
40 | ASSEMBLY | BAUTL | MATNR | CHAR | 18 | 0 | Assembly | * | |
41 | ASSEMBLY_DESC | EAMS_ASSEMBLY_DESC | TEXT40 | CHAR | 40 | 0 | Assembly Description | ||
42 | OBJECT_NO | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
43 | SYS_STATUS | CO_STTXT | CHAR40 | CHAR | 40 | 0 | System Status | ||
44 | USERSTATUS_ACT | EAMS_USERSTATUS_ACT | KREUZ | CHAR | 1 | 0 | User Status Active | ||
45 | USERSTATUS | CO_ASTTX | CHAR40 | CHAR | 40 | 0 | Field displaying user status | ||
46 | ABCINDIC | ABCKZ | ABCKZ | CHAR | 1 | 0 | ABC Indicator for Technical Object | * | |
47 | ABCINDIC_DESC | ABCTX | TEXT20 | CHAR | 20 | 0 | Text for ABC Indicator for Technical Objects | ||
48 | CALL_NO | ABNUM | ABNUM | INT4 | 10 | 0 | Maintenance Plan Call Number | ||
49 | REFDATE | ADDAT | DATUM | DATS | 8 | 0 | PM Order: Reference Date | ||
50 | ASSET_NO | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
51 | ASSET_NO_DESC | EAMS_ASSET_NO_DESC | TEXT50 | CHAR | 50 | 0 | Asset Description | ||
52 | SUB_NUMBER | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
53 | CHANGED_BY | EAMS_CHANGED_BY_ID | USNAM | CHAR | 12 | 0 | Changed By (ID) | ||
54 | CHANGE_DATE | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
55 | CHANGED_BY_DESC | EAMS_CHANGED_BY_DESC | XUNAME1 | CHAR | 30 | 0 | Changed By (Name) | ||
56 | CREATED_ON | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
57 | CREATED_BY | EAMS_CREATED_BY_ID | USNAM | CHAR | 12 | 0 | Created By (ID) | ||
58 | CREATED_BY_DESC | EAMS_CREATED_BY_DESC | XUNAME1 | CHAR | 30 | 0 | Created By (Name) | ||
59 | PLSECTN | EAMS_PLANT_SECT | BEBER | CHAR | 3 | 0 | Plant Section | * | |
60 | PLSECTN_DESC | EAMS_PERS_RESP_PLANT_SECT | CHAR30 | CHAR | 30 | 0 | Person Responsible for Plant Section | ||
61 | COMP_CODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
62 | COMP_CODE_DESC | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
63 | STANDORDER | DAUFN | AUFNR | CHAR | 12 | 0 | Standing order number | * | |
64 | DEVICEDATA | DEVICEID | DEVICEID | CHAR | 40 | 0 | Additional Device Data | ||
65 | SORTFIELD | EQFNR | CHAR30 | CHAR | 30 | 0 | Sort Field | ||
66 | SERIALNO | GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
67 | BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
68 | BUS_AREA_DESC | EAMS_BUS_AREA_DESC | TEXT30 | CHAR | 30 | 0 | Business Area Description | ||
69 | SETTLORDER | ILOM_ORDST | AUFNR | CHAR | 12 | 0 | Settlement order | * | |
70 | SETTLORDER_DESC | AUFTEXT | TEXT40 | CHAR | 40 | 0 | Description | ||
71 | PLANGROUP | INGRP | INGRP | CHAR | 3 | 0 | Planner Group for Customer Service and Plant Maintenance | * | |
72 | PLANGROUP_DESC | INNAM | TEXT18 | CHAR | 18 | 0 | Name of the Maintenance Planner Group | ||
73 | PLANPLANT | IWERK | WERKS | CHAR | 4 | 0 | Maintenance Planning Plant | * | |
74 | PLANPLANT_DESC | EAMS_PLANPLANT_DESC | TEXT30 | CHAR | 30 | 0 | Planning Plant Description | ||
75 | SALES_ORD | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
76 | CO_AREA | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
77 | CO_AREA_DESC | BEZEI | TEXT25 | CHAR | 25 | 0 | Name of the controlling area | ||
78 | COSTCENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
79 | COSTCENTER_DESC | EAMS_COSTCENTER_DESC | TEXT20 | CHAR | 20 | 0 | Cost Center Description | ||
80 | MATERIAL | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
81 | MATERIAL_DESC | EAMS_MATERIAL_DESC | TEXT40 | CHAR | 40 | 0 | Material Description | ||
82 | ASSEMBLY_EXTERNAL | MGV_ASSEMBLY_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for Field ASSEMBLY | ||
83 | ASSEMBLY_GUID | MGV_ASSEMBLY_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for ASSEMBLY Field | ||
84 | ASSEMBLY_VERSION | MGV_ASSEMBLY_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for ASSEMBLY Field | ||
85 | MATERIAL_EXTERNAL | MGV_MATERIAL_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for MATERIAL Field | ||
86 | MATERIAL_GUID | MGV_MATERIAL_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for MATERIAL Field | ||
87 | MATERIAL_VERSION | MGV_MATERIAL_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for MATERIAL Field | ||
88 | PP_WKCTR | EAMS_PP_WKCTR | ARBPL | CHAR | 8 | 0 | Production Work Center | ||
89 | PP_WKCTR_DESC | EAMS_PP_WKCTR_DESC | TEXT40 | CHAR | 40 | 0 | Description of Production Work Center | ||
90 | PP_WKCTR_PLANT | EAMS_PP_WKCTR_PLANT | WERKS | CHAR | 4 | 0 | Production Work Center Plant | * | |
91 | PP_WKCTR_PLANT_DESC | EAMS_PP_WKCTR_PLANT_DESC | TEXT30 | CHAR | 30 | 0 | Description of Production Work Center Plant | ||
92 | WBS_ELEMENT | PM_POSID_HEADER | PS_POSID | CHAR | 24 | 0 | Work breakdown structure element (WBS element) order header | ||
93 | WBS_ELEMENT_DESC | EAMS_WBS_ELEMENT_DESC | TEXT40 | CHAR | 40 | 0 | WBS Order Description | ||
94 | MAINTROOM | RAUMNR | CHAR8 | CHAR | 8 | 0 | Room | ||
95 | DIVISION | SPART | SPART | CHAR | 2 | 0 | Division | * | |
96 | DIVISION_DESC | EAMS_DIVISION_DESC | TEXT20 | CHAR | 20 | 0 | Division Description | ||
97 | LOCATION | STORT | AP_STAND | CHAR | 10 | 0 | Asset location | * | |
98 | LOCATION_DESC | EAMS_LOCATION_DESC | TEXT40 | CHAR | 40 | 0 | Location Description | ||
99 | MAINTPLANT | EAMS_MAINTPLANT | WERKS | CHAR | 4 | 0 | Maintenance Plant | * | |
100 | MAINTPLANT_DESC | EAMS_MAINTPLANT_DESC | TEXT30 | CHAR | 30 | 0 | Maintenance Plant Description | ||
101 | SALESORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
102 | SALESORG_DESC | EAMS_SALESORG_DESC | TEXT20 | CHAR | 20 | 0 | Sales Organization Description | ||
103 | DISTR_CHAN | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
104 | DISTR_CHAN_DESC | EAMS_DISTR_CHAN_DESC | TEXT20 | CHAR | 20 | 0 | Distribution Channel Description | ||
105 | MAINTITEM | WAPOS | POSNU | CHAR | 16 | 0 | Maintenance item | ||
106 | MAINTITEM_DESC | POSTXT | TEXT40 | CHAR | 40 | 0 | Item Short Text | ||
107 | MNTPLAN | WARPL | WARPL | CHAR | 12 | 0 | Maintenance Plan | * | |
108 | MNTPLAN_DESC | WPTXT | TEXT40 | CHAR | 40 | 0 | Maintenance Plan Text | ||
109 | URGENCY_NUM | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
110 | URGENCY_ICON | ICON_TEXT | SYCHAR132 | CHAR | 132 | 0 | Carrier field for icons | ||
111 | URGENCY_TOOLTIP | ICON_TEXT | SYCHAR132 | CHAR | 132 | 0 | Carrier field for icons | ||
112 | ORD_CHANGE_DATE | AUFAEDAT | DATUM | DATS | 8 | 0 | Change date for Order Master | ||
113 | ORD_CHANGE_TIME | CO_CHG_TIME | UZEIT | TIMS | 6 | 0 | Changed at | ||
114 | NTF_CHANGE_DATE | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
115 | NTF_CHANGE_TIME | AEZEIT | UHRZT | TIMS | 6 | 0 | Time of Change | ||
116 | EAMS_PERM_ID | EAMS_WCEWAPINR | EAMS_WCDNO | CHAR | 12 | 0 | Work Permit Number | ||
117 | EAMS_PERM_MULTI_ICON | /PLMB/GOS_ICON | /PLMB/GOS_CHAR64 | CHAR | 64 | 0 | Icon | ||
118 | EAMS_PERM_STAT | EAMS_WP_PHASE | TEXT40 | CHAR | 40 | 0 | Work Permit Phase | ||
119 | EAMS_PERM_STAT_ICON | /PLMB/GOS_ICON | /PLMB/GOS_CHAR64 | CHAR | 64 | 0 | Icon | ||
120 | EAMS_PERM_STAT_ID | WCELCPHASE | WCDLCPHASE | CHAR | 4 | 0 | Life-Cycle Phase | ||
121 | EAMS_PERM_STAT_TEXT | GUI_INFO | GUI_INFO | CHAR | 60 | 0 | Menu Painter: Info text (4.0) | ||
122 | EAMS_PERM_TOOLTIP | POWL_EASY_COLUMN_TOOLTIP_TY | POWL_EASY_TEXT_DOM | CHAR | 50 | 0 | Column Tooltip | ||
123 | EAMS_OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
124 | .INCLUDE | 0 | 0 | Work Item Attributes | |||||
125 | EAMS_WORK_ITEM_DESC | EAMS_WORK_ITEM_DESC | TEXT40 | CHAR | 40 | 0 | Description of Work Item | ||
126 | EAMS_WORKITEM_NO_TXT | EAMS_WORKITEM_NO_TXT | CHAR40 | CHAR | 40 | 0 | Work Item Number and Work Item Type | ||
127 | SUB_WORKCENTER | ARBPL | ARBPL | CHAR | 8 | 0 | Work center | ||
128 | SUB_WORKCENTER_DESC | CR_KTEXT | TEXT40 | CHAR | 40 | 0 | Short description | ||
129 | SUB_WORKCENTER_PLANT | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
130 | SUB_WORKCENTER_PLANT_DESC | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
131 | SUB_PARTNER | I_PARNR | I_PARNR | CHAR | 12 | 0 | Partner | ||
132 | SUB_PARTNER_NAME | NAME | NAME | CHAR | 35 | 0 | Name | ||
133 | SUB_PARTNER_ROLE | PARVW | PARVW | CHAR | 2 | 0 | Partner Role | * | |
134 | SUB_EARL_STARTDATE | FSAVD | DATUM | DATS | 8 | 0 | Earliest scheduled start: Execution (date) | ||
135 | SUB_EARL_STARTTIME | FSAVZ | ATIME | TIMS | 6 | 0 | Earliest scheduled start: Execution (time) | ||
136 | SUB_LATE_STARTDATE | SSAVD | DATUM | DATS | 8 | 0 | Latest scheduled start: Execution (date) | ||
137 | SUB_LATE_STARTTIME | SSAVZ | ATIME | TIMS | 6 | 0 | Latest scheduled start: Execution (time) | ||
138 | SUB_EARL_FINISHDATE | FSEDD | DATUM | DATS | 8 | 0 | Earliest scheduled finish: Execution (date) | ||
139 | SUB_EARL_FINISHTIME | FSEDZ | ATIME | TIMS | 6 | 0 | Earliest scheduled finish: Execution (time) | ||
140 | SUB_LATE_FINISHDATE | SSEDD | DATUM | DATS | 8 | 0 | Latest scheduled finish: Execution (date) | ||
141 | SUB_LATE_FINISHTIME | SSEDZ | ATIME | TIMS | 6 | 0 | Latest scheduled finish: Execution (time) | ||
142 | WORK_ACTIVITY | ARBEIT | ARBEIT | QUAN | 7 | 1 | Work involved in the activity | ||
143 | WORK_UNIT | ARBEITE | MEINS | UNIT | 3 | 0 | Unit for work | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | EAMS_S_SP_JOB_WORKITEM_POWL | EAMS_PLANT | T001W | WERKS | 1 | CN | |
2 | EAMS_S_SP_JOB_WORKITEM_POWL | EAMS_TEC_OBJ_TYPE | /PLMB/GOS_OTYPE | OTYPE_NAME |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 605 |