SAP ABAP Table AFVC (Operation within an order)

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	TRANSP	Transparent table
Transparent table	AFVC	Table Relationship Diagram
Short Description	Operation within an order

Delivery and Maintenance

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

History

Last changed by/on	SAP	20130604
SAP Release Created in