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

History

Last changed by/on	SAP	20130529
SAP Release Created in