SAP ABAP Table /ISDFPS/RIHEQUI_SMALL (Transfer Data for Equipment Hierarchy)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ PM-WOC (Application Component) Maintenance Processing
     ⤷ /ISDFPS/PM (Package) SDP BW Enhancements in PM

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/RIHEQUI_SMALL	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	KRFKZ	☐	KRFKZ	X	CHAR	1	0	Referenced Configuration
29	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
30	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
31	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
32	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
33	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
34	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
35	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	T005
36	HZEIN	☐	HZEIN	HZEIN	CHAR	30	0	Manufacturer drawing number
37	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
38	KUND1	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	KNA1
39	KUND2	☐	KUND2	KUNNR	CHAR	10	0	End customer number	KNA1
40	KUND3	☐	KUND3	KUNNR	CHAR	10	0	Operator	KNA1
41	LIZNR	☐	LIZNR	CHAR20	CHAR	20	0	Equipment license number
42	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
43	GEWRK	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
44	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
45	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
46	AEDAZ	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
47	AENAZ	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
48	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
49	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
50	KMATN	☐	KMATN	MATNR	CHAR	18	0	Configurable Material	*
51	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
52	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
53	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
54	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
55	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
56	KUNDE	☐	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered	*
57	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
58	STTXT	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
59	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
60	USTXT	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
61	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
62	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
63	PROID	☐	I_PM_POSID	CHAR24	CHAR	24	0	Work Breakdown Structure Element (WBS Element) for List
64	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
65	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
66	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
67	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
68	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
69	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
70	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
71	.INCLUDE	☐				0	0	Display Structure Reporting PM Address Data
72	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
73	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
74	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
75	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
76	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
77	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
78	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
79	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
80	RKEOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
81	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
82	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
83	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
84	.INCLUDE	☐				0	0	Warranty Data for Technical Object List EditingPM/SM
85	GWLDT_K	☐	IGWLDT_K	DATUM	DATS	8	0	Customer Warranty Start
86	GWLEN_K	☐	IGWLEN_K	DATUM	DATS	8	0	Warranty End for Customer
87	MGANR_K	☐	IMGANR_K	MGANR	CHAR	20	0	Master Warranty Number for Customer	*
88	GARTX_K	☐	IGARTXL_K	TXT40	CHAR	40	0	Customer Warranty Description
89	GWLDT_L	☐	IGWLDT_L	DATUM	DATS	8	0	Vendor Warranty Start
90	GWLEN_L	☐	IGWLEN_L	DATUM	DATS	8	0	Warranty End for Vendor
91	MGANR_L	☐	IMGANR_L	MGANR	CHAR	20	0	Master Warranty Number for Vendor	*
92	GARTX_L	☐	IGARTXL_L	TXT40	CHAR	40	0	Vendor Warranty Description
93	AULDT	☐	AULDT	DATUM	DATS	8	0	First delivery date of the equipment
94	INBDT	☐	INBDT	DATUM	DATS	8	0	First start-up date
95	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
96	SUBMTKTX	☐	SUBMTKTX	TXT40	CHAR	40	0	Construction Type Description
97	EQUZ_ERDAT	☐	EQUZ_ERDAT	DATUM	DATS	8	0	Date on which the time segment was created
98	EQUZ_ERNAM	☐	EQUZ_ERNAM	USNAM	CHAR	12	0	Name of person who created time segment
99	EQUZ_AEDAT	☐	EQUZ_AEDAT	DATUM	DATS	8	0	Date on which time segment was changed
100	EQUZ_AENAM	☐	EQUZ_AENAM	USNAM	CHAR	12	0	Name of person who changed the time segment
101	EQUZN	☐	EQNNR	NUM03	NUMC	3	0	Number of next EquipUsagePeriod on same day

Foreign Keys

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

History

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