SAP ABAP Table V_TCX00_SOP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TCX00_SOP	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	AUFTG	☑	AUFTG	AUFTG	CHAR	2	0	Order group for capacity planning
4	AUFTA	☑	AUFTA	AUFTA	CHAR	4	0	Order type in capacity planning
5	VAGRP	☑	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	T024F
6	WERKS_TEXT	☐	NAME1	TEXT30	CHAR	30	0	Name
7	FEVOR_TEXT	☐	TXT_FEVOR	TEXT30	CHAR	30	0	Description of production scheduler
8	PHORI	☐	PHORI	NUMC3	NUMC	3	0	Scheduling horizon (detailed planning)
9	APLS1	☐	APLS1	CP_SEL_ID	CHAR	2	0	Selection ID (detailed planning)	TCA43
10	TERM1	☐	TERMX	XFELD	CHAR	1	0	Lead time scheduling (detailed planning)
11	KAPK1	☐	KAPKX	XFELD	CHAR	1	0	Indicator: Generate capacity reqmts (detailed planning)
12	PHORI_2	☐	PHORI_2	NUMC3	NUMC	3	0	Scheduling horizon (detailed planning, medium term)
13	APLS1_2	☐	APLS1_2	CP_SEL_ID	CHAR	2	0	Selection ID for routing (detailed planning, medium term)
14	TERM1_2	☐	TERMX_2	XFELD	CHAR	1	0	Lead time scheduling (detailed planning, medium term)
15	KAPK1_2	☐	KAPKX_2	XFELD	CHAR	1	0	Create capacity requirements (detailed planning,medium term)
16	PHORI_3	☐	PHORI_3	NUMC3	NUMC	3	0	Scheduling horizon (detailed planning, long term)
17	APLS1_3	☐	APLS1_3	CP_SEL_ID	CHAR	2	0	Selection ID for routing (detailed planning, long term)
18	KAPK1_3	☐	KAPKX_3	XFELD	CHAR	1	0	Create capacity requirements (detailed planning, long term)
19	TERM1_3	☐	TERMX_3	XFELD	CHAR	1	0	Lead time scheduling (detailed planning, long term)
20	RATHR	☐	RATHR	NUMC3	NUMC	3	0	Rate-based planning horizon
21	APLS2	☐	APLS2	CP_SEL_ID	CHAR	2	0	Selection ID (rate-based planning)	TCA43
22	TERM2	☐	TERMX_RATE	XFELD	CHAR	1	0	Lead time scheduling (rate-based planning)
23	KAPK2	☐	KAPKX_RATE	XFELD	CHAR	1	0	Create capacity requirements (rate-based planning)
24	GROHR	☐	GROHR	NUMC3	NUMC	3	0	Rough-cut planning horizon
25	APLS3	☐	APLS3	CP_SEL_ID	CHAR	2	0	Selection ID (rough-cut planning)	TCA43
26	TERM3	☐	TERMX_GROB	XFELD	CHAR	1	0	Lead time scheduling (rough-cut planning)
27	KAPK3	☐	KAPKX_GROB	XFELD	CHAR	1	0	Create capacity requirements (rough-cut planning)
28	DADJ1	☐	DADJ1	DADJ1	CHAR	1	0	Scheduling level for adjusting basic dates
29	DADJ2	☐	DADJ2	DADJ2	CHAR	1	0	Adjust dates in lead time scheduling
30	DADJ3	☐	DADJ3	DADJ3	CHAR	1	0	Adjusting dates when dispatching planned orders
31	TERMKZ	☐	TERMKZ	TERART	CHAR	1	0	Scheduling type	T482
32	TERMKZ_TXT	☐	TERMKZ_TXT	TEXT30	CHAR	30	0	Description of scheduling type
33	TERM_AUTO	☐	TERM_AUTO	FLAG	CHAR	1	0	Indicator: Calculate dates automatically during saving
34	PROT_AUTO	☐	PROT_AUTO	XFLAG	CHAR	1	0	Display scheduling log automatically
35	STVERG	☐	STVERG	STVERG	NUMC	3	0	Maximum number of days start date can be in the past
36	MATFRUEH	☐	LAGE_FR	LAGE_FR	CHAR	1	0	Latest date for material staging
37	BREAKS	☐	BREAKS	XFELD	CHAR	1	0	Indicator: Scheduling allowing for breaks
38	PROD_DATES	☐	PROD_DATES	XFELD	CHAR	1	0	Scheduling based on production dates
39	AUF_SHIFT	☐	AUF_SHIFT	XFELD	CHAR	1	0	Indicator: Shift order/network
40	REDST_MAX	☐	REDST_MAX	REDST_MAX	NUMC	1	0	Maximum reduction level
41	REDVS_S1	☐	REDVS_S1	CX_RPROZ	DEC	3	0	Red. of floats before and after production (%)
42	REDVS_S2	☐	REDVS_S2	CX_RPROZ	DEC	3	0	Reduction level 2: Red. of floats bef./after prod. (in %)
43	REDVS_S3	☐	REDVS_S3	CX_RPROZ	DEC	3	0	Reduction level 3: Red. of floats bef./aft. prod. (in %)
44	REDVS_S4	☐	REDVS_S4	CX_RPROZ	DEC	3	0	Reduction level 4: Red. of floats bef./aft. prod. (in %)
45	REDVS_S5	☐	REDVS_S5	CX_RPROZ	DEC	3	0	Reduction level 5: Red. of floats bef./aft. prod. (in %)
46	REDVS_S6	☐	REDVS_S6	CX_RPROZ	DEC	3	0	Reduction level 6: Red. of floats bef./aft. prod. (in %)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_TCX00_SOP	APLS1	TCA43	SEL_ID	KEY	1	CN
2	V_TCX00_SOP	APLS2	TCA43	SEL_ID	KEY	1	CN
3	V_TCX00_SOP	APLS3	TCA43	SEL_ID	KEY	1	CN
4	V_TCX00_SOP	MANDT	T000	MANDT	KEY	1	CN
5	V_TCX00_SOP	TERMKZ	T482	TERMKZ	KEY	1	CN
6	V_TCX00_SOP	VAGRP	T024F	FEVOR	KEY	1	CN
7	V_TCX00_SOP	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in