SAP ABAP Table S114E (S114 - Strukturinformationen)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PM-IS-REP (Application Component) Reporting
     ⤷ MCI (Package) R/3 appl. development: Plant Maintenance Information System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S114E	Table Relationship Diagram
Short Description	S114 - Strukturinformationen

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	UNSYS	☑	DUNSYS	CHAR3	CHAR	3	0	Unit System
4	SWERK	☑	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
5	EQTYP	☑	EQTYP	EQTYP	CHAR	1	0	Equipment Category	T370T
6	EQART	☑	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
7	IWERK	☑	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
8	HERST	☑	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
9	TYPBZ	☑	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
10	BAUJJ	☑	BAUJJ	CJAHR	CHAR	4	0	Year of construction
11	EQUNR	☑	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
12	DUNIT	☐	DDUNIT	MEINS	UNIT	3	0	PMIS: Unit Field for Distance Covered	T006
13	TUNIT	☐	DTUNIT	MEINS	UNIT	3	0	PMIS: Unit Field for Operating Hours	T006
14	FUNIT	☐	DFUNIT	MEINS	UNIT	3	0	PMIS: Unit Field for Fuel Volumes	T006
15	MUNIT	☐	DMUNIT	MEINS	UNIT	3	0	PMIS: Unit Field for Volume Mass	T006
16	FDUNIT	☐	DFDUNIT	MEINS	UNIT	3	0	PMIS: Unit Field for Fuel Consumption per Route	T006
17	FTUNIT	☐	DFTUNIT	MEINS	UNIT	3	0	PMIS: Unit for Fuel Consumption per Hour of Operation	T006
18	MDUNIT	☐	DMDUNIT	MEINS	UNIT	3	0	PMIS: Unit Field for Fuel Mass per Route	T006
19	MTUNIT	☐	DMTUNIT	MEINS	UNIT	3	0	PMIS: Unit Field for Fuel Mass per Operating Hour	T006
20	CDUNIT	☐	DCDUNIT	MEINS	UNIT	3	0	PMIS: Unit for Actual Costs per Reserved Route	T006
21	CTUNIT	☐	DCTUNIT	MEINS	UNIT	3	0	PMIS: Unit for Actual Costs per Operating Hour	T006
22	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
23	UDUNIT	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
24	UTUNIT	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
25	UFUNIT	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
26	UMUNIT	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
27	UFDUNIT	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
28	UFTUNIT	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
29	UMDUNIT	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
30	UMTUNIT	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
31	UCDUNIT	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
32	UCTUNIT	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
33	UWAERS	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
34	PLOBJ	☐	PLOBJ	CHAR18	CHAR	18	0	Planning object
35	PERKZ	☐	PERVR	PERVR	CHAR	1	0	Period indicator
36	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
37	PLTKZ	☐	PLTKZ	CHAR01	CHAR	1	0	Indicator: element used in planning
38	ANTEI	☐	DANTEF	FLTP	FLTP	16	16	Proportional factor (%) for disaggregation of product group

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S114E	CDUNIT	T006	MSEHI
2	S114E	CTUNIT	T006	MSEHI
3	S114E	DUNIT	T006	MSEHI
4	S114E	EQART	T370K	EQART	KEY
5	S114E	EQTYP	T370T	EQTYP	KEY
6	S114E	EQUNR	EQUI	EQUNR	KEY
7	S114E	FDUNIT	T006	MSEHI
8	S114E	FTUNIT	T006	MSEHI
9	S114E	FUNIT	T006	MSEHI
10	S114E	IWERK	T399I	IWERK	KEY
11	S114E	MANDT	T000	MANDT	KEY	1	CN
12	S114E	MDUNIT	T006	MSEHI
13	S114E	MTUNIT	T006	MSEHI
14	S114E	MUNIT	T006	MSEHI
15	S114E	PERIV	T009	PERIV		1	CN
16	S114E	SWERK	T001W	WERKS	KEY
17	S114E	TUNIT	T006	MSEHI
18	S114E	WAERS	TCURC	WAERS

History

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