SAP ABAP Table EAMS_S_SP_EQUI_BASIC_DATA (Business Object Equipment Basic Data)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PM (Application Component) Plant Maintenance
     ⤷ EAMS_MDP_MISC (Package) Miscellaneous for Master Data Provider

Basic Data

Table Category	INTTAB	Structure
Structure	EAMS_S_SP_EQUI_BASIC_DATA	Table Relationship Diagram
Short Description	Business Object Equipment Basic Data

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	Business Object Equipment - Identification
2	EAMS_EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
3	.INCLUDE	☐				0	0	Business Object Equipment Basic Data
4	DUMMY	☐			CHAR	1	0
5	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
6	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
7	SHTXT	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
8	STTXU	☐	ILOM_STTXU	TEXT40	CHAR	40	0	Display lines for user status
9	SLASH	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
10	.INCLUDE	☐				0	0	Business Objects: Technical Objects Manufacturer data
11	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
12	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
13	MAPAR	☐	MAPAR	MAPAR	CHAR	30	0	Manufacturer part number
14	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
15	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	T005
16	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
17	BAUMM	☐	EAM_MONTH12	EAM_MONTH12	CHAR	2	0	Month
18	.INCLUDE	☐				0	0	Business Object : Technical Object Reference Data
19	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
20	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
21	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
22	.INCLUDE	☐				0	0	Business Object: Technical Object Location Data
23	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
24	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	*
25	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
26	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	*
27	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
28	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
29	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
30	.INCLUDE	☐				0	0	Business Object: Technical Object Organization Data
31	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T001W
32	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
33	GEWRK	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
34	WERGW	☐	WERGW	WERKS	CHAR	4	0	Plant associated with main work center	T001W
35	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
36	PLANT_COPIED_FLG	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
37	.INCLUDE	☐				0	0	Business Object: Account Assignment Data
38	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
39	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
40	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
41	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
42	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
43	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
44	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
45	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	*
46	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	*
47	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
48	.INCLUDE	☐				0	0	Business Object: Techinical Object structuring Data
49	TPLKZ	☐	TPLKZ	TPLKZ	CHAR	5	0	Functional location structure indicators	*
50	TPLKZ_TXT	☐	TPLXT	TEXT40	CHAR	40	0	Structure indicator text for functional locations
51	EAMS_TPLMA	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	*
52	EAMS_TPLMA_TXT	☐	MPTXT	TEXT40	CHAR	40	0	Description of superior functional location
53	POSNR	☐	ILOM_POSNR	CHAR4	CHAR	4	0	Position in superior technical object
54	TRPNR	☐	TRPNR	TRPNR	CHAR	30	0	Reference functional location	*
55	TRPNR_TXT	☐	RPTXT	TEXT40	CHAR	40	0	Description of the reference functional location
56	IEQUI	☐	IEQUI	X	CHAR	1	0	Installation of equipment allowed at the functional location
57	EINZL	☐	EINZL	XFELD	CHAR	1	0	Single equipment installation at functional location
58	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
59	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
60	HEQUI	☐	HEQUI	EQUNR	CHAR	18	0	Superordinate Equipment	*
61	HEQUI_TXT	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
62	TIDNR	☐	TIDNR	TIDNR	CHAR	25	0	Technical identification number
63	STRNO	☐	ILOM_STRNO	ILOM_STRNO	CHAR	40	0	Functional location label
64	IMPHREFDAT	☐	IMRC_DATLO	DATUM	DATS	8	0	Date: Valid From
65	IMPHREFTIM	☐	IMRC_TIMLO	UZEIT	TIMS	6	0	Time: Valid From (Exclusive)
66	EAMS_SUP_TO_TYPE	☐	/PLMB/GOS_OBJECT_TYPE	/PLMB/GOS_OBJECT_TYPE	CHAR	10	0	Object Type	*
67	EAMS_SUP_TO_NO	☐	EAMS_TEC_OBJ	EAMS_TEC_OBJ	CHAR	40	0	Technical Object
68	EAMS_SUP_TO_TXT	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
69	EAMS_SUP_TO_TTXT	☐	/PLMB/GOS_OTYPE_DESC	/PLMB/GOS_OTYPE_DESC	CHAR	40	0	Object Type Description
70	.INCLUDE	☐				0	0	Descriptions for Functional Location
71	CLASS_DESCR	☐	KLSBEZ	TEXT40	CHAR	40	0	Class Description
72	MAINTPLANT_DESCR	☐	NAME1	TEXT30	CHAR	30	0	Name
73	PLANT_SECTION_PERS_DESCR	☐	AP_KTEXT	TEXT40	CHAR	40	0	Short text for the work center
74	PLANT_SECTION_TELE_DESCR	☐	AP_KTEXT	TEXT40	CHAR	40	0	Short text for the work center
75	WORK_CENTER_DESCR	☐	AP_KTEXT	TEXT40	CHAR	40	0	Short text for the work center
76	MAINWRK_CENTER_PLANT_DESCR	☐	NAME1	TEXT30	CHAR	30	0	Name
77	PLANNING_PLANT_DESCR	☐	NAME1	TEXT30	CHAR	30	0	Name
78	PLANNER_GROUP_DESCR	☐	INNAM	TEXT18	CHAR	18	0	Name of the Maintenance Planner Group
79	PLANNER_GROUP_TELE_NO	☐	INTEL	CHAR12	CHAR	12	0	Maintenance Planner Group Telephone Number
80	COMP_CODE_DESCR	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
81	STRINDICATOR_DESCR	☐	TPLXT	TEXT40	CHAR	40	0	Structure indicator text for functional locations
82	MAIN_WORK_CENTER_DESCR	☐	AP_KTEXT	TEXT40	CHAR	40	0	Short text for the work center
83	CITY_DESCR	☐	AP_KTEXT	TEXT40	CHAR	40	0	Short text for the work center
84	FUNC_LOC_DESCR	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
85	AUTHGRP_DESC	☐	IAUTX	TEXT20	CHAR	20	0	Text for the Authorization Group for the Data Object
86	BUS_AREA_DESC	☐	GTEXT	TEXT30	CHAR	30	0	Business area description
87	ASSET_DESC	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
88	COST_CENTER_DESC	☐	KTEXT	TEXT20	CHAR	20	0	General Name
89	LOCATION_DESC	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
90	ABC_IND_DESC	☐	ABCTX	TEXT20	CHAR	20	0	Text for ABC Indicator for Technical Objects
91	WBS_ELEM_DESC	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
92	SALES_ORG_DESC	☐	VTXTK	TEXT20	CHAR	20	0	Name
93	DIST_CHANNEL_DESC	☐	VTXTK	TEXT20	CHAR	20	0	Name
94	OBJ_TYP_DESC	☐	EARTX	TEXT20	CHAR	20	0	Text for Object Type
95	ALTXT	☐	ILOM_ALTXT	TEXT40	CHAR	40	0	Description of labeling system
96	CATEGORY_DESC	☐	TYPTX	TEXT30	CHAR	30	0	Technical type text
97	EQUIPMENT_DESC	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
98	CONTROLLING_AREA_DESC	☐	BEZEI	TEXT25	CHAR	25	0	Name of the controlling area
99	CAT_PRO_DESCR	☐	RBNRX	TEXT30	CHAR	30	0	Catalog Profile Text
100	SPRAS	☐	LANG	LANG	LANG	1	0	Language ID
101	.INCLUDE	☐				0	0	Business Object Functin Location Basic Data
102	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
103	KLASSE	☐	KLASSE_D	KLASSE	CHAR	18	0	Class number
104	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
105	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
106	BRGEW	☐	OBJ_WEIGHT	MENG13	QUAN	13	3	Weight of object
107	GEWEI	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
108	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
109	IFLOT_SNTYPE	☐	ILOM_SN_SNTYPE	QMART	CHAR	2	0	Notification Type for Shift Note for Object	*
110	IFLOT_SRTYPE	☐	ILOM_SR_SRTYPE		CHAR	10	0	Shift Report Type for Object
111	INBDT	☐	ILOM_DATAB	DATUM	DATS	8	0	Start-up Date of the Technical Object
112	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
113	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
114	ALKEY	☐	ILOM_ALKEY	ILOM_ALKEY	CHAR	1	0	Labeling system for functional locations	*
115	FLTYP	☐	FLTYP	FLTYP	CHAR	1	0	Functional Location Category	*
116	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	*
117	SLASH1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
118	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
119	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
120	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
121	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
122	.INCLUDE	☐				0	0	SP Structure for Status ObjectID
123	EAMS_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
124	SYS_STATUS	☐	CO_STTXT	CHAR40	CHAR	40	0	System Status
125	USERSTATUS	☐	CO_STTXT	CHAR40	CHAR	40	0	System Status
126	SYS_STATUS_DLFL	☐	XFLAG	XFLAG	CHAR	1	0	New Input Values
127	SYS_STATUS_INAC	☐	XFLAG	XFLAG	CHAR	1	0	New Input Values
128	.INCLUDE	☐				0	0	Object ID for Document-Object Link
129	OBJECTTYPE	☐	DOKOB	DOKOB	CHAR	10	0	Linked SAP Object	*
130	OBJECTKEY	☐	OBJKY	CHAR50	CHAR	50	0	Document management object key
131	EAML_LFE_IND	☐	EAML_LFE_IND	XFELD	CHAR	1	0	Indicator: Object Belongs to Linear Asset Management
132	START_POINT	☐	EAML_START_POINT	EAML_POINT	CHAR	18	0	Start Point
133	END_POINT	☐	EAML_END_POINT	EAML_POINT	CHAR	18	0	End Point
134	LINEAR_LENGTH	☐	EAML_LINEAR_LENGTH	EAML_POINT	CHAR	18	0	Length
135	LINEAR_UNIT	☐	EAML_LINEAR_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Linear Data	*
136	FIRST_OFFSET_TYPE_CODE	☐	EAML_OFFSET1_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of First Offset	*
137	FIRST_OFFSET_VALUE	☐	EAML_OFFSET1_VALUE	EAML_POINT	CHAR	18	0	Value of Offset 1
138	FIRST_OFFSET_UNIT	☐	EAML_OFFSET1_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 1	*
139	FIRST_OFFSET_UNIT_ISO	☐	EAML_OFFSET1_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Offset 1 in ISO Code	*
140	FIRST_OFFSET_UNIT_TXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
141	SECOND_OFFSET_TYPE_CODE	☐	EAML_OFFSET2_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of Second Offset	*
142	SECOND_OFFSET_VALUE	☐	EAML_OFFSET2_VALUE	EAML_POINT	CHAR	18	0	Value of Offset 2
143	SECOND_OFFSET_UNIT	☐	EAML_OFFSET2_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 2	*
144	SECOND_OFFSET_UNIT_ISO	☐	EAML_OFFSET2_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Offset 2 in ISO Code	*
145	SECOND_OFFSET_UNIT_TXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
146	LINEAR_UNIT_ISO	☐	EAML_LINEAR_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Linear Data in ISO Code	*
147	LINEAR_UNIT_TXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
148	MARKER_START_POINT	☐	EAML_MARKER_START_POINT	EAML_MARKER	CHAR	18	0	Marker for Start Point
149	MARKER_DISTANCE_START_POINT	☐	EAML_MARKER_DISTANCE_START	EAML_POINT	CHAR	18	0	Distance between Marker and Start Point
150	MARKER_END_POINT	☐	EAML_MARKER_END_POINT	EAML_MARKER	CHAR	18	0	Marker for End Point
151	MARKER_DISTANCE_END_POINT	☐	EAML_MARKER_DISTANCE_END	EAML_POINT	CHAR	18	0	Length Spec for Distance between Marker and End Point
152	MARKER_DISTANCE_UNIT	☐	EAML_MARKER_DISTANCE_UNIT	MEINS	UNIT	3	0	Unit for the Distance from Marker	*
153	MARKER_DISTANCE_UNIT_ISO	☐	EAML_MARKER_DISTANCE_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit for the Distance from Marker in ISO Code	*
154	MARKER_DISTANCE_UNIT_TXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
155	LINEAR_REFERENCE_PATTERN	☐	EAML_LRPID	EAML_LRPID	CHAR	10	0	Linear Reference Pattern	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EAMS_S_SP_EQUI_BASIC_DATA	ABCKZ	T370C	ABCKZ
2	EAMS_S_SP_EQUI_BASIC_DATA	ANLNR	ANLH	ANLN1
3	EAMS_S_SP_EQUI_BASIC_DATA	ANLUN	ANLA	ANLN2
4	EAMS_S_SP_EQUI_BASIC_DATA	BEGRU	T370B	BEGRU	REF	1	CN
5	EAMS_S_SP_EQUI_BASIC_DATA	EQART	T370K	EQART	REF	1	N
6	EAMS_S_SP_EQUI_BASIC_DATA	GEWEI	T006	MSEHI
7	EAMS_S_SP_EQUI_BASIC_DATA	GSBER	TGSB	GSBER
8	EAMS_S_SP_EQUI_BASIC_DATA	HERLD	T005	LAND1
9	EAMS_S_SP_EQUI_BASIC_DATA	INGRP	T024I	INGRP
10	EAMS_S_SP_EQUI_BASIC_DATA	IWERK	T001W	WERKS
11	EAMS_S_SP_EQUI_BASIC_DATA	KOSTL	CSKS	KOSTL
12	EAMS_S_SP_EQUI_BASIC_DATA	PROID	PRPS	PSPNR
13	EAMS_S_SP_EQUI_BASIC_DATA	RBNR	T352B	RBNR
14	EAMS_S_SP_EQUI_BASIC_DATA	SUBMT	MARA	MATNR
15	EAMS_S_SP_EQUI_BASIC_DATA	SWERK	T001W	WERKS
16	EAMS_S_SP_EQUI_BASIC_DATA	WAERS	TCURC	WAERS
17	EAMS_S_SP_EQUI_BASIC_DATA	WERGW	T001W	WERKS

History

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