SAP ABAP Table VSCAUFV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VSCAUFV	Table Relationship Diagram
Short Description	Generated Table for 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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VSNMR	☑	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
3	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	VSAUFK_CN
4	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	T024D
5	PVERW	☐	PLN_VERWE	PLN_VERWE	CHAR	3	0	Task list usage	T411
6	PLNBEZ	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
7	PLNAW	☐	PLNAW	PLNAW	CHAR	1	0	Application of the task list	TCA09
8	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type
9	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
10	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
11	PLAUF	☐	CO_PLAUF	DATUM	DATS	8	0	Date for routing transfer
12	PLGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
13	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
14	PLSVB	☐	LOSGRBIS	MENG13	QUAN	13	3	To lot size
15	PLNME	☐	PLNME	MEINS	UNIT	3	0	Task list unit of measure	T006
16	PLSVN	☐	LOSGRVON	MENG13	QUAN	13	3	From Lot Size
17	PDATV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
18	PAENR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
19	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
20	STLST	☐	STLST	STLST	NUMC	2	0	BOM Statuses	T415S
21	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
22	STLAN	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	T416
23	SDATV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
24	SBMNG	☐	BASMN	MENG13	QUAN	13	3	Base quantity
25	SBMEH	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
26	SAENR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
27	STLBEZ	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
28	STLAL	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
29	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
30	AUFLD	☐	CO_AUFLD	DATUM	DATS	8	0	Date of BOM Explosion/Routing Transfer
31	PRONR	☐	PS_PSP_PRO	PS_PSPNR	NUMC	8	0	Project definition	VSPROJ_CN
32	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
33	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
34	REFNR	☐	AUFREFNR	AUFNR	CHAR	12	0	Reference order number	AUFK
35	ERNAM	☐	AUFERFNAM	USNAM	CHAR	12	0	Entered by
36	ERDAT	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
37	AENAM	☐	AUFAENAM	USNAM	CHAR	12	0	Last changed by
38	AEDAT	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
39	KTEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
40	LTEXT	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
41	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
42	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
43	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
44	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
45	ASTKZ	☐	AUFSTKZ	XFELD	CHAR	1	0	Identifier for statistical order
46	WAERS	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	TCURC
47	OBJID	☐	CCOBJID	CHAR1	CHAR	1	0	Object ID
48	LOEKZ	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
49	PLGKZ	☐	PLGKZ	XFELD	CHAR	1	0	Identifier for planning with line items
50	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
51	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
52	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
53	ABKRS	☐	AUFABKRS	AKREIS	NUMC	2	0	Processing group	TKO08
54	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
55	PSPEL	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	VSPRPS_CN
56	FTRMS	☐	CO_FTRMS	DATUM	DATS	8	0	Scheduled release date
57	FTRMI	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
58	FTRMP	☐	CO_FTRMP	DATUM	DATS	8	0	Planned release date
59	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	T024F
60	FHORI	☐	FHORI	FHORI	CHAR	3	0	Scheduling Margin Key for Floats	T436A
61	TERKZ	☐	TERMKZ	TERART	CHAR	1	0	Scheduling type	T482
62	REDKZ	☐	REDKZ	REDKZ	CHAR	1	0	Reduction indicator for scheduling
63	APRIO	☐	CO_APRIO	CHAR1	CHAR	1	0	Order priority
64	SLSVN	☐	LOSVN	MENG13	QUAN	13	3	From Lot Size
65	SLSBS	☐	LOSBS	MENG13	QUAN	13	3	To Lot Size
66	NTZUE	☐	NETZ_UEBER	AUFNR	CHAR	12	0	Superior network number	AUFK
67	VORUE	☐	VORG_UEBER	VORNR	CHAR	4	0	Superior activity
68	GLTRP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
69	GSTRP	☐	PM_ORDGSTRP	DATUM	DATS	8	0	Basic Start Date
70	GLTRS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
71	GSTRS	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
72	GSTRI	☐	CO_GSTRI	DATUM	DATS	8	0	Actual start date
73	GLTRI	☐	CO_GLTRI	DATUM	DATS	8	0	Actual finish date
74	GASMG	☐	GASMG	MENG13	QUAN	13	3	Total scrap quantity in the order
75	GAMNG	☐	GAMNG	MENG13	QUAN	13	3	Total order quantity
76	GMEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
77	UPTER	☐	CO_UPTER	CHAR1	CHAR	1	0	Indicator: Change to Scheduled Dates
78	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record
79	LODIV	☐	LOSDIV	MENG13	QUAN	13	3	Lot size divisor
80	VORGZ	☐	VORGZ	NUM3	NUMC	3	0	Float before production (in days)
81	SICHZ	☐	SICHZ	NUM3	NUMC	3	0	Float after production (in days)
82	FREIZ	☐	FREIZ	NUM3	NUMC	3	0	Release period (in days)
83	GETRI	☐	CO_GETRI	DATUM	DATS	8	0	Confirmed Order Finish Date
84	PROFID	☐	PROFIDNZPL	PROFILID	CHAR	7	0	Network profile	TCN41
85	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
86	MZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
87	ZKRIZ	☐	DZKRIZ	ZKRIZ	NUMC	7	0	Counter for additional criteria
88	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
89	AWSLS	☐	AWSLS	AWSLS	CHAR	6	0	Variance Key	TKV01
90	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
91	KLVARP	☐	KALKVARPLN	KLVAR	CHAR	4	0	Costing variant for planned costs	TCK03
92	KLVARI	☐	KALKVARIST	KLVAR	CHAR	4	0	Costing variant for actual costs	TCK03
93	RGEKZ	☐	CO_RGEKZ	CO_RGEKZ	CHAR	1	0	Indicator: Backflushing for order
94	PLART	☐	PS_PLART	PS_PLART	CHAR	1	0	Basis for scheduling
95	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
96	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
97	FLG_AOB	☐	FLG_AOB	FLAG	CHAR	1	0	Indicator: relationships
98	FLG_ARBEI	☐	FLG_ARBEI	FLAG	CHAR	1	0	Indicator: Default value work is relevant
99	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
100	GLTPP	☐	CO_GLTPP	DATUM	DATS	8	0	Finish date (forecast)
101	GSTPP	☐	CO_GSTPP	DATUM	DATS	8	0	Forecast start date
102	GLTPS	☐	CO_GLTPS	DATUM	DATS	8	0	Scheduled forecast finish
103	GSTPS	☐	CO_GSTPS	DATUM	DATS	8	0	Scheduled forecast start
104	FTRPS	☐	CO_FTRPS	DATUM	DATS	8	0	Scheduled release date (forecast)
105	RDKZP	☐	REDKZP	REDKZ	CHAR	1	0	Reduction indicator for scheduling (forecast)
106	TRKZP	☐	TERMKZP	TERART	CHAR	1	0	Scheduling type (forecast)	T482
107	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
108	RMZHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
109	KVEWE	☐	KVEWE	KVEWE	CHAR	1	0	Usage of the Condition Table	T681V
110	IGMNG	☐	CO_IGMNG	MENG13	QUAN	13	3	Yield confirmed from order confirmation
111	IASMG	☐	CO_IASMG	MENG13	QUAN	13	3	Scrap confirmed for order
112	ABARB	☐	CO_ABARB	CO_ABARB	NUMC	3	0	Confirmation: Degree of processing
113	RATID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record
114	GROID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record
115	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
116	GLUZS	☐	CO_GLUZS	UHRZT	TIMS	6	0	Scheduled finish time
117	GSUZS	☐	CO_GSUZS	ATIME	TIMS	6	0	Scheduled Start (Time)
118	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
119	STUFE	☐	HISTU	DEC2	DEC	2	0	Level (in Multi-Level BOM Explosions)
120	WEGXX	☐	WEGXX	DEC4	DEC	4	0	Path (for Multi-Level BOM Explosions)
121	VWEGX	☐	WEGXX	DEC4	DEC	4	0	Path (for Multi-Level BOM Explosions)
122	ARSNR	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
123	ARSPS	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
124	MAUFNR	☐	MAUFNR	AUFNR	CHAR	12	0	Number of superior order
125	LKNOT	☐	CO_LKNOT	AUFNR	CHAR	12	0	Left node in collective order
126	RKNOT	☐	CO_RKNOT	AUFNR	CHAR	12	0	Right node of a collective order
127	PRODNET	☐	CO_PRODNET	KREUZ	CHAR	1	0	Indicator: Order is part of collective order
128	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
129	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
130	NO_DISP	☐	NO_DISP_PLUS	NO_DISP_PLUS	CHAR	1	0	Effective for Materials Planning
131	AUFNT	☐	CO_TEILNET	AUFNR	CHAR	12	0	Number of superior network
132	AUFPT	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
133	APLZT	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order
134	CSPLIT	☐	CSPLIT	CSPLIT	CHAR	4	0	Apportionment structure	MAKV
135	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
136	CY_SEQNR	☐	CY_SEQNR	CY_SEQNR	NUMC	14	0	Seq. number order
137	BREAKS	☐	BREAKS	XFELD	CHAR	1	0	Indicator: Scheduling allowing for breaks
138	VORGZ_TRM	☐	VORGZ_TRM	PUFFER_TRM	DEC	6	3	Scheduled float before production in days
139	SICHZ_TRM	☐	SICHZ_TRM	PUFFER_TRM	DEC	6	3	Scheduled float after production in days
140	TRMDT	☐	TRMDT	DATUM	DATS	8	0	Date of the last scheduling
141	CHSCH	☐	KALSMA_CH	KALSM	CHAR	6	0	Search procedure for batch determination	T683
142	GLUZP	☐	CO_GLUZP	UHRZT	TIMS	6	0	Basic finish (time)
143	GSUZP	☐	CO_GSUZP	UHRZT	TIMS	6	0	Basic start time
144	GSUZI	☐	CO_GSUZI	UHRZT	TIMS	6	0	Actual start time
145	GEUZI	☐	CO_GEUZI	UHRZT	TIMS	6	0	Confirmed order finish (time)
146	GLUPP	☐	CO_GLUPP	UHRZT	TIMS	6	0	Forecast finish (time)
147	GSUPP	☐	CO_GSUPP	UHRZT	TIMS	6	0	Forecast start (time)
148	GLUPS	☐	CO_GLUPS	UHRZT	TIMS	6	0	Scheduled forecast finish time
149	GSUPS	☐	CO_GSUPS	UHRZT	TIMS	6	0	Scheduled start time (Forecast)
150	RSNTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
151	RSNID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
152	KAPT_VORGZ	☐	KAPT_VORGZ	NUM3	NUMC	3	0	Float (bef. production) remaining after finite scheduling
153	KAPT_SICHZ	☐	KAPT_SICHZ	NUM3	NUMC	3	0	Remaining float after finite scheduling
154	LEAD_AUFNR	☐	CO_LAUFNR	AUFNR	CHAR	12	0	Leading order in current processing	AUFK
155	PNETSTARTD	☐	CO_PSTARTD	DATUM	DATS	8	0	Outline start of collective network (date)
156	PNETSTARTT	☐	CO_PSTARTT	ATIME	TIMS	6	0	Start time of a collective order
157	PNETENDD	☐	CO_PENDD	DATUM	DATS	8	0	Outline finish of collective order (date)
158	PNETENDT	☐	CO_PENDT	ATIME	TIMS	6	0	Outline finish time
159	FLG_MLTPS	☐	CO_MLTPS	KREUZ	CHAR	1	0	Order with multiple items
160	NAUTERM	☐	CO_NAUTERM	KREUZ	CHAR	1	0	Indicator: Do not schedule automatically
161	NAUCOST	☐	CO_NAUCOST	KREUZ	CHAR	1	0	Indicator: Do not cost automatically
162	IDAT2	☐	AUFIDAT2	DATUM	DATS	8	0	Technical completion date
163	KDAUF_AUFK	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
164	KDPOS_AUFK	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
165	KBED	☐	KBED_D	XFELD	CHAR	1	0	Ind: do not create capacity requirements
166	CCKEY	☐	CCKEY	CCKEY	CHAR	23	0	Cost collector key
167	KKALKR	☐	COMP_CALC	XFELD	CHAR	1	0	Indicator: Components will not be costed
168	SFCPF	☐	CO_PRODPRF	CO_PRODPRF	CHAR	6	0	Production Scheduling Profile	TCO43
169	KSTAR	☐	AUFKSTAR	KSTAR	CHAR	10	0	Settlement cost element	CSKB
170	USER4	☐	AUFUSER4	AUFUSER4	CURR	11	2	Estimated total costs of order
171	RMNGA	☐	RMNGA	MENGV13	QUAN	13	3	Total confirmed rework quantity
172	NOPCOST	☐	CO_NOPCOST	XFELD	CHAR	1	0	Do not calculate planned costs for order
173	KSTEMPF	☐	CO_KSTEMPF	CO_KSTEMPF	CHAR	1	0	Indicator: Direct cost collector
174	NETZKONT	☐	NETZKONT	NETZKONT	CHAR	1	0	Indicator for the account assignment of a network(hdr/act.)
175	EXT_AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number
176	ORGKEY	☐	AUFNR	AUFNR	CHAR	12	0	Order Number
177	INACT	☐	VSINACT	XFELD	CHAR	1	0	Version inactive indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VSCAUFV	ABGSL	TKKAA	ABGSL	REF	C	CN
2	VSCAUFV	ABKRS	TKO08	ABKRS	REF	1	CN
3	VSCAUFV	AENNR	AENR	AENNR
4	VSCAUFV	AUART	T003O	AUART	REF	1	CN
5	VSCAUFV	AUFNR	VSAUFK_CN	VSNMR	KEY	1	1
6	VSCAUFV	AWSLS	TKV01	AWSLS	REF	C	CN
7	VSCAUFV	BUKRS	T001	BUKRS	REF	1	CN
8	VSCAUFV	CHSCH	T683	KALSM
9	VSCAUFV	CSPLIT	MAKV	CSPLIT
10	VSCAUFV	DISPO	T024D	DISPO
11	VSCAUFV	FEVOR	T024F	FEVOR
12	VSCAUFV	FHORI	T436A	FHORI
13	VSCAUFV	GMEIN	T006	MSEHI
14	VSCAUFV	GSBER	TGSB	GSBER	REF	1	CN
15	VSCAUFV	KALSM	T683	KALSM	REF	1	CN
16	VSCAUFV	KAPPL	T681A	KAPPL	REF	1	CN
17	VSCAUFV	KDAUF_AUFK	VBUK	VBELN		C	CN
18	VSCAUFV	KLVARI	TCK03	KLVAR
19	VSCAUFV	KLVARP	TCK03	KLVAR
20	VSCAUFV	KOKRS	TKA01	KOKRS	REF	1	CN
21	VSCAUFV	KSTAR	CSKB	KSTAR		1	CN
22	VSCAUFV	KVEWE	T681V	KVEWE	REF	1	CN
23	VSCAUFV	LEAD_AUFNR	AUFK	AUFNR
24	VSCAUFV	MANDT	T000	MANDT
25	VSCAUFV	NTZUE	AUFK	AUFNR
26	VSCAUFV	OBJNR	ONR00	OBJNR	REF	1	1
27	VSCAUFV	PAENR	AENR	AENNR
28	VSCAUFV	PLGRP	T024A	FEVOR
29	VSCAUFV	PLNAW	TCA09	PLNAW
30	VSCAUFV	PLNBEZ	MARA	MATNR
31	VSCAUFV	PLNME	T006	MSEHI
32	VSCAUFV	PRCTR	CEPC	PRCTR		1	CN
33	VSCAUFV	PROFID	TCN41	PROFIDNETZ
34	VSCAUFV	PRONR	VSPROJ_CN	VSNMR
35	VSCAUFV	PRUEFLOS	QALS	PRUEFLOS
36	VSCAUFV	PSPEL	VSPRPS_CN	VSNMR	REF	C	CN
37	VSCAUFV	PVERW	T411	VERWE
38	VSCAUFV	RECID	T8JJ	RECID	REF	C	CN
39	VSCAUFV	REFNR	AUFK	AUFNR	REF	1	CN
40	VSCAUFV	RSNID	CRID	OBJID
41	VSCAUFV	SAENR	AENR	AENNR
42	VSCAUFV	SBMEH	T006	MSEHI
43	VSCAUFV	SFCPF	TCO43	CO_PRODPRF	REF
44	VSCAUFV	STLAN	T416	STLAN
45	VSCAUFV	STLBEZ	MARA	MATNR
46	VSCAUFV	STLST	T415S	STLST
47	VSCAUFV	TERKZ	T482	TERMKZ
48	VSCAUFV	TRKZP	T482	TERMKZ
49	VSCAUFV	TXJCD	TTXJ	TXJCD
50	VSCAUFV	VNAME	T8JV	VNAME	REF	C	CN
51	VSCAUFV	WAERS	TCURC	WAERS	REF	1	CN
52	VSCAUFV	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in