SAP ABAP Table IFLOH (FunctLocation (View) With Hierarchy Level, TPLNR From ILOA)

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	IFLOH	Table Relationship Diagram
Short Description	FunctLocation (View) With Hierarchy Level, TPLNR From ILOA

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
3	.INCLUDE	☐				0	0	Functional location data fields: Short texts
4	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
5	KZLTX	☐	ILOM_KZLTX	X	CHAR	1	0	Indicator: Long text exists
6	KZMLA	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
7	PLTXU	☐	ILOM_PLTXU	CHAR40	CHAR	40	0	Description of functional location in capital letters
8	.INCLUDE	☐				0	0	Data part functional location
9	MLANG	☐	MLANG	SPRAS	LANG	1	0	Primary language for object texts	T002
10	TPLKZ	☐	TPLKZ	TPLKZ	CHAR	5	0	Functional location structure indicators	T370S
11	FLTYP	☐	FLTYP	FLTYP	CHAR	1	0	Functional Location Category	T370F
12	TPLMA	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	IFLOT
13	ERDAT	☐	ICRDT	DATUM	DATS	8	0	Date on Which Object Was Created
14	ERNAM	☐	ICRNA	USNAM	CHAR	12	0	Name of User Who Created the Object
15	AEDAT	☐	IUPDT	DATUM	DATS	8	0	Date on which the object was last changed
16	AENAM	☐	IUPNA	USNAM	CHAR	12	0	Name of the User Who Last Changed the Object
17	DATAB	☐	ILOM_DATAB	DATUM	DATS	8	0	Start-up Date of the Technical Object
18	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
19	TRPNR	☐	TRPNR	TRPNR	CHAR	30	0	Reference functional location	IRLOT
20	PSTAE	☐	RESERVE_CHAR_004	CHAR4	CHAR	4	0	SAP Development reserve: Format CHAR, length 4
21	STNAM	☐	RESERVE_CHAR_012	CHAR12	CHAR	12	0	SAP Development Reserve: Format CHAR, Length 12
22	LVORM	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
23	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
24	SUBMTI	☐	INH_SUBMTI	INHER	CHAR	1	0	Data origin for construction type field
25	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
26	MAPARI	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
27	IEQUI	☐	IEQUI	X	CHAR	1	0	Installation of equipment allowed at the functional location
28	IEQUII	☐	INH_IEQUII	INHER	CHAR	1	0	Data origin for equip. inst. allowed field
29	EINZL	☐	EINZL	XFELD	CHAR	1	0	Single equipment installation at functional location
30	EINZLI	☐	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
31	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
32	IWERKI	☐	INH_IWERKI	INHER	CHAR	1	0	Data origin for planning plant field
33	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
34	INGRPI	☐	INH_INGRPI	INHER	CHAR	1	0	Data origin for maintenance planner group field
35	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
36	LGWID	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
37	LGWIDI	☐	INH_LGWIDI	INHER	CHAR	1	0	Data Origin for the Field 'Work Center'
38	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
39	RBNR_I	☐	INH_RBNR_I	INHER	CHAR	1	0	Data origin for maintenance catalog field
40	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
41	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
42	POSNR	☐	ILOM_POSNR	CHAR4	CHAR	4	0	Position in superior technical object
43	ISTYP	☐	ILOM_ISTYP	ILOM_ISTYP	CHAR	1	0	Object category for Industry Solutions (IS)
44	PREMS	☐	ILOM_PREMS	CHAR10	CHAR	10	0	Premise
45	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
46	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
47	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
48	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
49	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
50	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
51	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
52	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
53	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
54	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	T005
55	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
56	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
57	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
58	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
59	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
60	HANDLE	☐	ITOBTMP_TSEGGUID	SYSUUID_22	CHAR	22	0	SAP Development Reserve: Integration of Date Segment (Key)
61	TSEGTP	☐	ITOBTMP_TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	SAP Development Reserve: Integration Date Segment (Template)	*
62	.INCLUDE	☐				0	0
63	.INCLU--AP	☐				0	0	Logbook Tech.Location Append
64	FLLB_DUTY	☐	DIACL_DUTY	XFLAG	CHAR	1	0	Logbook Duty
65	FLLB_HIDE	☐	DIACL_HIDE	XFLAG	CHAR	1	0	Hide Logbook Display
66	.INCLU--AP	☐				0	0	Enhancements to Shift Note/Report
67	IFLOT_SRTYPE	☐	ILOM_SR_SRTYPE		CHAR	10	0	Shift Report Type for Object
68	IFLOT_SNTYPE	☐	ILOM_SN_SNTYPE	QMART	CHAR	2	0	Notification Type for Shift Note for Object	TQ80
69	.INCLUDE	☐				0	0	Data part location and account assignment for PM object
70	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
71	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
72	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
73	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
74	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
75	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
76	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
77	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
78	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
79	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
80	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
81	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
82	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
83	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
84	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
85	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
86	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
87	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
88	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
89	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
90	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
91	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
92	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
93	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
94	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
95	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
96	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
97	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
98	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
99	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
100	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
101	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
102	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK
103	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
104	TPLNRI	☐	INH_TPLNRI	INHER	CHAR	1	0	Data origin for functional location field
105	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
106	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
107	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
108	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
109	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
110	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
111	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
112	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
113	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator
114	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
115	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
116	.INCLUDE	☐				0	0
117	HILEV	☐	IMRC_HILEV	INT4	INT4	10	0	Hierarchy Level; Above: < 0; Below: > 0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IFLOH	ABCKZ	T370C	ABCKZ	REF	1	CN
2	IFLOH	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	IFLOH	ANLNR	ANLH	ANLN1	REF	1	CN
4	IFLOH	ANLUN	ANLA	ANLN2	REF	1	CN
5	IFLOH	AUFNR	AUFK	AUFNR	REF	1	CN
6	IFLOH	BEBER	T357	BEBER	REF	1	CN
7	IFLOH	BEGRU	T370B	BEGRU	REF	1	CN
8	IFLOH	BUKRS	T001	BUKRS	REF	1	CN
9	IFLOH	DAUFN	AUFK	AUFNR	REF	1	CN
10	IFLOH	EQART	T370K	EQART	REF	1	CN
11	IFLOH	FLTYP	T370F	FLTYP	REF	1	CN
12	IFLOH	GEWEI	T006	MSEHI	REF	1	CN
13	IFLOH	GSBER	TGSB	GSBER	REF	1	CN
14	IFLOH	HERLD	T005	LAND1	REF	1	CN
15	IFLOH	IFLOT_SNTYPE	TQ80	QMART
16	IFLOH	ILOAN	ILOA	ILOAN	KEY	1	CN
17	IFLOH	INGRP	T024I	INGRP	REF	1	CN
18	IFLOH	IWERK	T399I	IWERK	REF	1	CN
19	IFLOH	KOKRS	TKA01	KOKRS	REF	1	CN
20	IFLOH	KOSTL	CSKS	KOSTL	REF	1	CN
21	IFLOH	LGWID	CRID	OBJID	REF	1	CN
22	IFLOH	MLANG	T002	SPRAS	REF	1	CN
23	IFLOH	OBJNR	ONR00	OBJNR	KEY	1	1
24	IFLOH	PPSID	CRID	OBJID	REF	1	CN
25	IFLOH	PROID	PRPS	PSPNR	REF	1	CN
26	IFLOH	RBNR	T352B	RBNR	REF	1	CN
27	IFLOH	SPART	TVTA	SPART	REF	1	CN
28	IFLOH	STORT	T499S	STAND	REF	1	CN
29	IFLOH	SUBMT	MARA	MATNR	REF	1	CN
30	IFLOH	SWERK	T001W	WERKS	REF	1	CN
31	IFLOH	TPLKZ	T370S	TPLKZ	REF	1	CN
32	IFLOH	TPLMA	IFLOT	TPLNR	REF	1	CN
33	IFLOH	TPLNR	IFLOT	TPLNR	REF	1	CN
34	IFLOH	TRPNR	IRLOT	TRPNR	REF	1	CN
35	IFLOH	VKBUR	TVKBZ	VKBUR	REF	1	CN
36	IFLOH	VKGRP	TVBVK	VKGRP	REF	1	CN
37	IFLOH	VKORG	TVKO	VKORG	REF	1	CN
38	IFLOH	VTWEG	TVKOV	VTWEG	REF	1	CN
39	IFLOH	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in