SAP ABAP Table IB0014 (IB: Detail Data for Functional Location)

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	IB0014	Table Relationship Diagram
Short Description	IB: Detail Data for Functional Location

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	Functional location: Output structure for ABAP lists
3	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
4	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
5	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
6	FLTYP	☐	FLTYP	FLTYP	CHAR	1	0	Functional Location Category	T370F
7	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T001W
8	IWERKI	☐	INH_IWERKI	INHER	CHAR	1	0	Data origin for planning plant field
9	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
10	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
11	STORT	☐	STORT	AP_STAND	CHAR	10	0	Asset location	T499S
12	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
13	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
14	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
15	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
16	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
17	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
18	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
19	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
20	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
21	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
22	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
23	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
24	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
25	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
26	RKEOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
27	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
28	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
29	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
30	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
31	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
32	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
33	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
34	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
35	TRPNR	☐	TRPNR	TRPNR	CHAR	30	0	Reference functional location	IRLOT
36	TPLKZ	☐	TPLKZ	TPLKZ	CHAR	5	0	Functional location structure indicators	T370S
37	IEQUI	☐	IEQUI	X	CHAR	1	0	Installation of equipment allowed at the functional location
38	IEQUII	☐	INH_IEQUII	INHER	CHAR	1	0	Data origin for equip. inst. allowed field
39	EINZL	☐	EINZL	XFELD	CHAR	1	0	Single equipment installation at functional location
40	EINZLI	☐	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
41	TPLMA	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	IFLOT
42	POSNR	☐	ILOM_POSNR	CHAR4	CHAR	4	0	Position in superior technical object
43	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
44	SUBMTI	☐	INH_SUBMTI	INHER	CHAR	1	0	Data origin for construction type field
45	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
46	MAPARI	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
47	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
48	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
49	GEWRK	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
50	LGWIDI	☐	INH_LGWIDI	INHER	CHAR	1	0	Data Origin for the Field 'Work Center'
51	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
52	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
53	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
54	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
55	DATAB	☐	ILOM_DATAB	DATUM	DATS	8	0	Start-up Date of the Technical Object
56	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
57	LVORM	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
58	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
59	RBNR_I	☐	INH_RBNR_I	INHER	CHAR	1	0	Data origin for maintenance catalog field
60	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
61	INGRPI	☐	INH_INGRPI	INHER	CHAR	1	0	Data origin for maintenance planner group field
62	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
63	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
64	PROID	☐	I_PM_POSID	CHAR24	CHAR	24	0	Work Breakdown Structure Element (WBS Element) for List	*
65	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
66	STTXT	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
67	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
68	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
69	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
70	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
71	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
72	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
73	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
74	USTXT	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
85	ADRNR	☐	CADRNR	CADRNR	CHAR	10	0	Addresses: Address number of company address	*
86	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
87	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
88	KZLTX	☐	ILOM_KZLTX	X	CHAR	1	0	Indicator: Long text exists
89	SUBMTKTX	☐	SUBMTKTX	TXT40	CHAR	40	0	Construction Type Description
90	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	*
91	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
92	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
93	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
94	GROES	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
95	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
96	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
97	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
98	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
99	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	*
100	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
101	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
102	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
103	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
104	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
105	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
106	STRNO	☐	ILOM_STRNO	ILOM_STRNO	CHAR	40	0	Functional location label

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IB0014	ABCKZ	T370C	ABCKZ
2	IB0014	ANLNR	ANLH	ANLN1
3	IB0014	ANLUN	ANLA	ANLN2
4	IB0014	AUFNR	AUFK	AUFNR
5	IB0014	BEBER	T357	BEBER
6	IB0014	BEGRU	T370B	BEGRU
7	IB0014	BUKRS	T001	BUKRS
8	IB0014	DAUFN	AUFK	AUFNR
9	IB0014	FLTYP	T370F	FLTYP
10	IB0014	GSBER	TGSB	GSBER
11	IB0014	ILOAN	ILOA	ILOAN
12	IB0014	INGRP	T024I	INGRP
13	IB0014	IWERK	T001W	WERKS
14	IB0014	KOKRS	TKA01	KOKRS
15	IB0014	KOSTL	CSKS	KOSTL
16	IB0014	MANDT	T000	MANDT
17	IB0014	OBJNR	ONR00	OBJNR
18	IB0014	RBNR	T352B	RBNR
19	IB0014	SPART	TSPA	SPART
20	IB0014	SPRAS	T002	SPRAS
21	IB0014	STORT	T499S	STAND
22	IB0014	SUBMT	MARA	MATNR
23	IB0014	SWERK	T001W	WERKS
24	IB0014	TPLKZ	T370S	TPLKZ
25	IB0014	TPLMA	IFLOT	TPLNR
26	IB0014	TRPNR	IRLOT	TRPNR
27	IB0014	VKORG	TVKO	VKORG
28	IB0014	VTWEG	TVTW	VTWEG

History

Last changed by/on	SAP	20130529
SAP Release Created in