SAP ABAP Table RPLM_TS_POWL_ORDER_PM_DEF07 (Order Worklist definition for Maintenance Planner)
Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   EP-PCT-MAN-MP (Application Component) BP for Maintenance Planner
     RPLM_MP_BE (Package) Maintenance Planner Backend
Basic Data
Table Category INTTAB    Structure 
Structure RPLM_TS_POWL_ORDER_PM_DEF07   Table Relationship Diagram
Short Description Order Worklist definition for Maintenance Planner    
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 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
2 AUART AUFART AUFART CHAR 4   0   Order Type T003O
3 AUTYP AUFTYP AUFTYP NUMC 2   0   Order category  
4 WAERS AUFWAERS WAERS CUKY 5   0   Order Currency TCURC
5 ERNAM AUFERFNAM USNAM CHAR 12   0   Entered by  
6 ERDAT AUFERFDAT DATUM DATS 8   0   Created on  
7 AENAM AUFAENAM USNAM CHAR 12   0   Last changed by  
8 AEDAT AUFAEDAT DATUM DATS 8   0   Change date for Order Master  
9 KTEXT AUFTEXT TEXT40 CHAR 40   0   Description  
10 LTEXT AUFLTEXT XFELD CHAR 1   0   Long Text Exists  
11 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
12 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
13 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
14 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
15 KOSTV AUFKOSTV KOSTL CHAR 10   0   Responsible cost center CSKS
16 LOEKZ AUFLOEKZ XFELD CHAR 1   0   Deletion flag  
17 KALSM AUFKALSM KALSM CHAR 6   0   Costing Sheet *
18 ZSCHL AUFZSCHL CHAR6 CHAR 6   0   Overhead key  
19 ABCKZ ABCKZ ABCKZ CHAR 1   0   ABC Indicator for Technical Object T370C
20 EQFNR EQFNR CHAR30 CHAR 30   0   Sort Field  
21 PRIOK PRIOK PRIOK CHAR 1   0   Priority *
22 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number EQUI
23 BAUTL BAUTL MATNR CHAR 18   0   Assembly MARA
24 ANLZU ANLZU ANLZU CHAR 1   0   Syst.Condition T357M
25 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant T001W
26 INGPR INGRP INGRP CHAR 3   0   Planner Group for Customer Service and Plant Maintenance T024I
27 APGRP VAGRP VAGRP CHAR 3   0   Responsible planner group/department T024A
28 GEWRK GEWRK ARBPL CHAR 8   0   Main work center for maintenance tasks  
29 AWERK AWERK WERKS CHAR 4   0   Plant associated with main work center T001W
30 KUNUM KUNUM KUNNR CHAR 10   0   Customer Number KNA1
31 ANING ANING USNAM CHAR 12   0   Name of Person Reponsible for System  
32 EGAUZT EGAUZT DEC9_2 DEC 11   2   Planned Breakdown Duration  
33 ANLBD ANLBD DATUM DATS 8   0   Date until which the system is available  
34 ANLVD ANLVD DATUM DATS 8   0   Date from which the system is available  
35 ANLBZ ANLBZ UHRZT TIMS 6   0   Time until which the system is available  
36 ANLVZ ANLVZ UHRZT TIMS 6   0   Time from Which System is Available  
37 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
38 SWERK SWERK WERKS CHAR 4   0   Maintenance Plant T001W
39 STORT PMLOC AP_STAND CHAR 10   0   Location of maintenance object T499S
40 MSGRP RAUMNR CHAR8 CHAR 8   0   Room  
41 BEBER BEBER BEBER CHAR 3   0   Organizational Area T357
42 TPLNR ILOM_STRNO ILOM_STRNO CHAR 40   0   Functional location label  
43 ANLNR ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
44 ANLUN ANLN2 ANLN2 CHAR 4   0   Asset Subnumber ANLA
45 REVNR REVNI REVNI CHAR 8   0   Revision of Plant Maintenance and Customer Service T352R
46 WARPL WARPL WARPL CHAR 12   0   Maintenance Plan MPLA
47 WAPOS WAPOS POSNU CHAR 16   0   Maintenance item  
48 STTXT J_STEXT TEXT40 CHAR 40   0   System status line  
49 USTXT J_ATEXT TEXT40 CHAR 40   0   User Status Line  
50 ARBPL ARBPL ARBPL CHAR 8   0   Work center  
51 GLTRP CO_GLTRP DATUM DATS 8   0   Basic finish date  
52 GSTRP CO_GSTRP DATUM DATS 8   0   Basic start date  
53 GLTRS CO_GLTRS DATUM DATS 8   0   Scheduled finish  
54 GSTRS CO_GSTRS DATUM DATS 8   0   Scheduled start  
55 GSTRI CO_GSTRI DATUM DATS 8   0   Actual start date  
56 GETRI CO_GETRI DATUM DATS 8   0   Confirmed Order Finish Date  
57 FEVOR VAGRP VAGRP CHAR 3   0   Responsible planner group/department T024A
58 FTRMI CO_FTRMI DATUM DATS 8   0   Actual release date  
59 ILART ILA ILART CHAR 3   0   Maintenance activity type T353I
60 QMNUM QMNUM QMNUM CHAR 12   0   Message Number QMEL
61 HISDA HISDA DATUM DATS 8   0   PM request: History date  
62 EQKTX KTX01 TEXT40 CHAR 40   0   Description of technical object  
63 PLTXT PLTXT TEXT40 CHAR 40   0   Description of functional location  
64 MANDT MANDT MANDT CLNT 3   0   Client T000
65 NAME_LIST I_NAME_LST NAME CHAR 35   0   Name for list displays  
66 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
67 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
68 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
69 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
70 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
71 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
72 STREET AD_STREET TEXT60 CHAR 60   0   Street  
73 RKEOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
74 GKSTI DGESKOSIST WERTV8 CURR 15   2   Total(actual) maintenance costs  
75 GKSTP DGESKOPLAN WERTV8 CURR 15   2   Total plant maintenance costs (planned)  
76 GKSTA DGESKOABRE WERTV8 CURR 15   2   Total Settlement Costs (PMCO)  
77 GERTI DGESERTRAG WERTV8 CURR 15   2   Total plant maintenance revenues (actual)  
78 GERTP DGPLERTRAG WERTV8 CURR 15   2   Total (planned) maintenance revenues  
79 GESIST DPMISTVAL WERTV8 CURR 15   2   Actual sum of maintenance order (costs - revenues)  
80 GESPLN DPMPLANVAL WERTV8 CURR 15   2   Plan sum of maintenance order (costs - revenues)  
81 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number *
82 KDAUF VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
83 KDPOS POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
84 LEAD_AUFNR CO_LAUFNR AUFNR CHAR 12   0   Leading order in current processing AUFK
85 MAUFNR MAUFNR AUFNR CHAR 12   0   Number of superior order AUFK
86 GEUZI CO_GEUZI UHRZT TIMS 6   0   Confirmed order finish (time)  
87 GSUZI CO_GSUZI UHRZT TIMS 6   0   Actual start time  
88 GLUZS CO_GLUZS UHRZT TIMS 6   0   Scheduled finish time  
89 GSUZS CO_GSUZS ATIME TIMS 6   0   Scheduled Start (Time)  
90 PLNNR PLNNR PLNNR CHAR 8   0   Key for Task List Group  
91 PLNAL PLNAL ALTNR CHAR 2   0   Group Counter  
92 PLKNZ AUF_PLKNZ AUF_PLKNZ CHAR 1   0   Maintenance order planning indicator  
93 ADDAT ADDAT DATUM DATS 8   0   PM Order: Reference Date  
94 PROID I_PM_POSID CHAR24 CHAR 24   0   Work Breakdown Structure Element (WBS Element) for List  
95 AUFNT CO_TEILNET AUFNR CHAR 12   0   Number of superior network *
96 VORUE VORG_UEBER VORNR CHAR 4   0   Superior activity  
97 USER4 AUFUSER4 AUFUSER4 CURR 11   2   Estimated total costs of order  
98 VKORG VKORG VKORG CHAR 4   0   Sales Organization *
99 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel *
100 SPART SPART SPART CHAR 2   0   Division *
101 GLUZP CO_GLUZP UHRZT TIMS 6   0   Basic finish (time)  
102 GSUZP CO_GSUZP UHRZT TIMS 6   0   Basic start time  
103 ADUHR ADUHR UZEIT TIMS 6   0   Time of Reference Date  
104 BEMOT BEMOT BEMOT CHAR 2   0   Accounting Indicator *
105 ADRNRA AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
106 SERMAT MATNR MATNR CHAR 18   0   Material Number *
107 SERIALNR GERNR GERNR CHAR 18   0   Serial Number  
108 DEVICEID DEVICEID DEVICEID CHAR 40   0   Additional Device Data  
109 VKBUR VKBUR VKBUR CHAR 4   0   Sales office *
110 VKGRP VKGRP VKGRP CHAR 3   0   Sales group *
111 MAKTX MAKTX TEXT40 CHAR 40   0   Material description  
112 BAUTLX BAUTXL TEXT40 CHAR 40   0   Assembly Description  
113 PAGESTAT PAGESTAT PAGESTAT CHAR 4   0   Paging Status  
114 PSPEL I_PM_POSID_HEADER CHAR24 CHAR 24   0   Work breakdown structure element (WBS element) order header  
115 AUDISP AUDISP_PLUS AUDISP CHAR 1   0   Reservation Relevance/Generation of Purchase Requisition  
116 IPHAS PM_PHASE PM_PHASE CHAR 1   0   Maintenance Processing Phase  
117 ARTPR ARTPR ARTPR CHAR 2   0   Priority Type *
118 PRIOKX PRIOKX TEXT20 CHAR 20   0   Priority Text  
119 BSTKD BSTKD BSTKD CHAR 35   0   Customer purchase order number  
120 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
121 SERV_MATNR MATSV MATNR CHAR 18   0   Service product *
122 SERV_MAKTX MATSVTX TEXT40 CHAR 40   0   Description of Service Product  
123 MENGE MNGSP MENG13 QUAN 13   3   Service product quantity  
124 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
125 FAKTF FAKTF FAKTF CHAR 2   0   Billing Form  
126 PLGRP I_PM_VAGRP VAGRP CHAR 3   0   Responsible Planner Group/Department from Task List *
127 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
128 OBKNR OBJKNR OBJKN INT4 10   0   Object list number *
129 ADPSP ADDCOMPARE_CORE ADDCOMPARE_CORE CHAR 40   0   Reference Element PM/PS *
130 VKORG_PMSDO VKORG VKORG CHAR 4   0   Sales Organization *
131 VTWEG_PMSDO VTWEG VTWEG CHAR 2   0   Distribution Channel *
132 SPART_PMSDO SPART SPART CHAR 2   0   Division *
133 LIGHTS RPLM_TD_QIMT_LIGHTS   SSTR 30   0   Symbol for Monitor  
134 DOCNUM RPLM_TD_QIMT_NUMBER_DOC   SSTR 30   0   Number of Documents  
135 PERMITSNUM RPLM_ORDER_PERMITS_NUM   SSTR 30   0   Order Permit  
136 MATAVL     SSTR 255   0    
137 BANFN BANFN BANFN CHAR 10   0   Purchase requisition number  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RPLM_TS_POWL_ORDER_PM_DEF07 ABCKZ T370C ABCKZ    
2 RPLM_TS_POWL_ORDER_PM_DEF07 ANLNR ANLH ANLN1    
3 RPLM_TS_POWL_ORDER_PM_DEF07 ANLUN ANLA ANLN2    
4 RPLM_TS_POWL_ORDER_PM_DEF07 ANLZU T357M ANLZU    
5 RPLM_TS_POWL_ORDER_PM_DEF07 APGRP T024A FEVOR    
6 RPLM_TS_POWL_ORDER_PM_DEF07 AUART T003O AUART    
7 RPLM_TS_POWL_ORDER_PM_DEF07 AUFNR AUFK AUFNR    
8 RPLM_TS_POWL_ORDER_PM_DEF07 AWERK T001W WERKS    
9 RPLM_TS_POWL_ORDER_PM_DEF07 BAUTL MARA MATNR    
10 RPLM_TS_POWL_ORDER_PM_DEF07 BEBER T357 BEBER    
11 RPLM_TS_POWL_ORDER_PM_DEF07 BUKRS T001 BUKRS    
12 RPLM_TS_POWL_ORDER_PM_DEF07 EQUNR EQUI EQUNR    
13 RPLM_TS_POWL_ORDER_PM_DEF07 FEVOR T024A FEVOR    
14 RPLM_TS_POWL_ORDER_PM_DEF07 GSBER TGSB GSBER    
15 RPLM_TS_POWL_ORDER_PM_DEF07 ILART T353I ILART    
16 RPLM_TS_POWL_ORDER_PM_DEF07 INGPR T024I INGRP    
17 RPLM_TS_POWL_ORDER_PM_DEF07 IWERK T001W WERKS    
18 RPLM_TS_POWL_ORDER_PM_DEF07 KDAUF VBUK VBELN    
19 RPLM_TS_POWL_ORDER_PM_DEF07 KDPOS VBUP POSNR    
20 RPLM_TS_POWL_ORDER_PM_DEF07 KOKRS TKA01 KOKRS    
21 RPLM_TS_POWL_ORDER_PM_DEF07 KOSTL CSKS KOSTL    
22 RPLM_TS_POWL_ORDER_PM_DEF07 KOSTV CSKS KOSTL    
23 RPLM_TS_POWL_ORDER_PM_DEF07 KUNUM KNA1 KUNNR    
24 RPLM_TS_POWL_ORDER_PM_DEF07 LEAD_AUFNR AUFK AUFNR    
25 RPLM_TS_POWL_ORDER_PM_DEF07 MANDT T000 MANDT    
26 RPLM_TS_POWL_ORDER_PM_DEF07 MAUFNR AUFK AUFNR    
27 RPLM_TS_POWL_ORDER_PM_DEF07 QMNUM QMEL QMNUM    
28 RPLM_TS_POWL_ORDER_PM_DEF07 REVNR T352R REVNR    
29 RPLM_TS_POWL_ORDER_PM_DEF07 STORT T499S STAND    
30 RPLM_TS_POWL_ORDER_PM_DEF07 SWERK T001W WERKS    
31 RPLM_TS_POWL_ORDER_PM_DEF07 WAERS TCURC WAERS    
32 RPLM_TS_POWL_ORDER_PM_DEF07 WARPL MPLA WARPL    
33 RPLM_TS_POWL_ORDER_PM_DEF07 WERKS T001W WERKS    
History
Last changed by/on SAP  20130529 
SAP Release Created in 700