SAP ABAP Table U_30000 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_30000	Table Relationship Diagram
Short Description	Generated Table for View

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	T000
2	TPLNR	☑	TPLNR	TPLNR	CHAR	30	0	Functional Location
3	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
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	MLANG	☐	MLANG	SPRAS	LANG	1	0	Primary language for object texts	T002
8	TPLKZ	☐	TPLKZ	TPLKZ	CHAR	5	0	Functional location structure indicators	T370S
9	FLTYP	☐	FLTYP	FLTYP	CHAR	1	0	Functional Location Category	T370F
10	TPLMA	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	IFLOT
11	ERDAT	☐	ICRDT	DATUM	DATS	8	0	Date on Which Object Was Created
12	ERNAM	☐	ICRNA	USNAM	CHAR	12	0	Name of User Who Created the Object
13	AEDAT	☐	IUPDT	DATUM	DATS	8	0	Date on which the object was last changed
14	AENAM	☐	IUPNA	USNAM	CHAR	12	0	Name of the User Who Last Changed the Object
15	DATAB	☐	ILOM_DATAB	DATUM	DATS	8	0	Start-up Date of the Technical Object
16	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
17	TRPNR	☐	TRPNR	TRPNR	CHAR	30	0	Reference functional location	IRLOT
18	PSTAE	☐	RESERVE_CHAR_004	CHAR4	CHAR	4	0	SAP Development reserve: Format CHAR, length 4
19	STNAM	☐	RESERVE_CHAR_012	CHAR12	CHAR	12	0	SAP Development Reserve: Format CHAR, Length 12
20	LVORM	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
21	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
22	SUBMTI	☐	INH_SUBMTI	INHER	CHAR	1	0	Data origin for construction type field
23	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
24	MAPARI	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
25	IEQUI	☐	IEQUI	X	CHAR	1	0	Installation of equipment allowed at the functional location
26	IEQUII	☐	INH_IEQUII	INHER	CHAR	1	0	Data origin for equip. inst. allowed field
27	EINZL	☐	EINZL	XFELD	CHAR	1	0	Single equipment installation at functional location
28	EINZLI	☐	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
29	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
30	IWERKI	☐	INH_IWERKI	INHER	CHAR	1	0	Data origin for planning plant field
31	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
32	INGRPI	☐	INH_INGRPI	INHER	CHAR	1	0	Data origin for maintenance planner group field
33	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
34	LGWID	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
35	LGWIDI	☐	INH_LGWIDI	INHER	CHAR	1	0	Data Origin for the Field 'Work Center'
36	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
37	RBNR_I	☐	INH_RBNR_I	INHER	CHAR	1	0	Data origin for maintenance catalog field
38	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
39	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
40	POSNR	☐	ILOM_POSNR	CHAR4	CHAR	4	0	Position in superior technical object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_30000	BEGRU	T370B	BEGRU	REF	C	CN
2	U_30000	FLTYP	T370F	FLTYP	REF	1	CN
3	U_30000	ILOAN	ILOA	ILOAN	REF	C	CN
4	U_30000	INGRP	T024I	INGRP	REF	C	CN
5	U_30000	IWERK	T399I	IWERK	REF	C	CN
6	U_30000	LGWID	CRID	OBJID	REF	C	CN
7	U_30000	MANDT	T000	MANDT	KEY	1	CN
8	U_30000	MLANG	T002	SPRAS	REF	C	CN
9	U_30000	OBJNR	ONR00	OBJNR	REF	C	1
10	U_30000	RBNR	T352B	RBNR	REF	C	CN
11	U_30000	SPRAS	T002	SPRAS	KEY	1	CN
12	U_30000	SUBMT	MARA	MATNR	REF	C	CN
13	U_30000	TPLKZ	T370S	TPLKZ	REF	1	CN
14	U_30000	TPLMA	IFLOT	TPLNR	REF	C	CN
15	U_30000	TRPNR	IRLOT	TRPNR	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in