SAP ABAP Table S281 (Order Operation, BW)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-LIS (Application Component) Logistics Information System (LIS)
     ⤷ MCDX (Package) Logistics Information System / SAP-BW (Release-Dependent)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S281	Table Relationship Diagram
Short Description	Order Operation, BW

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	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
9	VORNR	☑	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
10	UVORN	☑	UVORN	VORNR	CHAR	4	0	Suboperation
11	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
12	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
13	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
14	DFZEH	☐	DFZEH	EINHEIT	UNIT	3	0	Unit of measure for execution time
15	RSTZE	☐	RSTZE	EINHEIT	UNIT	3	0	Unit of measure for setup time
16	BEAZE	☐	BEAZE	EINHEIT	UNIT	3	0	Unit of measure for processing time
17	ARUZE	☐	ARUZE	EINHEIT	UNIT	3	0	Unit of measure for teardown
18	LIGZE	☐	LIGZE	EINHEIT	UNIT	3	0	Unit of measure for wait time
19	TRAZE	☐	TRAZE	EINHEIT	UNIT	3	0	Unit of measure for move time
20	WRTZE	☐	WTRZE	EINHEIT	UNIT	3	0	Unit of measure for queue time
21	KEINH	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	T006
22	MGVRG	☐	MC_MGVRG	MENGV15	QUAN	15	3	Operation quantity
23	ASVRG	☐	MC_ASVRG	MENGV15	QUAN	15	3	Operation scrap
24	GMNGA	☐	MC_GMNGA	MENGV15	QUAN	15	3	Total Delivered Lot Size
25	LMNGA	☐	MC_LMNGA	MENGV15	QUAN	15	3	Total quantity confirmed
26	XMNGA	☐	MC_XMNGA	MENGV15	QUAN	15	3	Total scrap quantity confirmed
27	FSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
28	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
29	IEAVD	☐	IEAVD	DATUM	DATS	8	0	Actual finish of operation (date)
30	IADD	☐	IADD	DATUM	DATS	8	0	Actual input date
31	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
32	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
33	SSADD	☐	SSADD	DATUM	DATS	8	0	Latest target input date
34	SSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
35	SSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
36	ISAVD	☐	ISAVD	DATUM	DATS	8	0	Actual operation start (date)
37	S_DFZ	☐	S_DFZ	DAUER_6_1V	QUAN	7	1	Target execution time
38	I_DFZ	☐	I_DFZ	DAUER_6_1V	QUAN	7	1	Actual execution time
39	RUEST	☐	MC_RUEST	DAUER_6_1V	QUAN	7	1	Scheduled setup time
40	BEARZ	☐	MC_BEARZ	DAUER_6_1V	QUAN	7	1	Scheduled processing time
41	ABRUE	☐	MC_ABRUE	DAUER_6_1V	QUAN	7	1	Scheduled teardown time
42	LIEGZ	☐	MC_LIEGZ	DAUER_6_1V	QUAN	7	1	Wait time used for scheduling
43	TRANZ	☐	MC_TRANZ	DAUER_6_1V	QUAN	7	1	Move time used for scheduling
44	WARTZ	☐	MC_WARTZ	DAUER_6_1V	QUAN	7	1	Queue time used for scheduling
45	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
46	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
47	KRUES	☐	MC_KRUES	DAUER_6_1V	QUAN	7	1	Scheduled cap. requirements for the op. segment "setup"
48	KBEAS	☐	MC_KBEAS	DAUER_6_1V	QUAN	7	1	Scheduled cap. requirements for the op. segment "processing"
49	KABRS	☐	MC_KABRS	DAUER_6_1V	QUAN	7	1	Scheduled cap. requirements for the op. segment teardown
50	MCFSEDD	☐	MCFSEDD	DEC9	DEC	9	0	Earliest Scheduled Finish: Execution (Date)
51	MCFSAVD	☐	MCFSAVD	DEC9	DEC	9	0	Earliest Scheduled Start: Execution (Date)
52	MCIADD	☐	MCIADD	DEC9	DEC	9	0	Actual input date
53	MCIEAVD	☐	MCIEAVD	DEC9	DEC	9	0	Actual Finish of Operation (Date)
54	MCISAVD	☐	MCISAVD	DEC9	DEC	9	0	Actual operation start (date)
55	MCSSADD	☐	MCSSADD	DEC9	DEC	9	0	Latest target input date
56	MCSSEDD	☐	MCSSEDD	DEC9	DEC	9	0	Latest Scheduled Finish: Execution (Date)
57	MCSSAVD	☐	MCSSAVD	DEC9	DEC	9	0	Latest Scheduled Start: Execution (Date)
58	MCISDD	☐	MCISDD	DEC9	DEC	9	0	Actual Start: Execution (Date)
59	MCIEDD	☐	MCIEDD	DEC9	DEC	9	0	Actual End: Execution (Date)
60	PWERK	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	T001W
61	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
62	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	VBUK
63	S_DLZ	☐	S_DLZ	DAUER_6_1V	QUAN	7	1	Target lead time
64	I_DLZ	☐	I_DLZ	DAUER_6_1V	QUAN	7	1	Actual lead time
65	Z_TAB	☐	X_TAB	DAUER_6_1V	QUAN	7	1	Deviation from scheduled input date
66	A_TAB	☐	A_TAB	DAUER_6_1V	QUAN	7	1	Deviation in scheduled output date
67	R_TAB	☐	R_TAB	DAUER_6_1V	QUAN	7	1	Relative schedule deviation
68	R_TABP	☐	R_TABP	DAUER_6_1	QUAN	7	1	Relative Schedule Deviation Positive
69	R_TABN	☐	R_TABN	DAUER_6_1	QUAN	7	1	Relative Schedule Deviation Negative
70	A_TABP	☐	A_TABP	DAUER_6_1	QUAN	7	1	Date Variance of Issue, Positive
71	A_TABN	☐	A_TABN	DAUER_6_1	QUAN	7	1	Date Variance of Issue, Negative
72	Z_TABP	☐	X_TABP	DAUER_6_1	QUAN	7	1	Schedule Deviation Input Positive
73	Z_TABN	☐	X_TABN	DAUER_6_1	QUAN	7	1	Schedule Deviation Input Negative
74	FTRMI	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
75	ANZFA	☐	MC_ANZFA	MCZAEHLER	DEC	9	0	Number of production orders

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S281	AUFNR	AUFK	AUFNR
2	S281	KDAUF	VBUK	VBELN
3	S281	KEINH	T006	MSEHI
4	S281	MANDT	T000	MANDT
5	S281	MATNR	MARA	MATNR
6	S281	MEINH	T006	MSEHI
7	S281	PWERK	T001W	WERKS
8	S281	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in