SAP ABAP Table ESO_S_RIHAUFK_LIST (Enterprise Search Order header)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSE (Application Component) Mobile Service
     ⤷ IWOC (Package) Application Development R/3 Work Order Cycle

Basic Data

Table Category	INTTAB	Structure
Structure	ESO_S_RIHAUFK_LIST	Table Relationship Diagram
Short Description	Enterprise Search Order header

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	Reporting display structure PM orders
2	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
3	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
4	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
5	WAERS	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	TCURC
6	ERNAM	☐	AUFERFNAM	USNAM	CHAR	12	0	Entered by
7	ERDAT	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
8	AENAM	☐	AUFAENAM	USNAM	CHAR	12	0	Last changed by
9	AEDAT	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
10	KTEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
11	LTEXT	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
12	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
13	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
14	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
15	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
16	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	CSKS
17	LOEKZ	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
18	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	*
19	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
20	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
21	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
22	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	*
23	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
24	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
25	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	T357M
26	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T001W
27	INGPR	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
28	APGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
29	GEWRK	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
30	AWERK	☐	AWERK	WERKS	CHAR	4	0	Plant associated with main work center	T001W
31	KUNUM	☐	KUNUM	KUNNR	CHAR	10	0	Customer Number	KNA1
32	ANING	☐	ANING	USNAM	CHAR	12	0	Name of Person Reponsible for System
33	EGAUZT	☐	EGAUZT	DEC9_2	DEC	11	2	Planned Breakdown Duration
34	ANLBD	☐	ANLBD	DATUM	DATS	8	0	Date until which the system is available
35	ANLVD	☐	ANLVD	DATUM	DATS	8	0	Date from which the system is available
36	ANLBZ	☐	ANLBZ	UHRZT	TIMS	6	0	Time until which the system is available
37	ANLVZ	☐	ANLVZ	UHRZT	TIMS	6	0	Time from Which System is Available
38	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
39	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
40	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
41	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
42	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
43	TPLNR	☐	ILOM_STRNO	ILOM_STRNO	CHAR	40	0	Functional location label
44	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
45	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
46	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	T352R
47	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
48	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
49	STTXT	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
50	USTXT	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
51	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
52	GLTRP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
53	GSTRP	☐	CO_GSTRP	DATUM	DATS	8	0	Basic start date
54	GLTRS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
55	GSTRS	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
56	GSTRI	☐	CO_GSTRI	DATUM	DATS	8	0	Actual start date
57	GETRI	☐	CO_GETRI	DATUM	DATS	8	0	Confirmed Order Finish Date
58	FEVOR	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
59	FTRMI	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
60	ILART	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	T353I
61	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
62	HISDA	☐	HISDA	DATUM	DATS	8	0	PM request: History date
63	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
64	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
65	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
66	.INCLUDE	☐				0	0	Display Structure Reporting PM Address Data
67	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
68	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
69	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
70	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
71	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
72	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
73	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
74	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
75	RKEOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
76	GKSTI	☐	DGESKOSIST	WERTV8	CURR	15	2	Total(actual) maintenance costs
77	GKSTP	☐	DGESKOPLAN	WERTV8	CURR	15	2	Total plant maintenance costs (planned)
78	GKSTA	☐	DGESKOABRE	WERTV8	CURR	15	2	Total Settlement Costs (PMCO)
79	GERTI	☐	DGESERTRAG	WERTV8	CURR	15	2	Total plant maintenance revenues (actual)
80	GERTP	☐	DGPLERTRAG	WERTV8	CURR	15	2	Total (planned) maintenance revenues
81	GESIST	☐	DPMISTVAL	WERTV8	CURR	15	2	Actual sum of maintenance order (costs - revenues)
82	GESPLN	☐	DPMPLANVAL	WERTV8	CURR	15	2	Plan sum of maintenance order (costs - revenues)
83	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
84	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
85	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
86	LEAD_AUFNR	☐	CO_LAUFNR	AUFNR	CHAR	12	0	Leading order in current processing	AUFK
87	MAUFNR	☐	MAUFNR	AUFNR	CHAR	12	0	Number of superior order	AUFK
88	GEUZI	☐	CO_GEUZI	UHRZT	TIMS	6	0	Confirmed order finish (time)
89	GSUZI	☐	CO_GSUZI	UHRZT	TIMS	6	0	Actual start time
90	GLUZS	☐	CO_GLUZS	UHRZT	TIMS	6	0	Scheduled finish time
91	GSUZS	☐	CO_GSUZS	ATIME	TIMS	6	0	Scheduled Start (Time)
92	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
93	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
94	PLKNZ	☐	AUF_PLKNZ	AUF_PLKNZ	CHAR	1	0	Maintenance order planning indicator
95	ADDAT	☐	ADDAT	DATUM	DATS	8	0	PM Order: Reference Date
96	PROID	☐	I_PM_POSID	CHAR24	CHAR	24	0	Work Breakdown Structure Element (WBS Element) for List
97	AUFNT	☐	CO_TEILNET	AUFNR	CHAR	12	0	Number of superior network	*
98	VORUE	☐	VORG_UEBER	VORNR	CHAR	4	0	Superior activity
99	USER4	☐	AUFUSER4	AUFUSER4	CURR	11	2	Estimated total costs of order
100	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
101	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
102	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
103	GLUZP	☐	CO_GLUZP	UHRZT	TIMS	6	0	Basic finish (time)
104	GSUZP	☐	CO_GSUZP	UHRZT	TIMS	6	0	Basic start time
105	ADUHR	☐	ADUHR	UZEIT	TIMS	6	0	Time of Reference Date
106	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
107	ADRNRA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
108	SERMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
109	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
110	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
111	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
112	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
113	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
114	BAUTLX	☐	BAUTXL	TEXT40	CHAR	40	0	Assembly Description
115	PAGESTAT	☐	PAGESTAT	PAGESTAT	CHAR	4	0	Paging Status
116	PSPEL	☐	I_PM_POSID_HEADER	CHAR24	CHAR	24	0	Work breakdown structure element (WBS element) order header
117	AUDISP	☐	AUDISP_PLUS	AUDISP	CHAR	1	0	Reservation Relevance/Generation of Purchase Requisition
118	IPHAS	☐	PM_PHASE	PM_PHASE	CHAR	1	0	Maintenance Processing Phase
119	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	*
120	PRIOKX	☐	PRIOKX	TEXT20	CHAR	20	0	Priority Text
121	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
122	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
123	SERV_MATNR	☐	MATSV	MATNR	CHAR	18	0	Service product	*
124	SERV_MAKTX	☐	MATSVTX	TEXT40	CHAR	40	0	Description of Service Product
125	MENGE	☐	MNGSP	MENG13	QUAN	13	3	Service product quantity
126	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
127	FAKTF	☐	FAKTF	FAKTF	CHAR	2	0	Billing Form
128	PLGRP	☐	I_PM_VAGRP	VAGRP	CHAR	3	0	Responsible Planner Group/Department from Task List	*
129	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
130	OBKNR	☐	OBJKNR	OBJKN	INT4	10	0	Object list number	*
131	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS	*
132	VKORG_PMSDO	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
133	VTWEG_PMSDO	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
134	SPART_PMSDO	☐	SPART	SPART	CHAR	2	0	Division	*
135	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
136	.INCLU--AP	☐				0	0	CU specific APPEND for reporting display structure PM orders
137	/CUM/CMNUM	☐	/CUM/CMNUM	/CUM/CMNUM	CHAR	12	0	CU: Construction Measure Number
138	/CUM/DESNUM	☐	/CUM/DESNUM	/CUM/DESNUM	CHAR	12	0	CU: Design Number	*
139	.INCLU--AP	☐				0	0	DFPS - Additional Fields
140	DFPS_CP	☐	/ISDFPS/PM_CP_ICON	TV_IMAGE	CHAR	46	0	PM: Distributed Maintenance - Change Authorization
141	DFPS_CP_SYS	☐	/ISDFPS/LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
142	DFPS_CP_SYST	☐	COMT_LOGSYST	TEXT40	CHAR	40	0	Description of Logical System
143	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
144	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	*
145	AUFNR_EXT	☐	AUFNR_EXT	CHAR12	CHAR	12	0	External Representation for Order
146	KOSTV_EXT	☐	AUFKOSTV_EXT		CHAR	20	0	Enterprise Search Cost center
147	EQUNR_EXT	☐	EQUNR_TREX		CHAR	18	0	Equipment number
148	BAUTL_EXT	☐	BAUTL_EXT		CHAR	20	0	Assembly external Rep
149	KUNUM_EXT	☐	KUNNR_TREX		CHAR	10	0	Enterprise Search Customer
150	KOSTL_EXT	☐	AUFKOSTV_EXT		CHAR	20	0	Enterprise Search Cost center
151	ANLNR_EXT	☐	ANLN1_EXT		CHAR	20	0	Main Asset Number
152	ANLUN_EXT	☐	ANLN2_EXT		CHAR	4	0	External Representation for Asset Subnumber
153	WARPL_EXT	☐	WARPL_EXT		CHAR	12	0	External Representation Maintenance Plan
154	WAPOS_EXT	☐	WAPOS_EXT		CHAR	16	0	Maintenance item
155	QMNUM_EXT	☐	ESO_DE_QMNUM_EXT	CHAR12	CHAR	12	0	External Representation For Notification
156	KDAUF_EXT	☐	KDAUF_EXT		CHAR	10	0	External Representation for Sales Order Number
157	LEAD_AUFNR_EXT	☐	CO_LAUFNR_EXT		CHAR	12	0	External representation Leading order in current processing
158	SERIALNR_EXT	☐	GERNR_EXT		CHAR	18	0	External representation for Serial number
159	MEINS_EXT	☐	MEINS_EXT		CHAR	3	0	External Representation for Base Unit of Measure
160	PRCTR_EXT	☐	PRCTR_EXT		CHAR	4	0	External Representation for Profit Center
161	PSPEL_EXT	☐	PS_PSP_ELE_EXT		CHAR	24	0	External Rep .Work breakdown structure element (WBS element)
162	SERMAT_EXT	☐	MATNR_TREX		CHAR	40	0	External Long Material Number
163	TPLNR_EXT	☐	TPLNR_TREX		CHAR	40	0	Functional Location
164	STAT_OUTSTND	☐	ESO_STAT_OUTSTAND	XFELD	CHAR	1	0	Status: Outstanding
165	STAT_INPROC	☐	ESO_STAT_INPROC	XFELD	CHAR	1	0	Status: In Process
166	STAT_COMPL	☐	ESO_STAT_COMPL	XFELD	CHAR	1	0	Status: Completed
167	STAT_HIST	☐	ESO_STAT_HISTOR	XFELD	CHAR	1	0	Status: Historical

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ESO_S_RIHAUFK_LIST	ABCKZ	T370C	ABCKZ
2	ESO_S_RIHAUFK_LIST	ANLNR	ANLH	ANLN1
3	ESO_S_RIHAUFK_LIST	ANLUN	ANLA	ANLN2
4	ESO_S_RIHAUFK_LIST	ANLZU	T357M	ANLZU
5	ESO_S_RIHAUFK_LIST	APGRP	T024A	FEVOR
6	ESO_S_RIHAUFK_LIST	AUART	T003O	AUART
7	ESO_S_RIHAUFK_LIST	AUFNR	AUFK	AUFNR
8	ESO_S_RIHAUFK_LIST	AWERK	T001W	WERKS
9	ESO_S_RIHAUFK_LIST	BAUTL	MARA	MATNR
10	ESO_S_RIHAUFK_LIST	BEBER	T357	BEBER
11	ESO_S_RIHAUFK_LIST	BUKRS	T001	BUKRS
12	ESO_S_RIHAUFK_LIST	EQUNR	EQUI	EQUNR
13	ESO_S_RIHAUFK_LIST	FEVOR	T024A	FEVOR
14	ESO_S_RIHAUFK_LIST	GSBER	TGSB	GSBER
15	ESO_S_RIHAUFK_LIST	ILART	T353I	ILART
16	ESO_S_RIHAUFK_LIST	INGPR	T024I	INGRP
17	ESO_S_RIHAUFK_LIST	IWERK	T001W	WERKS
18	ESO_S_RIHAUFK_LIST	KDAUF	VBUK	VBELN
19	ESO_S_RIHAUFK_LIST	KDPOS	VBUP	POSNR
20	ESO_S_RIHAUFK_LIST	KOKRS	TKA01	KOKRS
21	ESO_S_RIHAUFK_LIST	KOSTL	CSKS	KOSTL
22	ESO_S_RIHAUFK_LIST	KOSTV	CSKS	KOSTL
23	ESO_S_RIHAUFK_LIST	KUNUM	KNA1	KUNNR
24	ESO_S_RIHAUFK_LIST	LEAD_AUFNR	AUFK	AUFNR
25	ESO_S_RIHAUFK_LIST	MANDT	T000	MANDT
26	ESO_S_RIHAUFK_LIST	MAUFNR	AUFK	AUFNR
27	ESO_S_RIHAUFK_LIST	OBJNR	ONR00	OBJNR
28	ESO_S_RIHAUFK_LIST	QMNUM	QMEL	QMNUM
29	ESO_S_RIHAUFK_LIST	REVNR	T352R	REVNR
30	ESO_S_RIHAUFK_LIST	STORT	T499S	STAND
31	ESO_S_RIHAUFK_LIST	SWERK	T001W	WERKS
32	ESO_S_RIHAUFK_LIST	WAERS	TCURC	WAERS
33	ESO_S_RIHAUFK_LIST	WARPL	MPLA	WARPL
34	ESO_S_RIHAUFK_LIST	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in	604