SAP ABAP Table IB0003 (IB: Equipment detail data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CS-IB (Application Component) Installed Base Management
     ⤷ IB07 (Package) IBase: Object-Specific Screen Components

Basic Data

Table Category	INTTAB	Structure
Structure	IB0003	Table Relationship Diagram
Short Description	IB: Equipment detail data

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

History

Last changed by/on	SAP	20130529
SAP Release Created in