SAP ABAP Table SPOUTPUT_TABLEVIEW (Output Structure Sequence Schedule Table View)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-FLW-SEQ (Application Component) Sequencing
     ⤷ LASP (Package) Application Development R/3 Logistics Automotive Sequencing

Basic Data

Table Category	INTTAB	Structure
Structure	SPOUTPUT_TABLEVIEW	Table Relationship Diagram
Short Description	Output Structure Sequence Schedule Table View

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	Planned Order
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	*
4	MATNR	☐	PLMAT	MATNR	CHAR	18	0	Planning material	MARA
5	PLWRK	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	T001W
6	PWWRK	☐	PWWRK	WERKS	CHAR	4	0	Production plant in planned order	T001W
7	PAART	☐	PAART	PAART	CHAR	4	0	Order type
8	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
9	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
10	GSMNG	☐	GSMNG	MENG13	QUAN	13	3	Total planned order quantity
11	TLMNG	☐	TLMNG	MENG13	QUAN	13	3	Partial lot quantity
12	AVMNG	☐	AVMNG	MENG13	QUAN	13	3	Fixed quantity of scrap from production
13	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
14	PSTTR	☐	PSTTR	DATUM	DATS	8	0	Order start date in planned order
15	PEDTR	☐	PEDTR	DATUM	DATS	8	0	Order finish date in the planned order
16	PERTR	☐	PERTR	DATUM	DATS	8	0	Planned opening date in planned order
17	WEBAZ	☐	PLWEZ	DEC3	DEC	3	0	Goods receipt processing time in days
18	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
19	UMSKZ	☐	PLUMS	XFELD	CHAR	1	0	Conversion indicator for planned order
20	AUFFX	☐	PLAFX	XFELD	CHAR	1	0	Firming indicator for planned order data
21	STLFX	☐	PLSFX	XFELD	CHAR	1	0	Fixing indicator for BOM explosion
22	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
23	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
24	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
25	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
26	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
27	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
28	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
29	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
30	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	LFA1
31	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
32	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
33	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
34	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
35	NUMVR	☐	NUMVR	NUMVR	NUMC	2	0	Version number
36	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
37	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
38	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
39	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
40	PALTR	☐	PALTR	DATUM	DATS	8	0	Explosion date
41	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
42	STLAN	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	*
43	STALT	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
44	STSTA	☐	STLST	STLST	NUMC	2	0	BOM Statuses	T415S
45	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*
46	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
47	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
48	VERTO	☐	SA_VERTO	SA_VERTL	CHAR	4	0	Distribution key for quantity produced	T437V
49	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
50	AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
51	TRART	☐	TRART	CHAR1	CHAR	1	0	Scheduling type of the planned order
52	PLGRP	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	T024F
53	TERST	☐	TERST	DATUM	DATS	8	0	Start date for production
54	TERED	☐	TERED	DATUM	DATS	8	0	Finish date for production
55	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
56	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
57	LINID	☐	SP_OPID	SP_OPID	NUMC	15	0	ID for a schedule record
58	TRMKZ	☐	TRMFL	XFELD	CHAR	1	0	Scheduling indicator
59	TRMER	☐	TRMER	TRMER	CHAR	2	0	Scheduling error
60	REDKZ	☐	REDKZ	REDKZ	CHAR	1	0	Reduction indicator for scheduling
61	TRMHK	☐	TRMHK	TRMHK	CHAR	1	0	Scheduling source
62	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
63	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
64	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
65	FRTHW	☐	FRTHW	FRTHW	CHAR	1	0	Production note in the planned order
66	RGEKZ	☐	CO_RGEKZ	CO_RGEKZ	CHAR	1	0	Indicator: Backflushing for order
67	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
68	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
69	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
70	ABMNG	☐	ABMNG	MENGE	QUAN	13	3	Reduced quantity in the planned order
71	RATID	☐	RATID	BEDID	NUMC	12	0	Index for the results of scheduling production rates	*
72	GROID	☐	GROID	BEDID	NUMC	12	0	Index for rough scheduling results	*
73	RATER	☐	RATER	TRMER	CHAR	2	0	Scheduling error in scheduling production rates
74	GROER	☐	GROER	TRMER	CHAR	2	0	Scheduling error in rough scheduling
75	OBART	☐	OBART	OBART	CHAR	1	0	Object type
76	PLSCN	☐	PLSCN	PLSCN	NUMC	3	0	Planning Scenario of Long-Term Planning	PLSC
77	SBNUM	☐	SBNUM	SBNUM	NUMC	10	0	Simulation requirements number	*
78	KBNKZ	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
79	KAPFX	☐	KAPFX	XFELD	CHAR	1	0	Indicator: capacity for planned order dispatched
80	SEQNR	☐	CY_SEQNR	CY_SEQNR	NUMC	14	0	Seq. number order
81	PSTTI	☐	PSTTI	UZEIT	TIMS	6	0	Start Time of Planned Order
82	PEDTI	☐	PEDTI	UZEIT	TIMS	6	0	End Time of Planned Order
83	MONKZ	☐	MONKZ	XFELD	CHAR	1	0	Indicator: for assembly order procedures
84	PRNKZ	☐	PRNKZ	KREUZ	CHAR	1	0	Ind.: Leading order in collective order is planned ordre
85	MDPBV	☐	MDPBV	MDPBV	CHAR	1	0	Planned order: confirmation of availability
86	VFMNG	☐	VFMNG	MENG13	QUAN	13	3	Planned order: committed quantity
87	MDACH	☐	MDACH	MDACH	CHAR	2	0	Action control: planned order processing	T46AC
88	MDACC	☐	MDACC	MDACC	CHAR	4	0	Action: planned order processing	T46AS
89	MDACD	☐	MDACD	DATUM	DATS	8	0	Date of action: planned order
90	MDACT	☐	MDACT	UZEIT	TIMS	6	0	Time of action: Planned order processing
91	GSBTR	☐	GSBTR_PLAF	DATUM	DATS	8	0	Total commitment date of plnd ord. after ATP check f.comps.
92	PLETX	☐	PLETX	XFELD	CHAR	1	0	Planned order shift quantities exist
93	PRSCH	☐	MD_PRSCHED	XFELD	CHAR	1	0	Planned order: scheduling using production dates
94	LVSCH	☐	MD_LVSCHED	SCHED_TYPE	CHAR	1	0	Planned order: leading scheduling level (determines dates)
95	KZAVC	☐	KZAVC	KZAVC	CHAR	1	0	Indicator for type of availability check
96	VRPLA	☐	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
97	PBDNR	☐	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
98	AGREQ	☐	AGREQ	AGREQ	CHAR	1	0	Requirements totaling
99	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
100	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
101	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
102	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
103	RQNUM	☐	RQNUM	RQNUM	NUMC	10	0	Requirements record number	*
104	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
105	WEMNG	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
106	WAMNG	☐	WAMNG	MENG13	QUAN	13	3	Issued quantity
107	EDGNO	☐	EDGNO	EDGNO	NUMC	17	0	Internal number for edge of object dependencies tree	M60I
108	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
109	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	*
110	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	MDLV
111	UBERI	☐	UBERI	BERID	CHAR	10	0	Issuing MRP area when transferring stock	*
112	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
113	REMFL	☐	REMFL	REMFL	CHAR	1	0	Repetitive Manufacturing indicator
114	PSTMP	☐	PSTMP	TZNTSTMPS	DEC	15	0	Last Change to Planned Order: Time Stamp
115	PUSER	☐	PUSER	UNAME	CHAR	12	0	Last Change to Planned Order: User
116	BADI	☐	MD_BADI	MD_BADI	CHAR	1	0	Object change via active Business Add-In
117	STAEX	☐	MD_STAEX	MD_STAEX	CHAR	2	0	Status information on BOM explosion in planned order
118	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	T001L
119	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
120	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
121	.INCLUDE	☐				0	0
122	MEDKZ	☐	MEDKZ	MEDKZ	CHAR	1	0	Indicator for Distributed Planned Order
123	CNFQTY	☐	MD_MES_CNF_QTY	MENG13	QUAN	13	3	Total Confirmed Qty Planned Order (Repetitive Manufacturing)
124	SPKUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
125	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
126	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
127	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
128	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
129	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
130	MDV01	☐	SA_LINE1	ARBPL	CHAR	8	0	Production line for repetitive manufacturing
131	MDV02	☐	MDV	MDVXX	CHAR	8	0	Planning identification	*
132	TEXT1	☐	VERS_TEXT	TEXT40	CHAR	40	0	Short text on the production version
133	OPID	☐	SP_OPID	SP_OPID	NUMC	15	0	ID for a schedule record
134	OBJID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
135	OPIT	☐	SP_OPITEM	SP_OPITEM	NUMC	5	0	Schedule record item
136	PBEDA	☐	SPPBEDA	DATS	DATS	8	0	Planned arrival date
137	PBETI	☐	SPPBETI	TIMES	TIMS	6	0	Planned arrival time
138	PENDA	☐	SPPENDA	DATS	DATS	8	0	Planned exit date
139	PENTI	☐	SPPENTI	TIMES	TIMS	6	0	Planned exit time
140	LNSID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
141	LNID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
142	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
143	SCHGRUP	☐	SCHGRUP	SCHGRUP	CHAR	2	0	Grouping for Shift Definitions and Shift Sequences	*
144	KAPTPROG	☐	KAPTPROG	KAPTPROG	CHAR	4	0	Shift definition	*
145	KTEXT	☐	SCHTXT	TEXT15	CHAR	15	0	Text for shift definition
146	COL_TAB	☐	LVC_T_SCOL		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SPOUTPUT_TABLEVIEW	AUFNR	SAFK	AUFNR	REF	C	CN
2	SPOUTPUT_TABLEVIEW	BERID	MDLV	BERID
3	SPOUTPUT_TABLEVIEW	DISPO	T024D	DISPO	KEY	1	CN
4	SPOUTPUT_TABLEVIEW	EDGNO	M60I	EDGNO
5	SPOUTPUT_TABLEVIEW	EKORG	T024E	EKORG	REF	C	CN
6	SPOUTPUT_TABLEVIEW	ERFME	T006	MSEHI	REF	1	CN
7	SPOUTPUT_TABLEVIEW	FLIEF	LFA1	LIFNR	REF	C	CN
8	SPOUTPUT_TABLEVIEW	KDAUF	VBUK	VBELN	KEY	1	CN
9	SPOUTPUT_TABLEVIEW	KNTTP	T163K	KNTTP	KEY	1	CN
10	SPOUTPUT_TABLEVIEW	KONNR	EKKO	EBELN	REF	C	CN
11	SPOUTPUT_TABLEVIEW	KTPNR	EKPO	EBELP	REF	C	CN
12	SPOUTPUT_TABLEVIEW	LGORT	T001L	LGORT	KEY	1	CN
13	SPOUTPUT_TABLEVIEW	MATNR	MARA	MATNR	KEY	1	CN
14	SPOUTPUT_TABLEVIEW	MDACC	T46AS	MDACC		1	CN
15	SPOUTPUT_TABLEVIEW	MDACH	T46AC	MDACH	REF	1	CN
16	SPOUTPUT_TABLEVIEW	MEINS	T006	MSEHI	REF	1	CN
17	SPOUTPUT_TABLEVIEW	PLGRP	T024F	FEVOR	KEY	1	CN
18	SPOUTPUT_TABLEVIEW	PLSCN	PLSC	PLSCN
19	SPOUTPUT_TABLEVIEW	PLWRK	T001W	WERKS	KEY	1	CN
20	SPOUTPUT_TABLEVIEW	PWWRK	T001W	WERKS	KEY	1	CN
21	SPOUTPUT_TABLEVIEW	RESLO	T001L	LGORT
22	SPOUTPUT_TABLEVIEW	SERNR	SNUM	SERNR	REF	C	C
23	SPOUTPUT_TABLEVIEW	SOBKZ	T148	SOBKZ
24	SPOUTPUT_TABLEVIEW	STSTA	T415S	STLST	REF	C	CN
25	SPOUTPUT_TABLEVIEW	VERID	MKAL	VERID	REF	C	CN
26	SPOUTPUT_TABLEVIEW	VERTO	T437V	VERTL	KEY	1	CN

History

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