SAP ABAP Table AFVGI (General include structure of the operation data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC (Application Component) Interaction Center WinClient
     ⤷ CO (Package) R/3 Application development: PP Production orders

Basic Data

Table Category	INTTAB	Structure
Structure	AFVGI	Table Relationship Diagram
Short Description	General include structure of the operation data

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	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
2	PLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
3	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
4	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
5	VINTV	☐	VINTV	VINTV	DEC	3	0	Increment between referenced operations
6	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
7	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
8	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
9	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	*
10	ARBID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
11	PDEST	☐	CR_PDEST	RSPOPNAME	CHAR	4	0	Printer for shop papers	TSP03
12	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
13	KTSCH	☐	KTSCH	KTSCH	CHAR	7	0	Standard text key	*
14	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
15	LTXA2	☐	LTXA2	TEXT40	CHAR	40	0	Second line of the description
16	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
17	VPLTY	☐	VPLNTY	PLNTY	CHAR	1	0	Type of the referenced task list	*
18	VPLNR	☐	VPLNNR	PLNNR	CHAR	8	0	Group of the referenced task list
19	VPLAL	☐	VPLNAL	ALTNR	CHAR	2	0	Group counter of the referenced task list
20	VPLFL	☐	VPLBFL	PLNFOLGE	CHAR	6	0	Referenced sequence in routing
21	VGWTS	☐	VORGSCHL	VORGSCHL	CHAR	4	0	Standard value key	*
22	LAR01	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
23	LAR02	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
24	LAR03	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
25	LAR04	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
26	LAR05	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
27	LAR06	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
28	ZERMA	☐	DZERMA	ZERMA	CHAR	5	0	Type of standard value calculation	*
29	ZGDAT	☐	DZGDAT	CJAHR	CHAR	4	0	Date when the standard value was calculated
30	ZCODE	☐	DZCODE	ZCODE	CHAR	6	0	Reference number for standard value code
31	ZULNR	☐	DZULNR	ZULNR	CHAR	5	0	Basis for standard value calculation
32	LOANZ	☐	LOHNANZ	LOHNANZ	DEC	3	0	Number of Time Tickets
33	LOART	☐	LOHNART	LOART	CHAR	4	0	Wage type
34	RSANZ	☐	CR_RS_ANZ	NUM03	NUMC	3	0	Number of confirmation slips
35	QUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	*
36	ANZMA	☐	ANZMS	ANZMA	DEC	5	2	Number of employees
37	RFGRP	☐	RUEFAGRP	RUEFAGRP	CHAR	10	0	Setup group category	*
38	RFSCH	☐	RUEFASCHLU	RUEFASCHLU	CHAR	10	0	Setup group key	*
39	RASCH	☐	RUEARSCHLU	RUEARSCHLU	CHAR	2	0	Setup Type Key	*
40	AUFAK	☐	AUSCHUFAK	AUSCHUFAK	DEC	5	3	Scrap factor
41	LOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	*
42	UEMUS	☐	UEMUSKZ	XFELD	CHAR	1	0	Required overlapping
43	UEKAN	☐	UEKANKZ	XFELD	CHAR	1	0	Optional overlapping
44	FLIES	☐	FLIESSKZ	XFELD	CHAR	1	0	Indicator: continuous flow production
45	SPMUS	☐	SPLITTUNG	XFELD	CHAR	1	0	Required splitting
46	SPLIM	☐	SPLITTANZ	SPLITTANZ	DEC	3	0	Maximum number of splits
47	ABLIPKZ	☐	ABLIPKZ	FLAG	CHAR	1	0	Indicator: simultaneous teardown and wait
48	RSTRA	☐	RSTRA	RSTRA	CHAR	2	0	Reduction strategy per operation/activity	*
49	SUMNR	☐	SUMKNTNR	KNTNR	NUMC	8	0	Node number of the superior operation
50	SORTL	☐	SORTI	CHAR10	CHAR	10	0	Sort Term for Non-Stock Info Records
51	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
52	PREIS	☐	PREIS	WERT11	CURR	11	2	Price
53	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
54	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	*
55	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
56	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
57	ESOKZ	☐	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
58	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
59	EKGRP	☐	VG_EKGRP	EKGRP	CHAR	3	0	Purchasing group for external processing	T024
60	KZLGF	☐	KZLGF	XFELD	CHAR	1	0	Indicator: fixed lot external processing
61	KZWRTF	☐	KZWRTF	XFELD	CHAR	1	0	Indicator: Fixed price for external processing
62	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
63	DDEHN	☐	DAUDEHN	X	CHAR	1	0	Indicator: flexible duration
64	ANZZL	☐	ANZKAP	INT1	INT1	3	0	Number of capacities required
65	PRZNT	☐	APROZENT	INT1	INT1	3	0	Work percentage
66	MLSTN	☐	MILESTONE	MILESTONE	CHAR	5	0	Usage	*
67	PPRIO	☐	PRIORITAET	PRIORITAET	CHAR	2	0	Priority
68	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
69	ANFKO	☐	ANFKO	KOSTL	CHAR	10	0	Requesting cost center	CSKS
70	ANFKOKRS	☐	ANFKOKRS	CACCD	CHAR	4	0	Controlling area of the requesting cost center	TKA01
71	INDET	☐	INDET	INDET	CHAR	1	0	Calculation key
72	LARNT	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
73	PRKST	☐	PRKST	PRKST	CURR	11	2	Costs in the activity
74	APLFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
75	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
76	RMZHL	☐	CO_RMZHL	CIM_COUNT	NUMC	8	0	Confirmation counter
77	PROJN	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
78	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
79	SPANZ	☐	SPLITTERM	DEC3	DEC	3	0	Actual number of splits
80	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
81	BEDZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
82	BANFN	☐	CO_BANFN	BANFN	CHAR	10	0	Purchase requisition number
83	BNFPO	☐	CO_BNFPO	BNFPO	NUMC	5	0	Item number of the purchase requisition in the order	EBAN
84	LEK01	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
85	LEK02	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
86	LEK03	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
87	LEK04	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
88	LEK05	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
89	LEK06	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
90	SELKZ	☐	CO_SELKZ	CK_SELKZ	CHAR	1	0	Selection indicator for costing line items	*
91	KALID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	TFACD
92	FRSP	☐	FRSP	FRSP	CHAR	1	0	Earliest possible activity / Latest possible activity
93	STDKN	☐	STDKN	KNTNR	NUMC	8	0	Node of operation within reference operation set
94	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	*
95	ISTRU	☐	ISTRU	MATNR	CHAR	18	0	Assembly
96	ISTTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
97	ISTNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
98	ISTKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
99	ISTPO	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
100	IUPOZ	☐	UPOSZ	SPOSN	CHAR	4	0	Subitem Number
101	EBORT	☐	EBORT	TEXT20	CHAR	20	0	Installation Point for Subitem
102	VERTL	☐	CR_VERTN	CR_VERTL	CHAR	8	0	Distr.cap.reqmts (plant maint.,process order, network)	*
103	LEKNW	☐	LEKNW	XFELD	CHAR	1	0	Indicator: No Remaining Work Expected
104	NPRIO	☐	NW_PRIO	NW_PRIO	CHAR	1	0	Priority	*
105	PVZKN	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
106	PHFLG	☐	PHFLG	XFELD	CHAR	1	0	Indicator: Phase
107	PHSEQ	☐	PHSEQ	PHSEQ	CHAR	2	0	Control Recipe Destination	*
108	KNOBJ	☐	KNOBJ	KNOBJ	NUMC	18	0	Number of Object with Assigned Dependencies
109	ERFSICHT	☐	QERFSICHT	QERFSICHT	CHAR	2	0	Recording View
110	QPPKTABS	☐	QPPKTABS	QPPKTABS	CHAR	1	0	Flow Variants for Inspection Point Completion
111	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
112	OBJEKTID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
113	QLKAPAR	☐	QL_KAPART	KAPART	CHAR	3	0	Capacity category	*
114	RSTUF	☐	RSTUF	REDST	NUMC	1	0	Reduction level which reduces operation lead time
115	NPTXTKY	☐	TXTKY	CHAR12	CHAR	12	0	Internal text number (12-character)
116	SUBSYS	☐	QEIFSUBSYS	QEIFSUBSYS	CHAR	6	0	Subsystem Identifier for QM Subsystem Interface	*
117	PSPNR	☐	PS_SPS_ELE	PS_SPSNR	NUMC	8	0	Standard WBS element	*
118	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
119	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
120	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
121	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
122	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
123	NO_DISP	☐	NO_DISP_PLUS	NO_DISP_PLUS	CHAR	1	0	Effective for Materials Planning
124	QKZPRZEIT	☐	QKZPRZEIT	QKZ	CHAR	1	0	Interval = Time (Time-Related)
125	QKZZTMG1	☐	QKZZTMG1	QKZ	CHAR	1	0	Quantity Confirmation for Each Partial Lot
126	QKZPRMENG	☐	QKZPRMENG	QKZ	CHAR	1	0	Creation Cycle = Quantity (Quantity-Reference)
127	QKZPRFREI	☐	QKZPRFREI	QKZ	CHAR	1	0	Interval Without Reference to Time or Quantity
128	KZFEAT	☐	QKZFEAT	QKZFEAT	CHAR	1	0	Indicator Is Not Used Currently
129	QKZTLSBEST	☐	QKZTLSBEST	QKZ	CHAR	1	0	Operation with Stock-Related Partial Lot Assignment
130	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
131	CUOBJ_ARB	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
132	EVGEW	☐	EV_WEIGHTD	DEC8	DEC	8	0	Aggregation weight for POC (PS progress)
133	ARBII	☐	CR_OBJID_I	CR_OBJID	NUMC	8	0	Actual operating resources object identification	*
134	WERKI	☐	WERKS_I	WERKS	CHAR	4	0	Actual plant	T001W
135	CY_SEQNRV	☐	CY_SEQNRV	CY_SEQNR	NUMC	14	0	Sequence number operation
136	KAPT_PUFFR	☐	KAPT_PUFFR	INT4	INT4	10	0	Operation floats after finite scheduling (in seconds)
137	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
138	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
139	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
140	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
141	CLASF	☐	CLASF	XFELD	CHAR	1	0	Ind.: Take Activity Into Account for Project Summarization
142	FRUNV	☐	FRUNV	KREUZ	CHAR	1	0	Indicator: External procurement data incomplete
143	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
144	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	*
145	SCHED_END	☐	SCEND_ACT	XFELD	CHAR	1	0	Ind.: Purchase requisition at activity finish date
146	NETZKONT	☐	NETZKONT	NETZKONT	CHAR	1	0	Indicator for the account assignment of a network(hdr/act.)
147	OWAER	☐	OWAERS	WAERS	CUKY	5	0	Object currency for network activity	TCURC
148	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
149	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
150	KZFIX	☐	CN_KZFIX	XFELD	CHAR	1	0	Indicator: Purchasing info record data are fixed
151	PERNR	☐	CO_PERNR	PERNR	NUMC	8	0	Personnel number
152	FRDLB	☐	CO_FRDLB	CHAR1	CHAR	1	0	Indicator: Externally processed op. with subcontracting
153	QPART	☐	QPART	QPART	CHAR	8	0	Inspection Type	*
154	LOEKZ	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
155	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
156	PROD_ACT	☐	PROD_ACT	XFELD	CHAR	1	0	Indicator: Activity is a production activity
157	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
158	OBJTYPE	☐	OCM_OBJ_TYPE	OCM_OBJ_TYPE	CHAR	1	0	Change indicator
159	CH_PROC	☐	OCM_CH_PROC	OCM_CH_PROC	CHAR	1	0	Process that has lead to the change of an object
160	KLVAR	☐	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant	*
161	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
162	FORDN	☐	SFORDN	EBELN	CHAR	10	0	Framework Order	*
163	FORDP	☐	FORDP	EBELP	NUMC	5	0	Item of framework order	*
164	MAT_PRKST	☐	MAT_PRKST	PRKST	CURR	11	2	Material planning in networks: primary costs
165	PRZ01	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFVGI	AENNR	AENR	AENNR
2	AFVGI	ANFKO	CSKS	KOSTL
3	AFVGI	ANFKOKRS	TKA01	KOKRS
4	AFVGI	BNFPO	EBAN	BNFPO
5	AFVGI	BUKRS	T001	BUKRS
6	AFVGI	EBELN	EKKO	EBELN
7	AFVGI	EBELP	EKPO	EBELP
8	AFVGI	EKGRP	T024	EKGRP
9	AFVGI	EKORG	T024E	EKORG
10	AFVGI	KALID	TFACD	IDENT
11	AFVGI	LIFNR	LFA1	LIFNR
12	AFVGI	MATKL	T023	MATKL
13	AFVGI	OBJNR	ONR00	OBJNR
14	AFVGI	OTYPE	T778O	OTYPE
15	AFVGI	OWAER	TCURC	WAERS
16	AFVGI	PDEST	TSP03	PADEST
17	AFVGI	PROJN	PRPS	PSPNR
18	AFVGI	TXTSP	T002	SPRAS
19	AFVGI	WAERS	TCURC	WAERS
20	AFVGI	WERKI	T001W	WERKS
21	AFVGI	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130604
SAP Release Created in