SAP ABAP Table /ISDFPS/ITOB (Distribution of Data for Functional Locations)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-PDR (Application Component) Master Data Distribution
     ⤷ /ISDFPS/UPS_EXTENSIONS_ASSET (Package) Asset Objects in UPS

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/ITOB	Table Relationship Diagram
Short Description	Distribution of Data for Functional Locations

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	Generated Table for View
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
4	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
7	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	*
9	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	*
10	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	*
11	LVORM	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
12	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
13	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
14	BRGEW	☐	OBJ_WEIGHT	MENG13	QUAN	13	3	Weight of object
15	GEWEI	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	*
16	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
17	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
18	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
19	ELIEF	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number	*
20	GWLEN	☐	GWLEN	DATUM	DATS	8	0	Date on which the warranty ends
21	GWLDT	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
22	WDBWT	☐	WDBWT	WERT	CURR	13	2	Equipment replacement value
23	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
24	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	*
25	HZEIN	☐	HZEIN	HZEIN	CHAR	30	0	Manufacturer drawing number
26	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
27	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
28	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
29	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
30	APLKZ	☐	APLKZ	APLKZ	CHAR	1	0	Indicator: Task List Exists
31	AULDT	☐	AULDT	DATUM	DATS	8	0	First delivery date of the equipment
32	INBDT	☐	ILOM_DATAB	DATUM	DATS	8	0	Start-up Date of the Technical Object
33	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
34	GWLDV	☐	GWLDV	DATUM	DATS	8	0	Warranty date for Sales and Distribution
35	EQDAT	☐	EQDAT	DATUM	DATS	8	0	Date
36	EQBER	☐	EQBER	CHAR30	CHAR	30	0	Text for Notes
37	EQNUM	☐	EQNUM	NUM9	NUMC	9	0	Numerical Field
38	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
39	EQSNR	☐	EQSNR	EQSNR	CHAR	18	0	EQSE Number	*
40	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
41	KRFKZ	☐	KRFKZ	X	CHAR	1	0	Referenced Configuration
42	KMATN	☐	KMATN	MATNR	CHAR	18	0	Configurable Material	*
43	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
44	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
45	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
46	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
47	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
48	KUNDE	☐	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered	*
49	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	*
50	IMRC_POINT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	*
51	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
52	MGANR	☐	MGANR	MGANR	CHAR	20	0	Master warranty number	*
53	BEGRUI	☐	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
54	S_EQUI	☐	EQUIP_KNZ	X	CHAR	1	0	Equipment
55	S_SERIAL	☐	KZKSD	X	CHAR	1	0	Serial data when maintaining equipment
56	S_KONFI	☐	KONFKNZ	XFELD	CHAR	1	0	Configuration supported
57	S_SALE	☐	SDKNZ	XFELD	CHAR	1	0	Sales equipment
58	S_FHM	☐	FHMKZ	XFLAG	CHAR	1	0	Equip. category relevant to production resources and tools
59	S_ELSE	☐	ELSE_KNZ	X	CHAR	1	0	Indicator: Other Data Active
60	S_ISU	☐	ISU_KNZ	X	CHAR	1	0	IS-U data
61	S_EQBS	☐	KZEQBS	KZEQBS	CHAR	1	0	EQSI Exists
62	S_FLEET	☐	FLEET_KNZ	X	CHAR	1	0	Indicator: Fleet object active
63	BSTVP	☐	BSTVP	BSTVP	CHAR	1	0	Stock Check for Serial Numbers
64	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	*
65	HANDLE	☐	ITOBTMP_TSEGGUID	SYSUUID_22	CHAR	22	0	SAP Development Reserve: Integration of Date Segment (Key)
66	TSEGTP	☐	ITOBTMP_TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	SAP Development Reserve: Integration Date Segment (Template)	*
67	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
68	ACT_CHANGE_AA	☐	AAPM_ACT_CHANGE_AA	AAPM_ACT	CHAR	1	0	Change Equipment Master when Changing Asset
69	S_CC	☐	CCC_KNZ	X	CHAR	1	0	Configuration Control Data
70	DATLWB	☐	DATLWB	DATS	DATS	8	0	Date of Last Goods Movement
71	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
72	IUID_TYPE	☐	IUID_TYPE	IUID_TYPE	CHAR	10	0	Structure Type of UII	TIUID_TYPE
73	UII_PLANT	☐	UII_PLANT	WERKS	CHAR	4	0	Plant Responsible for UII	*
74	EQEXT_ACTIVE	☐	/ISDFPS/DE_LM_DB_EQEXT_ACTIVE	XFELD	CHAR	1	0	Backpack Table /isdfps/lmeqext Active
75	EQUI_SRTYPE	☐	COCF_SR_SRTYPE		CHAR	10	0	Shift Report Type	COCF_CU_SRTYPE
76	EQUI_SNTYPE	☐	COCF_SN_SNTYPE	QMART	CHAR	2	0	Shift Note Type	TQ80
77	EQLB_DUTY	☐	DIACL_DUTY	XFLAG	CHAR	1	0	Logbook Duty
78	EQLB_HIDE	☐	DIACL_HIDE	XFLAG	CHAR	1	0	Hide Logbook Display
79	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
80	EQUZN	☐	EQNNR	NUM03	NUMC	3	0	Number of next EquipUsagePeriod on same day
81	TIMBI	☐	TIMBI	ZEITBI	TIMS	6	0	Equipment usage period time stamp
82	ESTAI	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
83	ESTAE	☐	RESERVE_CHAR_004	CHAR4	CHAR	4	0	SAP Development reserve: Format CHAR, length 4
84	STNAM	☐	RESERVE_CHAR_012	CHAR12	CHAR	12	0	SAP Development Reserve: Format CHAR, Length 12
85	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
86	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	*
87	IWERKI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
88	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	*
89	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
90	HEQUI	☐	HEQUI	EQUNR	CHAR	18	0	Superordinate Equipment	*
91	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	*
92	INGRPI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
93	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
94	TIDNR	☐	TIDNR	TIDNR	CHAR	25	0	Technical identification number
95	TIDNRI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
96	KUND1	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	*
97	KUND2	☐	KUND2	KUNNR	CHAR	10	0	End customer number	*
98	KUND3	☐	KUND3	KUNNR	CHAR	10	0	Operator	*
99	LIZNR	☐	LIZNR	CHAR20	CHAR	20	0	Equipment license number
100	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	*
101	EZDAT	☐	EQDAT	DATUM	DATS	8	0	Date
102	EZBER	☐	EQBER	CHAR30	CHAR	30	0	Text for Notes
103	EZNUM	☐	EQNUM	NUM9	NUMC	9	0	Numerical Field
104	RBNR_I	☐	INHER	INHER	CHAR	1	0	Data origin indicator
105	IBLNR	☐	IBLNR	BELNR	CHAR	10	0	Physical inventory document
106	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
107	PVS_FOCUS	☐	PVS_GUID_CCC	SYSUUID	RAW	16	0	Internal Identification for PVS Objects
108	PPEGUID	☐	PVS_GUID_CCC	SYSUUID	RAW	16	0	Internal Identification for PVS Objects
109	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
110	FUNCID	☐	CCC_FUNCID	CHAR40	CHAR	40	0	Function Identifier
111	FRCFIT	☐	CCC_FRCFIT	XCHAR	CHAR	1	0	Indicator: Forced Installation/Dismantling
112	FRCRMV	☐	CCC_FRCRMV	XCHAR	CHAR	1	0	Force Dismantling Flag
113	LVORM_Z	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
114	EQLFN_Z	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
115	ERDAT_Z	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
116	ERNAM_Z	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
117	AEDAT_Z	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
118	AENAM_Z	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
119	WKCTR	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	*
120	WKCTRI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
121	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
122	KZLTX	☐	KZLTA	XFELD	CHAR	1	0	Long Text Indicator
123	TXASP	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
124	SHTXT	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
125	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
126	MLANG	☐	MLANG	SPRAS	LANG	1	0	Primary language for object texts	*
127	TPLKZ	☐	TPLKZ	TPLKZ	CHAR	5	0	Functional location structure indicators	*
128	FLTYP	☐	FLTYP	FLTYP	CHAR	1	0	Functional Location Category	*
129	TPLMA	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	*
130	TRPNR	☐	TRPNR	TRPNR	CHAR	30	0	Reference functional location	*
131	PSTAE	☐	RESERVE_CHAR_004	CHAR4	CHAR	4	0	SAP Development reserve: Format CHAR, length 4
132	SUBMTI	☐	INH_SUBMTI	INHER	CHAR	1	0	Data origin for construction type field
133	MAPARI	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
134	IEQUI	☐	IEQUI	X	CHAR	1	0	Installation of equipment allowed at the functional location
135	IEQUII	☐	INH_IEQUII	INHER	CHAR	1	0	Data origin for equip. inst. allowed field
136	EINZL	☐	EINZL	XFELD	CHAR	1	0	Single equipment installation at functional location
137	POSNR	☐	ILOM_POSNR	CHAR4	CHAR	4	0	Position in superior technical object
138	ISTYP	☐	ILOM_ISTYP	ILOM_ISTYP	CHAR	1	0	Object category for Industry Solutions (IS)
139	PREMS	☐	ILOM_PREMS	CHAR10	CHAR	10	0	Premise
140	FLLB_DUTY	☐	DIACL_DUTY	XFLAG	CHAR	1	0	Logbook Duty
141	FLLB_HIDE	☐	DIACL_HIDE	XFLAG	CHAR	1	0	Hide Logbook Display
142	IFLOT_SRTYPE	☐	ILOM_SR_SRTYPE		CHAR	10	0	Shift Report Type for Object
143	IFLOT_SNTYPE	☐	ILOM_SN_SNTYPE	QMART	CHAR	2	0	Notification Type for Shift Note for Object	TQ80
144	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
145	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	*
146	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
147	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
148	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
149	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	*
150	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
151	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	*
152	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
153	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
154	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
155	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	*
156	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
157	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
158	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	*
159	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
160	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
161	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
162	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
163	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
164	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
165	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
166	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
167	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
168	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
169	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
170	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
171	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
172	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
173	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
174	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	*
175	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
176	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	*
177	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
178	TPLNRI	☐	INH_TPLNRI	INHER	CHAR	1	0	Data origin for functional location field
179	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
180	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
181	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
182	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
183	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
184	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
185	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
186	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
187	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator
188	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
189	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/ITOB	EQUI_SNTYPE	TQ80	QMART	KEY	1	CN
2	/ISDFPS/ITOB	EQUI_SRTYPE	COCF_CU_SRTYPE	SRTYPE	KEY	1	CN
3	/ISDFPS/ITOB	IFLOT_SNTYPE	TQ80	QMART	KEY	1	CN
4	/ISDFPS/ITOB	IUID_TYPE	TIUID_TYPE	IUID_TYPE

History

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