SAP ABAP Table AFVGDT (Downtime-Related Information on Operations in Orders)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-PI (Application Component) Production Planning for Process Industries
     ⤷ CRDT (Package) Downtime of the Resource

Basic Data

Table Category	INTTAB	Structure
Structure	AFVGDT	Table Relationship Diagram
Short Description	Downtime-Related Information on Operations in Orders

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	*
2	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
3	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	AFVC
4	VSNMR	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
5	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
6	ARBID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
7	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
8	KAPID	☐	KAPID	KAPID	NUMC	8	0	Capacity ID	*
9	KAPAR	☐	KAPART	KAPART	CHAR	3	0	Capacity category	*
10	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
11	VGWTS	☐	VORGSCHL	VORGSCHL	CHAR	4	0	Standard value key	TC21
12	QLKAPAR	☐	QL_KAPART	KAPART	CHAR	3	0	Capacity category	*
13	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
14	KALID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	TFACD
15	PHFLG	☐	PHFLG	XFELD	CHAR	1	0	Indicator: Phase
16	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
17	ISAVD	☐	ISAVD	DATUM	DATS	8	0	Actual operation start (date)
18	IEAVD	☐	IEAVD	DATUM	DATS	8	0	Actual finish of operation (date)
19	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
20	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
21	IERD	☐	IERD	DATUM	DATS	8	0	Actual finish: Setup (date)
22	IERZ	☐	IERZ	ATIME	TIMS	6	0	Actual finish: Setup (time)
23	ISBD	☐	ISBD	DATUM	DATS	8	0	Actual start: Processing (date)
24	ISBZ	☐	ISBZ	ATIME	TIMS	6	0	Actual start: Processing (time)
25	IEBD	☐	IEBD	DATUM	DATS	8	0	Actual finish: Processing (date)
26	IEBZ	☐	IEBZ	ATIME	TIMS	6	0	Actual processing finish (time)
27	ISAD	☐	ISAD	DATUM	DATS	8	0	Actual start: Teardown (date)
28	ISAZ	☐	ISAZ	ATIME	TIMS	6	0	Actual start: Teardown (time)
29	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
30	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
31	AUFNRD	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
32	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
33	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
34	LAR01	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
35	LAR02	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
36	LAR03	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
37	LAR04	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
38	LAR05	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
39	LAR06	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
40	ISM01	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
41	ISM02	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
42	ISM03	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
43	ISM04	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
44	ISM05	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
45	ISM06	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
46	WARTZ	☐	WARTEZEIT	CX_ZEIT	FLTP	16	16	Queue time used for scheduling
47	WRTZE	☐	WTRZE	EINHEIT	UNIT	3	0	Unit of measure for queue time
48	RUEST	☐	RUEST	CX_ZEIT	FLTP	16	16	Setup time
49	RSTZE	☐	RSTZE	EINHEIT	UNIT	3	0	Unit of measure for setup time
50	BEARZ	☐	BEARZEIT	CX_ZEIT	FLTP	16	16	Processing time
51	BEAZE	☐	BEAZE	EINHEIT	UNIT	3	0	Unit of measure for processing time
52	ABRUE	☐	ABRUE	CX_ZEIT	FLTP	16	16	Teardown
53	ARUZE	☐	ARUZE	EINHEIT	UNIT	3	0	Unit of measure for teardown
54	LIEGZ	☐	LIEGEZEIT	CX_ZEIT	FLTP	16	16	Wait time used for scheduling
55	LIGZE	☐	LIGZE	EINHEIT	UNIT	3	0	Unit of measure for wait time
56	TRANZ	☐	TRANSZEIT	CX_ZEIT	FLTP	16	16	Move time used for scheduling
57	TRAZE	☐	TRAZE	EINHEIT	UNIT	3	0	Unit of measure for move time
58	SLWID	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	*
59	USR00	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
60	USR01	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
61	USR02	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
62	USR03	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
63	USR04	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
64	USE04	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	*
65	USR05	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
66	USE05	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	*
67	USR06	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
68	USE06	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	*
69	USR07	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
70	USE07	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	*
71	USR08	☐	USRDATE	USRDATE	DATS	8	0	User field for date
72	USR09	☐	USRDATE	USRDATE	DATS	8	0	User field for date
73	USR10	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
74	USR11	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
75	ILE01	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
76	ILE02	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
77	ILE03	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
78	ILE04	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
79	ILE05	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
80	ILE06	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
81	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
82	FSAVZ	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
83	FSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
84	FSEDZ	☐	FSEDZ	ATIME	TIMS	6	0	Earliest scheduled finish: Execution (time)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFVGDT	APLZL	AFVC	APLZL
2	AFVGDT	KALID	TFACD	IDENT
3	AFVGDT	VGWTS	TC21	VGWTS
4	AFVGDT	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in