SAP ABAP Table PLM_ALM_SEARCH_BUSEQUI (PLM: Structure for Search MiniApp BUS0010 (External))

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_BUSEQUI	Table Relationship Diagram
Short Description	PLM: Structure for Search MiniApp BUS0010 (External)

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	Transfer data for equipment hierarchy
10	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
11	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
12	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
13	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	T370T
14	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T001W
15	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
16	STORT	☐	STORT	AP_STAND	CHAR	10	0	Asset location	T499S
17	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
18	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
19	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
20	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
21	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
22	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
23	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
24	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
25	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
26	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
27	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
28	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
29	TIDNR	☐	TIDNR	TIDNR	CHAR	25	0	Technical identification number
30	HEQUI	☐	HEQUI	EQUNR	CHAR	18	0	Superordinate Equipment	EQUI
31	HEQNR	☐	HEQNR	CHAR4	CHAR	4	0	Equipment position at InstallLoc (Superior Equip./FunctLoc)
32	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
33	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
34	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
35	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
36	ELIEF	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number	LFA1
37	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
38	KRFKZ	☐	KRFKZ	X	CHAR	1	0	Referenced Configuration
39	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
40	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
41	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
42	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
43	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
44	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
45	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
46	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	T005
47	HZEIN	☐	HZEIN	HZEIN	CHAR	30	0	Manufacturer drawing number
48	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
49	KUND1	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	KNA1
50	KUND2	☐	KUND2	KUNNR	CHAR	10	0	End customer number	KNA1
51	KUND3	☐	KUND3	KUNNR	CHAR	10	0	Operator	KNA1
52	LIZNR	☐	LIZNR	CHAR20	CHAR	20	0	Equipment license number
53	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
54	GEWRK	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
55	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
56	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
57	AEDAZ	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
58	AENAZ	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
59	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
60	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
61	KMATN	☐	KMATN	MATNR	CHAR	18	0	Configurable Material	*
62	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
63	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
64	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
65	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
66	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
67	KUNDE	☐	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered	*
68	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
69	STTXT	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
70	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
71	USTXT	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
72	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
73	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
74	PROID	☐	I_PM_POSID	CHAR24	CHAR	24	0	Work Breakdown Structure Element (WBS Element) for List
75	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
76	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
77	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
78	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
79	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
80	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
81	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
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	RKEOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
92	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
93	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
94	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
95	.INCLUDE	☐				0	0	Warranty Data for Technical Object List EditingPM/SM
96	GWLDT_K	☐	IGWLDT_K	DATUM	DATS	8	0	Customer Warranty Start
97	GWLEN_K	☐	IGWLEN_K	DATUM	DATS	8	0	Warranty End for Customer
98	MGANR_K	☐	IMGANR_K	MGANR	CHAR	20	0	Master Warranty Number for Customer	*
99	GARTX_K	☐	IGARTXL_K	TXT40	CHAR	40	0	Customer Warranty Description
100	GWLDT_L	☐	IGWLDT_L	DATUM	DATS	8	0	Vendor Warranty Start
101	GWLEN_L	☐	IGWLEN_L	DATUM	DATS	8	0	Warranty End for Vendor
102	MGANR_L	☐	IMGANR_L	MGANR	CHAR	20	0	Master Warranty Number for Vendor	*
103	GARTX_L	☐	IGARTXL_L	TXT40	CHAR	40	0	Vendor Warranty Description
104	AULDT	☐	AULDT	DATUM	DATS	8	0	First delivery date of the equipment
105	INBDT	☐	INBDT	DATUM	DATS	8	0	First start-up date
106	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
107	SUBMTKTX	☐	SUBMTKTX	TXT40	CHAR	40	0	Construction Type Description
108	EQUZ_ERDAT	☐	EQUZ_ERDAT	DATUM	DATS	8	0	Date on which the time segment was created
109	EQUZ_ERNAM	☐	EQUZ_ERNAM	USNAM	CHAR	12	0	Name of person who created time segment
110	EQUZ_AEDAT	☐	EQUZ_AEDAT	DATUM	DATS	8	0	Date on which time segment was changed
111	EQUZ_AENAM	☐	EQUZ_AENAM	USNAM	CHAR	12	0	Name of person who changed the time segment
112	EQUZN	☐	EQNNR	NUM03	NUMC	3	0	Number of next EquipUsagePeriod on same day
113	TIMBI	☐	TIMBI	ZEITBI	TIMS	6	0	Equipment usage period time stamp
114	.INCLU--AP	☐				0	0	Item Unique Identification Fields for RIHEQUI
115	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
116	IUID_TYPE	☐	IUID_TYPE	IUID_TYPE	CHAR	10	0	Structure Type of UII	*
117	UII_PLANT	☐	UII_PLANT	WERKS	CHAR	4	0	Plant Responsible for UII	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PLM_ALM_SEARCH_BUSEQUI	ABCKZ	T370C	ABCKZ
2	PLM_ALM_SEARCH_BUSEQUI	ANLNR	ANLH	ANLN1
3	PLM_ALM_SEARCH_BUSEQUI	ANLUN	ANLA	ANLN2
4	PLM_ALM_SEARCH_BUSEQUI	AUFNR	AUFK	AUFNR
5	PLM_ALM_SEARCH_BUSEQUI	BEBER	T357	BEBER
6	PLM_ALM_SEARCH_BUSEQUI	BEGRU	T370B	BEGRU
7	PLM_ALM_SEARCH_BUSEQUI	BUKRS	T001	BUKRS
8	PLM_ALM_SEARCH_BUSEQUI	DAUFN	AUFK	AUFNR
9	PLM_ALM_SEARCH_BUSEQUI	ELIEF	LFA1	LIFNR
10	PLM_ALM_SEARCH_BUSEQUI	EQART	T370K	EQART
11	PLM_ALM_SEARCH_BUSEQUI	EQTYP	T370T	EQTYP
12	PLM_ALM_SEARCH_BUSEQUI	EQUNR	EQUI	EQUNR
13	PLM_ALM_SEARCH_BUSEQUI	GEWEI	T006	MSEHI
14	PLM_ALM_SEARCH_BUSEQUI	GSBER	TGSB	GSBER
15	PLM_ALM_SEARCH_BUSEQUI	HEQUI	EQUI	EQUNR
16	PLM_ALM_SEARCH_BUSEQUI	HERLD	T005	LAND1
17	PLM_ALM_SEARCH_BUSEQUI	ILOAN	ILOA	ILOAN
18	PLM_ALM_SEARCH_BUSEQUI	INGRP	T024I	INGRP
19	PLM_ALM_SEARCH_BUSEQUI	IWERK	T001W	WERKS
20	PLM_ALM_SEARCH_BUSEQUI	KUND1	KNA1	KUNNR
21	PLM_ALM_SEARCH_BUSEQUI	KUND2	KNA1	KUNNR
22	PLM_ALM_SEARCH_BUSEQUI	KUND3	KNA1	KUNNR
23	PLM_ALM_SEARCH_BUSEQUI	OBJNR	ONR00	OBJNR
24	PLM_ALM_SEARCH_BUSEQUI	RBNR	T352B	RBNR
25	PLM_ALM_SEARCH_BUSEQUI	SPART	TSPA	SPART
26	PLM_ALM_SEARCH_BUSEQUI	SPRAS	T002	SPRAS
27	PLM_ALM_SEARCH_BUSEQUI	STORT	T499S	STAND
28	PLM_ALM_SEARCH_BUSEQUI	SUBMT	MARA	MATNR
29	PLM_ALM_SEARCH_BUSEQUI	SWERK	T001W	WERKS
30	PLM_ALM_SEARCH_BUSEQUI	TPLNR	IFLOT	TPLNR
31	PLM_ALM_SEARCH_BUSEQUI	VKORG	TVKO	VKORG
32	PLM_ALM_SEARCH_BUSEQUI	VTWEG	TVTW	VTWEG
33	PLM_ALM_SEARCH_BUSEQUI	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in