SAP ABAP Table PLM_ALM_SEARCH_BUS0010 (PLM: Structure for Search MiniApp BUS0010 (Internal))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PM-EQM (Application Component) Technical Objects
     ⤷ PLM_PM_OBJECTS (Package) PLM Portals: Equipment, Functional Locations

Basic Data

Table Category	INTTAB	Structure
Structure	PLM_ALM_SEARCH_BUS0010	Table Relationship Diagram
Short Description	PLM: Structure for Search MiniApp BUS0010 (Internal)

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

History

Last changed by/on	SAP	20130529
SAP Release Created in