SAP ABAP Table S061 (Location and planning)

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	S061	Table Relationship Diagram
Short Description	Location and planning

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	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	SWERK	☑	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
9	BEBER	☑	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
10	STORT	☑	STORT	AP_STAND	CHAR	10	0	Asset location	T499S
11	IWERK	☑	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
12	INGRP	☑	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
13	TPLNR	☑	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
14	EQUNR	☑	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
15	BAUTL	☑	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
16	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
17	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
18	SUNIT	☐	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration	T006
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	SMOFN	☐	SMOFN	MCZAEHLER	DEC	9	0	No.of recorded notifications
21	SMMAB	☐	SMMAB	MCZAEHLER	DEC	9	0	No. of completed notifications
22	SABTG	☐	SABTG	MCZAEHLER	DEC	9	0	No. processing days creation to completion
23	SGMSAUS	☐	SGMSAUS	MCZAEHLER	DEC	9	0	Number of machine breakdowns reported
24	SGAUSZT	☐	SGAUSZT	MENG13	QUAN	13	3	Downtime entered
25	SSCODE	☐	SSCODE	MCZAEHLER	DEC	9	0	PMIS: No.of damages
26	SACODE	☐	SACODE	MCZAEHLER	DEC	9	0	PMIS: number of activity codes
27	SUCODE	☐	SUCODE	MCZAEHLER	DEC	9	0	PMIS: No. of cause of damage codes
28	IAOFN	☐	IAOFN	MCZAEHLER	DEC	9	0	PMIS: number of maintenance orders created
29	IASOF	☐	IASOFORT	MCZAEHLER	DEC	9	0	PMIS: no. of maintenance tasks to be performed immediately
30	IAPLANM	☐	IAPLANM	MCZAEHLER	DEC	9	0	PMIS: number of planned maintenance orders
31	IAUNGPL	☐	IAUNGPL	MCZAEHLER	DEC	9	0	PMIS: number of unplanned maintenance orders
32	IAABG	☐	IAABG	MCZAEHLER	DEC	9	0	PMIS: number of completed maintenance orders
33	IAKOSPLAN	☐	DGESKOPLAN	WERTV8	CURR	15	2	Total plant maintenance costs (planned)
34	IAKOSIST	☐	DGESKOSIST	WERTV8	CURR	15	2	Total(actual) maintenance costs
35	IAPERKOSE	☐	DPERKOSEIG	WERTV8	CURR	15	2	PMIS: PM costs for internal wages
36	IAPERKOSF	☐	DPERKOSFRD	WERTV8	CURR	15	2	PMIS: PM costs for external wages
37	IAMATKOSE	☐	DMATKOSEIG	WERTV8	CURR	15	2	PMIS: PM costs for internal material
38	IAMATKOSF	☐	DMATKOSFRD	WERTV8	CURR	15	2	PMIS: PM costs for external material
39	IADIENKOS	☐	DDIENLKOST	WERTV8	CURR	15	2	PMIS: PM costs for services
40	IASONKOST	☐	DSONSTKOST	WERTV8	CURR	15	2	PMIS: Miscellaneous PM costs
41	IAERTRAG	☐	DGESERTRAG	WERTV8	CURR	15	2	Total plant maintenance revenues (actual)
42	USER4	☐	DGESKOSSCH	WERTV8	CURR	15	2	Total maintenance costs (estimated)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S061	BAUTL	MARA	MATNR	KEY
2	S061	BEBER	T357	BEBER	KEY
3	S061	EQUNR	EQUI	EQUNR	KEY
4	S061	INGRP	T024I	INGRP	KEY
5	S061	IWERK	T399I	IWERK	KEY
6	S061	MANDT	T000	MANDT	KEY
7	S061	STORT	T499S	STAND	KEY
8	S061	SUNIT	T006	MSEHI
9	S061	SWERK	T001W	WERKS	KEY
10	S061	TPLNR	IFLOT	TPLNR	KEY
11	S061	WAERS	TCURC	WAERS

History

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