SAP ABAP Table S280BIW2 (S280BIW2 * Order Header and Item, 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	S280BIW2	Table Relationship Diagram
Short Description	S280BIW2 * Order Header and Item, 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	POSNR	☑	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
10	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
11	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
12	MEINS	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
13	DFZEH	☐	DFZEH	EINHEIT	UNIT	3	0	Unit of measure for execution time
14	KEINH	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	T006
15	GLTRP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
16	FTRMI	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
17	FTRMP	☐	CO_FTRMP	DATUM	DATS	8	0	Planned release date
18	GSTRI	☐	CO_GSTRI	DATUM	DATS	8	0	Actual start date
19	GETRI	☐	CO_GETRI	DATUM	DATS	8	0	Confirmed Order Finish Date
20	GSTRP	☐	CO_GSTRP	DATUM	DATS	8	0	Basic start date
21	GLTRS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
22	FTRMS	☐	CO_FTRMS	DATUM	DATS	8	0	Scheduled release date
23	GSTRS	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
24	LTRMI	☐	CO_LTRMI	DATUM	DATS	8	0	Actual delivery/finish date
25	LTRMP	☐	CO_LTRMP	DATUM	DATS	8	0	Delivery date from planned order
26	ETRMP	☐	CO_ETRMP	DATUM	DATS	8	0	Opening date of the planned order
27	STRMP	☐	CO_STRMP	DATUM	DATS	8	0	Start date of the planned order
28	PGMNG	☐	MC_GSMNG	MENGV15_3	QUAN	15	3	Total planned order quantity
29	PAMNG	☐	MC_AVMNG	MENGV15_3	QUAN	15	3	Fixed quantity of scrap from production
30	PSMNG	☐	MC_PSMNG	MENGV15_3	QUAN	15	3	Order item quantity
31	PSAMG	☐	MC_PSAMG	MENGV15_3	QUAN	15	3	Scrap quantity in item
32	WEMNG	☐	MC_WEMNG	MENGV15_3	QUAN	15	3	Quantity of goods received
33	IAMNG	☐	MC_IAMNG	MENGV15_3	QUAN	15	3	Actual scrap quantity from an order item
34	S_DFZ	☐	S_DFZ	DAUER_6_1V	QUAN	7	1	Target execution time
35	I_DFZ	☐	I_DFZ	DAUER_6_1V	QUAN	7	1	Actual execution time
36	KSUMS	☐	MC_KSUMS	DAUER_6_1V	QUAN	7	1	Total target capacity requirements
37	MCGLTRP	☐	MCGLTRP	DEC9	DEC	9	0	Basic Finish Date
38	MCGSTRP	☐	MCGSTRP	DEC9	DEC	9	0	Basic start date
39	MCFTRMP	☐	MCFTRMP	DEC9	DEC	9	0	Planned release date
40	MCLTRMI	☐	MCLTRMI	DEC9	DEC	9	0	Actual delivery/finish date
41	MCGETRI	☐	MCGETRI	DEC9	DEC	9	0	Confirmed Order Finish Date
42	MCFTRMI	☐	MCFTRMI	DEC9	DEC	9	0	Actual release date
43	MCGSTRI	☐	MCGSTRI	DEC9	DEC	9	0	Actual Start Date
44	MCLTRMP	☐	MCLTRMP	DEC9	DEC	9	0	Delivery date from planned order
45	MCETRMP	☐	MCETRMP	DEC9	DEC	9	0	Opening Date of the Planned Order
46	MCSTRMP	☐	MCSTRMP	DEC9	DEC	9	0	Start date of the planned order
47	MCFTRMS	☐	MCFTRMS	DEC9	DEC	9	0	Scheduled release date
48	MCGSTRS	☐	MCGSTRS	DEC9	DEC	9	0	Scheduled Start
49	MCGLTRS	☐	MCGLTRS	DEC9	DEC	9	0	Scheduled finish
50	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
51	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
52	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	VBUK
53	PWERK	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	T001W
54	P_DLZ	☐	P_DLZ	DAUER_6_1V	QUAN	7	1	Planned lead time
55	S_DLZ	☐	S_DLZ	DAUER_6_1V	QUAN	7	1	Target lead time
56	I_DLZ	☐	I_DLZ	DAUER_6_1V	QUAN	7	1	Actual lead time
57	PS_FREI	☐	PS_FREI	DAUER_6_1V	QUAN	7	1	Planned/target deviation in scheduled release date
58	PI_FREI	☐	PI_FREI	DAUER_6_1V	QUAN	7	1	Planned/actual deviation in scheduled release date
59	SI_FREI	☐	DSI_FREI	DAUER_6_1V	QUAN	7	1	Target/actual deviation in scheduled release date
60	PS_STAR	☐	PS_STAR	DAUER_6_1V	QUAN	7	1	Planned/target deviation in start date
61	PI_STAR	☐	PI_STAR	DAUER_6_1V	QUAN	7	1	Planned/actual deviation in scheduled start date
62	SI_STAR	☐	DSI_STAR	DAUER_6_1V	QUAN	7	1	Target/actual schedule deviation in start date
63	PS_LIEF	☐	PS_LIEF	DAUER_6_1V	QUAN	7	1	Planned/target deviation in scheduled delivery date
64	PI_LIEF	☐	PI_LIEF	DAUER_6_1V	QUAN	7	1	Planned/actual deviation in scheduled delivery date
65	SI_LIEF	☐	DSI_LIEF	DAUER_6_1V	QUAN	7	1	Target/actual deviation in scheduled delivery date
66	PI_FREIP	☐	PI_FREIP	DAUER_6_1	QUAN	7	1	Release Schedule Deviation Plan/Actual Positive
67	PI_FREIN	☐	PI_FREIN	DAUER_6_1	QUAN	7	1	Release Schedule Deciation Plan/Actual Negative
68	PI_LIEFP	☐	PI_LIEFP	DAUER_6_1	QUAN	7	1	Delivery Schedule Deviation Plan/Actual Positive
69	PI_LIEFN	☐	PI_LIEFN	DAUER_6_1	QUAN	7	1	Delivery Schedule Deviation Plan/Actual Negative
70	PI_STARP	☐	PI_STARP	DAUER_6_1	QUAN	7	1	Start Schedule Deviation Plan/Actual Positive
71	PI_STARN	☐	PI_STARN	DAUER_6_1	QUAN	7	1	Start Schedule Deviation Plan/Actual Negative
72	PS_FREIP	☐	PS_FREIP	DAUER_6_1	QUAN	7	1	Release Schedule Deviation Plan/Target Positive
73	PS_FREIN	☐	PS_FREIN	DAUER_6_1	QUAN	7	1	Release Schedule Deviation Plan/Target Negative
74	PS_LIEFP	☐	PS_LIEFP	DAUER_6_1	QUAN	7	1	Delivery Schedule Deviation Plan/Target Positive
75	PS_LIEFN	☐	PS_LIEFN	DAUER_6_1	QUAN	7	1	Delivery Schedule Deviation Plan/Target Negative
76	PS_STARP	☐	PS_STARP	DAUER_6_1	QUAN	7	1	Start Schedule Deviation Plan/Target Positive
77	PS_STARN	☐	PS_STARN	DAUER_6_1	QUAN	7	1	Start Schedule Deviation Plan/Target Negative
78	SI_FREIP	☐	DSI_FREIP	DAUER_6_1	QUAN	7	1	Release Date Variance Target/Actual Positive
79	SI_FREIN	☐	DSI_FREIN	DAUER_6_1	QUAN	7	1	Release Date Variance Target/Actual Negative
80	SI_LIEFP	☐	DSI_LIEFP	DAUER_6_1	QUAN	7	1	Delivery Date Variance Target/Actual Positive
81	SI_LIEFN	☐	DSI_LIEFN	DAUER_6_1	QUAN	7	1	Delivery Date Variance Target/Actual Negative
82	SI_STARP	☐	DSI_STARP	DAUER_6_1	QUAN	7	1	Start Date Variance Target/Actual Positive
83	SI_STARN	☐	DSI_STARN	DAUER_6_1	QUAN	7	1	Start Date Variance Target/Actual Negative
84	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	S280BIW2	AUFNR	AUFK	AUFNR
2	S280BIW2	KDAUF	VBUK	VBELN
3	S280BIW2	KEINH	T006	MSEHI
4	S280BIW2	MANDT	T000	MANDT
5	S280BIW2	MATNR	MARA	MATNR
6	S280BIW2	MEINS	T006	MSEHI
7	S280BIW2	PWERK	T001W	WERKS
8	S280BIW2	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20100310
SAP Release Created in