SAP ABAP Table OPS_TABLE_FOR_WRKCENTER_DTL (Work center details)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IPRT (Package) Application Development R/3 Plant Maintenance Print

Basic Data

Table Category	INTTAB	Structure
Structure	OPS_TABLE_FOR_WRKCENTER_DTL	Table Relationship Diagram
Short Description	Work center details

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	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
2	UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
3	.INCLUDE	☐				0	0	View of Work Center from Task Lists
4	ARBID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
5	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
6	CPLGR	☐	CPLGR	CPLGR	CHAR	3	0	CAPP planner group	T024C
7	DATUB	☐	DATUB	DATUM	DATS	8	0	Valid-to date
8	DATUV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
9	KAPID	☐	KAPID	KAPID	NUMC	8	0	Capacity ID	KAKO
10	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
11	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
12	KTEXT	☐	KTXT40	TEXT40	CHAR	40	0	Work center description
13	KTSCH	☐	KTSCH	KTSCH	CHAR	7	0	Standard text key	T435
14	KTSCH_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
15	LAR01	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
16	LAR01_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
17	LAR02	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
18	LAR02_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
19	LAR03	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
20	LAR03_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
21	LAR04	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
22	LAR04_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
23	LAR05	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
24	LAR05_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
25	LAR06	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
26	LAR06_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
27	LARN1	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
28	LARN1_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
29	LOANZ	☐	LOHNANZ	LOHNANZ	DEC	3	0	Number of Time Tickets
30	LOANZ_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
31	LOART	☐	LOHNART	LOART	CHAR	4	0	Wage type
32	LOART_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
33	LVORM	☐	AP_LOEVORM	FLAG	CHAR	1	0	Deletion flag for work center
34	LOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	T421
35	LOGRP_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
36	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
37	MATYP	☐	MATYP	MATYP	CHAR	10	0	Machine type	TMATY
38	MOLGA	☐	MOLGA	MOLGA	CHAR	2	0	Country Grouping	*
39	ORTGR	☐	ORTSGRUPPE	ORTSGRUPPE	CHAR	4	0	Location group	TC28
40	PAR01	☐	PARAMID	PARAMID	CHAR	6	0	Parameter ID	TC20
41	PAR02	☐	PARAMID	PARAMID	CHAR	6	0	Parameter ID	TC20
42	PAR03	☐	PARAMID	PARAMID	CHAR	6	0	Parameter ID	TC20
43	PAR04	☐	PARAMID	PARAMID	CHAR	6	0	Parameter ID	TC20
44	PAR05	☐	PARAMID	PARAMID	CHAR	6	0	Parameter ID	TC20
45	PAR06	☐	PARAMID	PARAMID	CHAR	6	0	Parameter ID	TC20
46	PDEST	☐	CR_PDEST	RSPOPNAME	CHAR	4	0	Printer for shop papers	TSP03
47	PLANV	☐	AP_PLANV	AP_PLANV	CHAR	3	0	Key for task list usage	TC23
48	QUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	T423
49	QUALF_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
50	RASCH	☐	RUEARSCHLU	RUEARSCHLU	CHAR	2	0	Setup Type Key	T428
51	RASCH_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
52	RSANZ	☐	CR_RS_ANZ	NUM03	NUMC	3	0	Number of confirmation slips
53	RSANZ_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
54	RUZUS	☐	RUZUS	RUZUS	CHAR	4	0	Key: rounding and additional values	TCERS
55	SORTB	☐	SORTB	SORTB	CHAR	9	0	Sort string	TSRTB
56	STATUS	☐	AP_STATUS	AP_STATUS	CHAR	1	0	Work center status
57	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	T430
58	STEUS_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
59	VGARB	☐	VGWRTAR	MEINS	UNIT	3	0	Unit of measure of work	*
60	VGDAU	☐	DAUNORE	MEINS	UNIT	3	0	Normal duration/unit	T006
61	VGDIM	☐	VGDIMAR	DIMID	CHAR	6	0	Dimension of work	*
62	VGD01	☐	DIMID	DIMID	CHAR	6	0	Dimension key	*
63	VGD02	☐	DIMID	DIMID	CHAR	6	0	Dimension key	*
64	VGD03	☐	DIMID	DIMID	CHAR	6	0	Dimension key	*
65	VGD04	☐	DIMID	DIMID	CHAR	6	0	Dimension key	*
66	VGD05	☐	DIMID	DIMID	CHAR	6	0	Dimension key	*
67	VGD06	☐	DIMID	DIMID	CHAR	6	0	Dimension key	*
68	VGE01	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	*
69	VGE02	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	*
70	VGE03	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	*
71	VGE04	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	*
72	VGE05	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	*
73	VGE06	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	*
74	VGM01	☐	AP_VGW_MES	AP_VGW_FLG	CHAR	1	0	Rule for standard value maintenance
75	VGM02	☐	AP_VGW_MES	AP_VGW_FLG	CHAR	1	0	Rule for standard value maintenance
76	VGM03	☐	AP_VGW_MES	AP_VGW_FLG	CHAR	1	0	Rule for standard value maintenance
77	VGM04	☐	AP_VGW_MES	AP_VGW_FLG	CHAR	1	0	Rule for standard value maintenance
78	VGM05	☐	AP_VGW_MES	AP_VGW_FLG	CHAR	1	0	Rule for standard value maintenance
79	VGM06	☐	AP_VGW_MES	AP_VGW_FLG	CHAR	1	0	Rule for standard value maintenance
80	VGT01	☐	PARATEXT	VORGATEXT	CHAR	11	0	Short key word for parameter ID
81	VGT02	☐	PARATEXT	VORGATEXT	CHAR	11	0	Short key word for parameter ID
82	VGT03	☐	PARATEXT	VORGATEXT	CHAR	11	0	Short key word for parameter ID
83	VGT04	☐	PARATEXT	VORGATEXT	CHAR	11	0	Short key word for parameter ID
84	VGT05	☐	PARATEXT	VORGATEXT	CHAR	11	0	Short key word for parameter ID
85	VGT06	☐	PARATEXT	VORGATEXT	CHAR	11	0	Short key word for parameter ID
86	VGTL1	☐	PARALTXT	TEXT20	CHAR	20	0	Key word for parameter ID
87	VGTL2	☐	PARALTXT	TEXT20	CHAR	20	0	Key word for parameter ID
88	VGTL3	☐	PARALTXT	TEXT20	CHAR	20	0	Key word for parameter ID
89	VGTL4	☐	PARALTXT	TEXT20	CHAR	20	0	Key word for parameter ID
90	VGTL5	☐	PARALTXT	TEXT20	CHAR	20	0	Key word for parameter ID
91	VGTL6	☐	PARALTXT	TEXT20	CHAR	20	0	Key word for parameter ID
92	VGWTS	☐	VORGSCHL	VORGSCHL	CHAR	4	0	Standard value key	TC21
93	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
94	XSPRR	☐	AP_XSPRR	XFELD	CHAR	1	0	Indicator: Work center is locked
95	XTERM	☐	AP_XTERM	XFELD	CHAR	1	0	Indicator: Work center is maintained for scheduling
96	ZGR01	☐	IDZEITGRAD	IDZEITGRAD	CHAR	3	0	Key for performance efficiency rate	TC31
97	ZGR01_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
98	ZGR02	☐	IDZEITGRAD	IDZEITGRAD	CHAR	3	0	Key for performance efficiency rate	TC31
99	ZGR02_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
100	ZGR03	☐	IDZEITGRAD	IDZEITGRAD	CHAR	3	0	Key for performance efficiency rate	TC31
101	ZGR03_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
102	ZGR04	☐	IDZEITGRAD	IDZEITGRAD	CHAR	3	0	Key for performance efficiency rate	TC31
103	ZGR04_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
104	ZGR05	☐	IDZEITGRAD	IDZEITGRAD	CHAR	3	0	Key for performance efficiency rate	TC31
105	ZGR05_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
106	ZGR06	☐	IDZEITGRAD	IDZEITGRAD	CHAR	3	0	Key for performance efficiency rate	TC31
107	ZGR06_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
108	ZEIWM	☐	DZEIWM	MEINS	UNIT	3	0	Unit for the minumum queue time	T006
109	ZEIWN	☐	DZEIWN	MEINS	UNIT	3	0	Unit for the standard queue time	T006
110	ZWMIN	☐	DZWMIN	VGWRT	QUAN	9	3	Minimum queue time
111	ZWNOR	☐	DZWNOR	VGWRT	QUAN	9	3	Standard queue time
112	HR	☐	AP_KZHR	XFELD	CHAR	1	0	Work center only resides in HR
113	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	*
114	SUBSYS	☐	QEIFSUBSYS	QEIFSUBSYS	CHAR	6	0	Subsystem Identifier for QM Subsystem Interface	*
115	BDEGR	☐	BDEGR	BDEGR	CHAR	3	0	Grouping for Connection to Subsystem	*
116	RGEKZ	☐	RGEKZAP	XFELD	CHAR	1	0	Indicator: Backflushing
117	SLWID	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	*
118	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
119	SLWID_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
120	LIFNR_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
121	FLG_AFR	☐	FLG_AFR	FLAG	CHAR	1	0	Indicator: Work center only allowed until release
122	ISTBED_KZ	☐	CY_ISTBEDKZ	CY_ISTBEDKZ	CHAR	1	0	Calculation of actual capacity requirements
123	PRZ01	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
124	PRZ01_REF	☐	AP_KZREF	XFELD	CHAR	1	0	Field is referenced
125	ACTXY1	☐	ACTXY	ACTXY	CHAR	1	0	Activity description type
126	ACTXK1	☐	ACTXK	CHAR4	CHAR	4	0	Key for alternative activity description
127	LEINH1	☐	LEINH	MEINS	UNIT	3	0	Activity Unit	*
128	BDE1	☐	BDENR	BDENR	CHAR	1	0	Transfer activity types to incentive wages
129	SAKL1	☐	SA_KLASSE	SA_KLASSE	NUMC	1	0	Record type group
130	ACTXY2	☐	ACTXY	ACTXY	CHAR	1	0	Activity description type
131	ACTXK2	☐	ACTXK	CHAR4	CHAR	4	0	Key for alternative activity description
132	LEINH2	☐	LEINH	MEINS	UNIT	3	0	Activity Unit	*
133	BDE2	☐	BDENR	BDENR	CHAR	1	0	Transfer activity types to incentive wages
134	SAKL2	☐	SA_KLASSE	SA_KLASSE	NUMC	1	0	Record type group
135	ACTXY3	☐	ACTXY	ACTXY	CHAR	1	0	Activity description type
136	ACTXK3	☐	ACTXK	CHAR4	CHAR	4	0	Key for alternative activity description
137	LEINH3	☐	LEINH	MEINS	UNIT	3	0	Activity Unit	*
138	BDE3	☐	BDENR	BDENR	CHAR	1	0	Transfer activity types to incentive wages
139	SAKL3	☐	SA_KLASSE	SA_KLASSE	NUMC	1	0	Record type group
140	ACTXY4	☐	ACTXY	ACTXY	CHAR	1	0	Activity description type
141	ACTXK4	☐	ACTXK	CHAR4	CHAR	4	0	Key for alternative activity description
142	LEINH4	☐	LEINH	MEINS	UNIT	3	0	Activity Unit	*
143	BDE4	☐	BDENR	BDENR	CHAR	1	0	Transfer activity types to incentive wages
144	SAKL4	☐	SA_KLASSE	SA_KLASSE	NUMC	1	0	Record type group
145	ACTXY5	☐	ACTXY	ACTXY	CHAR	1	0	Activity description type
146	ACTXK5	☐	ACTXK	CHAR4	CHAR	4	0	Key for alternative activity description
147	LEINH5	☐	LEINH	MEINS	UNIT	3	0	Activity Unit	*
148	BDE5	☐	BDENR	BDENR	CHAR	1	0	Transfer activity types to incentive wages
149	SAKL5	☐	SA_KLASSE	SA_KLASSE	NUMC	1	0	Record type group
150	ACTXY6	☐	ACTXY	ACTXY	CHAR	1	0	Activity description type
151	ACTXK6	☐	ACTXK	CHAR4	CHAR	4	0	Key for alternative activity description
152	LEINH6	☐	LEINH	MEINS	UNIT	3	0	Activity Unit	*
153	BDE6	☐	BDENR	BDENR	CHAR	1	0	Transfer activity types to incentive wages
154	SAKL6	☐	SA_KLASSE	SA_KLASSE	NUMC	1	0	Record type group
155	BDEP	☐	BDENR	BDENR	CHAR	1	0	Transfer activity types to incentive wages
156	SAKLP	☐	SA_KLASSE	SA_KLASSE	NUMC	1	0	Record type group

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OPS_TABLE_FOR_WRKCENTER_DTL	CPLGR	T024C	CPLGR
2	OPS_TABLE_FOR_WRKCENTER_DTL	KAPID	KAKO	KAPID	REF	C	CN
3	OPS_TABLE_FOR_WRKCENTER_DTL	KOKRS	TKA01	KOKRS
4	OPS_TABLE_FOR_WRKCENTER_DTL	KOSTL	CSKS	KOSTL
5	OPS_TABLE_FOR_WRKCENTER_DTL	KTSCH	T435	VLSCH
6	OPS_TABLE_FOR_WRKCENTER_DTL	LOGRP	T421	LOGRP
7	OPS_TABLE_FOR_WRKCENTER_DTL	MANDT	T000	MANDT
8	OPS_TABLE_FOR_WRKCENTER_DTL	MATYP	TMATY	MATYP
9	OPS_TABLE_FOR_WRKCENTER_DTL	ORTGR	TC28	ORTGR
10	OPS_TABLE_FOR_WRKCENTER_DTL	PAR01	TC20	PARID
11	OPS_TABLE_FOR_WRKCENTER_DTL	PAR02	TC20	PARID
12	OPS_TABLE_FOR_WRKCENTER_DTL	PAR03	TC20	PARID
13	OPS_TABLE_FOR_WRKCENTER_DTL	PAR04	TC20	PARID
14	OPS_TABLE_FOR_WRKCENTER_DTL	PAR05	TC20	PARID
15	OPS_TABLE_FOR_WRKCENTER_DTL	PAR06	TC20	PARID
16	OPS_TABLE_FOR_WRKCENTER_DTL	PDEST	TSP03	PADEST
17	OPS_TABLE_FOR_WRKCENTER_DTL	PLANV	TC23	PLANV
18	OPS_TABLE_FOR_WRKCENTER_DTL	QUALF	T423	QUALF
19	OPS_TABLE_FOR_WRKCENTER_DTL	RASCH	T428	RASCH
20	OPS_TABLE_FOR_WRKCENTER_DTL	RUZUS	TCERS	RUZUS
21	OPS_TABLE_FOR_WRKCENTER_DTL	SORTB	TSRTB	SORTB
22	OPS_TABLE_FOR_WRKCENTER_DTL	STEUS	T430	STEUS
23	OPS_TABLE_FOR_WRKCENTER_DTL	VGDAU	T006	MSEHI
24	OPS_TABLE_FOR_WRKCENTER_DTL	VGWTS	TC21	VGWTS
25	OPS_TABLE_FOR_WRKCENTER_DTL	WERKS	T001W	WERKS
26	OPS_TABLE_FOR_WRKCENTER_DTL	ZEIWM	T006	MSEHI
27	OPS_TABLE_FOR_WRKCENTER_DTL	ZEIWN	T006	MSEHI
28	OPS_TABLE_FOR_WRKCENTER_DTL	ZGR01	TC31	ID
29	OPS_TABLE_FOR_WRKCENTER_DTL	ZGR02	TC31	ID
30	OPS_TABLE_FOR_WRKCENTER_DTL	ZGR03	TC31	ID
31	OPS_TABLE_FOR_WRKCENTER_DTL	ZGR04	TC31	ID
32	OPS_TABLE_FOR_WRKCENTER_DTL	ZGR05	TC31	ID
33	OPS_TABLE_FOR_WRKCENTER_DTL	ZGR06	TC31	ID

History

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