SAP ABAP Table RIHEQUI (Transfer data for equipment hierarchy)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSE (Application Component) Mobile Service
     ⤷ ILOM (Package) Application Development R/3 Location Management

Basic Data

Table Category	INTTAB	Structure
Structure	RIHEQUI	Table Relationship Diagram
Short Description	Transfer data for equipment hierarchy

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	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
2	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
3	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
4	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	T370T
5	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T001W
6	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
7	STORT	☐	STORT	AP_STAND	CHAR	10	0	Asset location	T499S
8	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
9	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
10	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
11	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
12	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
13	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
14	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
15	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
16	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
17	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
18	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
19	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
20	TIDNR	☐	TIDNR	TIDNR	CHAR	25	0	Technical identification number
21	HEQUI	☐	HEQUI	EQUNR	CHAR	18	0	Superordinate Equipment	EQUI
22	HEQNR	☐	HEQNR	CHAR4	CHAR	4	0	Equipment position at InstallLoc (Superior Equip./FunctLoc)
23	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
24	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
25	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
26	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
27	ELIEF	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number	LFA1
28	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
29	KRFKZ	☐	KRFKZ	X	CHAR	1	0	Referenced Configuration
30	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
31	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
32	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
33	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
34	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
35	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
36	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
37	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	T005
38	HZEIN	☐	HZEIN	HZEIN	CHAR	30	0	Manufacturer drawing number
39	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
40	KUND1	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	KNA1
41	KUND2	☐	KUND2	KUNNR	CHAR	10	0	End customer number	KNA1
42	KUND3	☐	KUND3	KUNNR	CHAR	10	0	Operator	KNA1
43	LIZNR	☐	LIZNR	CHAR20	CHAR	20	0	Equipment license number
44	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
45	GEWRK	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
46	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
47	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
48	AEDAZ	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
49	AENAZ	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
50	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
51	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
52	KMATN	☐	KMATN	MATNR	CHAR	18	0	Configurable Material	*
53	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
54	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
55	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
56	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
57	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
58	KUNDE	☐	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered	*
59	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
60	STTXT	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
61	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
62	USTXT	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
63	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
64	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
65	PROID	☐	I_PM_POSID	CHAR24	CHAR	24	0	Work Breakdown Structure Element (WBS Element) for List
66	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
67	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
68	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
69	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
70	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
71	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
72	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
73	.INCLUDE	☐				0	0	Display Structure Reporting PM Address Data
74	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
75	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
76	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
77	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
78	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
79	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
80	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
81	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
82	RKEOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
83	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
84	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
85	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
86	.INCLUDE	☐				0	0	Warranty Data for Technical Object List EditingPM/SM
87	GWLDT_K	☐	IGWLDT_K	DATUM	DATS	8	0	Customer Warranty Start
88	GWLEN_K	☐	IGWLEN_K	DATUM	DATS	8	0	Warranty End for Customer
89	MGANR_K	☐	IMGANR_K	MGANR	CHAR	20	0	Master Warranty Number for Customer	*
90	GARTX_K	☐	IGARTXL_K	TXT40	CHAR	40	0	Customer Warranty Description
91	GWLDT_L	☐	IGWLDT_L	DATUM	DATS	8	0	Vendor Warranty Start
92	GWLEN_L	☐	IGWLEN_L	DATUM	DATS	8	0	Warranty End for Vendor
93	MGANR_L	☐	IMGANR_L	MGANR	CHAR	20	0	Master Warranty Number for Vendor	*
94	GARTX_L	☐	IGARTXL_L	TXT40	CHAR	40	0	Vendor Warranty Description
95	AULDT	☐	AULDT	DATUM	DATS	8	0	First delivery date of the equipment
96	INBDT	☐	INBDT	DATUM	DATS	8	0	First start-up date
97	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
98	SUBMTKTX	☐	SUBMTKTX	TXT40	CHAR	40	0	Construction Type Description
99	EQUZ_ERDAT	☐	EQUZ_ERDAT	DATUM	DATS	8	0	Date on which the time segment was created
100	EQUZ_ERNAM	☐	EQUZ_ERNAM	USNAM	CHAR	12	0	Name of person who created time segment
101	EQUZ_AEDAT	☐	EQUZ_AEDAT	DATUM	DATS	8	0	Date on which time segment was changed
102	EQUZ_AENAM	☐	EQUZ_AENAM	USNAM	CHAR	12	0	Name of person who changed the time segment
103	EQUZN	☐	EQNNR	NUM03	NUMC	3	0	Number of next EquipUsagePeriod on same day
104	TIMBI	☐	TIMBI	ZEITBI	TIMS	6	0	Equipment usage period time stamp
105	.INCLU--AP	☐				0	0	Item Unique Identification Fields for RIHEQUI
106	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
107	IUID_TYPE	☐	IUID_TYPE	IUID_TYPE	CHAR	10	0	Structure Type of UII	*
108	UII_PLANT	☐	UII_PLANT	WERKS	CHAR	4	0	Plant Responsible for UII	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RIHEQUI	ABCKZ	T370C	ABCKZ
2	RIHEQUI	ANLNR	ANLH	ANLN1
3	RIHEQUI	ANLUN	ANLA	ANLN2
4	RIHEQUI	AUFNR	AUFK	AUFNR
5	RIHEQUI	BEBER	T357	BEBER
6	RIHEQUI	BEGRU	T370B	BEGRU
7	RIHEQUI	BUKRS	T001	BUKRS
8	RIHEQUI	DAUFN	AUFK	AUFNR
9	RIHEQUI	ELIEF	LFA1	LIFNR
10	RIHEQUI	EQART	T370K	EQART
11	RIHEQUI	EQTYP	T370T	EQTYP
12	RIHEQUI	EQUNR	EQUI	EQUNR
13	RIHEQUI	GEWEI	T006	MSEHI
14	RIHEQUI	GSBER	TGSB	GSBER
15	RIHEQUI	HEQUI	EQUI	EQUNR
16	RIHEQUI	HERLD	T005	LAND1
17	RIHEQUI	ILOAN	ILOA	ILOAN
18	RIHEQUI	INGRP	T024I	INGRP
19	RIHEQUI	IWERK	T001W	WERKS
20	RIHEQUI	KUND1	KNA1	KUNNR
21	RIHEQUI	KUND2	KNA1	KUNNR
22	RIHEQUI	KUND3	KNA1	KUNNR
23	RIHEQUI	OBJNR	ONR00	OBJNR
24	RIHEQUI	RBNR	T352B	RBNR
25	RIHEQUI	SPART	TSPA	SPART
26	RIHEQUI	SPRAS	T002	SPRAS
27	RIHEQUI	STORT	T499S	STAND
28	RIHEQUI	SUBMT	MARA	MATNR
29	RIHEQUI	SWERK	T001W	WERKS
30	RIHEQUI	TPLNR	IFLOT	TPLNR
31	RIHEQUI	VKORG	TVKO	VKORG
32	RIHEQUI	VTWEG	TVTW	VTWEG
33	RIHEQUI	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in