SAP ABAP Table IFLOTH (FunctLocation (table) with hierarchy level)

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	IFLOTH	Table Relationship Diagram
Short Description	FunctLocation (table) with hierarchy level

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	.INCLUDE	☐				0	0	Functional Location (Table)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
4	.INCLUDE	☐				0	0	Data part functional location
5	MLANG	☐	MLANG	SPRAS	LANG	1	0	Primary language for object texts	T002
6	TPLKZ	☐	TPLKZ	TPLKZ	CHAR	5	0	Functional location structure indicators	T370S
7	FLTYP	☐	FLTYP	FLTYP	CHAR	1	0	Functional Location Category	T370F
8	TPLMA	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	IFLOT
9	ERDAT	☐	ICRDT	DATUM	DATS	8	0	Date on Which Object Was Created
10	ERNAM	☐	ICRNA	USNAM	CHAR	12	0	Name of User Who Created the Object
11	AEDAT	☐	IUPDT	DATUM	DATS	8	0	Date on which the object was last changed
12	AENAM	☐	IUPNA	USNAM	CHAR	12	0	Name of the User Who Last Changed the Object
13	DATAB	☐	ILOM_DATAB	DATUM	DATS	8	0	Start-up Date of the Technical Object
14	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
15	TRPNR	☐	TRPNR	TRPNR	CHAR	30	0	Reference functional location	IRLOT
16	PSTAE	☐	RESERVE_CHAR_004	CHAR4	CHAR	4	0	SAP Development reserve: Format CHAR, length 4
17	STNAM	☐	RESERVE_CHAR_012	CHAR12	CHAR	12	0	SAP Development Reserve: Format CHAR, Length 12
18	LVORM	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
19	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
20	SUBMTI	☐	INH_SUBMTI	INHER	CHAR	1	0	Data origin for construction type field
21	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
22	MAPARI	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
23	IEQUI	☐	IEQUI	X	CHAR	1	0	Installation of equipment allowed at the functional location
24	IEQUII	☐	INH_IEQUII	INHER	CHAR	1	0	Data origin for equip. inst. allowed field
25	EINZL	☐	EINZL	XFELD	CHAR	1	0	Single equipment installation at functional location
26	EINZLI	☐	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
27	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
28	IWERKI	☐	INH_IWERKI	INHER	CHAR	1	0	Data origin for planning plant field
29	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
30	INGRPI	☐	INH_INGRPI	INHER	CHAR	1	0	Data origin for maintenance planner group field
31	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
32	LGWID	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
33	LGWIDI	☐	INH_LGWIDI	INHER	CHAR	1	0	Data Origin for the Field 'Work Center'
34	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
35	RBNR_I	☐	INH_RBNR_I	INHER	CHAR	1	0	Data origin for maintenance catalog field
36	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
37	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
38	POSNR	☐	ILOM_POSNR	CHAR4	CHAR	4	0	Position in superior technical object
39	ISTYP	☐	ILOM_ISTYP	ILOM_ISTYP	CHAR	1	0	Object category for Industry Solutions (IS)
40	PREMS	☐	ILOM_PREMS	CHAR10	CHAR	10	0	Premise
41	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
42	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
43	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
44	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
45	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
46	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
47	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
48	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
49	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
50	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	T005
51	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
52	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
53	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
54	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
55	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
56	HANDLE	☐	ITOBTMP_TSEGGUID	SYSUUID_22	CHAR	22	0	SAP Development Reserve: Integration of Date Segment (Key)
57	TSEGTP	☐	ITOBTMP_TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	SAP Development Reserve: Integration Date Segment (Template)	*
58	.INCLUDE	☐				0	0
59	.INCLU--AP	☐				0	0	Logbook Tech.Location Append
60	FLLB_DUTY	☐	DIACL_DUTY	XFLAG	CHAR	1	0	Logbook Duty
61	FLLB_HIDE	☐	DIACL_HIDE	XFLAG	CHAR	1	0	Hide Logbook Display
62	.INCLU--AP	☐				0	0	Enhancements to Shift Note/Report
63	IFLOT_SRTYPE	☐	ILOM_SR_SRTYPE		CHAR	10	0	Shift Report Type for Object
64	IFLOT_SNTYPE	☐	ILOM_SN_SNTYPE	QMART	CHAR	2	0	Notification Type for Shift Note for Object	TQ80
65	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	IFLOTH	BEGRU	T370B	BEGRU	REF	C	CN
2	IFLOTH	EQART	T370K	EQART	REF	1	CN
3	IFLOTH	FLTYP	T370F	FLTYP	REF	1	CN
4	IFLOTH	GEWEI	T006	MSEHI	REF	1	CN
5	IFLOTH	HERLD	T005	LAND1	REF	1	CN
6	IFLOTH	IFLOT_SNTYPE	TQ80	QMART	KEY	1	CN
7	IFLOTH	ILOAN	ILOA	ILOAN	REF	C	CN
8	IFLOTH	INGRP	T024I	INGRP	REF	C	CN
9	IFLOTH	IWERK	T399I	IWERK	REF	C	CN
10	IFLOTH	LGWID	CRID	OBJID	REF	C	CN
11	IFLOTH	MANDT	T000	MANDT	KEY	1	CN
12	IFLOTH	MLANG	T002	SPRAS	REF	C	CN
13	IFLOTH	OBJNR	ONR00	OBJNR	REF	C	1
14	IFLOTH	RBNR	T352B	RBNR	REF	C	CN
15	IFLOTH	SUBMT	MARA	MATNR	REF	C	CN
16	IFLOTH	TPLKZ	T370S	TPLKZ	REF	1	CN
17	IFLOTH	TPLMA	IFLOT	TPLNR	REF	C	CN
18	IFLOTH	TRPNR	IRLOT	TRPNR	REF	C	CN
19	IFLOTH	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in