SAP Table AFVC
Operation within an order
AFVC (Operation within an order) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link AFVC to other SAP tables.
AFVC table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||||
|
AUFPL
Routing number of operations in the order
|
CO_AUFPL |
NUMC
|
10 | 0 | ||||||||||||||||||||||||||||
|
APLZL
General counter for order
|
CO_APLZL |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
PLNFL
Sequence
|
PLNFOLGE |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||
|
PLNKN
Number of the task list node
|
PLNKN |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
PLNAL
Group Counter
|
PLNAL |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
PLNTY
Task List Type
|
PLNTY | TCA01 |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||
|
VINTV
Increment between referenced operations
|
VINTV |
DEC
|
3 | 0 | ||||||||||||||||||||||||||||
|
PLNNR
Key for Task List Group
|
PLNNR |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||||
|
ZAEHL
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
VORNR
Operation/Activity Number
|
VORNR |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
STEUS
Control key
|
STEUS | T430 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
ARBID
Object ID of the resource
|
CR_OBJID | CRID |
NUMC
|
8 | 0 | |||||||||||||||||||||||||||
|
PDEST
Printer for shop papers
|
CR_PDEST | TSP03 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
KTSCH
Standard text key
|
KTSCH | T435 |
CHAR
|
7 | 0 | |||||||||||||||||||||||||||
|
LTXA1
Operation short text
|
LTXA1 |
CHAR
|
40 | 0 | ||||||||||||||||||||||||||||
|
LTXA2
Second line of the description
|
LTXA2 |
CHAR
|
40 | 0 | ||||||||||||||||||||||||||||
|
TXTSP
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||||||||||||||||||||||
|
VPLTY
Type of the referenced task list
|
VPLNTY | TCA01 |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||
|
VPLNR
Group of the referenced task list
|
VPLNNR |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||||
|
VPLAL
Group counter of the referenced task list
|
VPLNAL |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
VPLFL
Referenced sequence in routing
|
VPLBFL |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||
|
VGWTS
Standard value key
|
VORGSCHL | TC21 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
LAR01
Activity Type
|
LSTAR | CSLA |
CHAR
|
6 | 0 | |||||||||||||||||||||||||||
|
LAR02
Activity Type
|
LSTAR | CSLA |
CHAR
|
6 | 0 | |||||||||||||||||||||||||||
|
LAR03
Activity Type
|
LSTAR | CSLA |
CHAR
|
6 | 0 | |||||||||||||||||||||||||||
|
LAR04
Activity Type
|
LSTAR | CSLA |
CHAR
|
6 | 0 | |||||||||||||||||||||||||||
|
LAR05
Activity Type
|
LSTAR | CSLA |
CHAR
|
6 | 0 | |||||||||||||||||||||||||||
|
LAR06
Activity Type
|
LSTAR | CSLA |
CHAR
|
6 | 0 | |||||||||||||||||||||||||||
|
ZERMA
Type of standard value calculation
|
DZERMA | T429 |
CHAR
|
5 | 0 | |||||||||||||||||||||||||||
|
ZGDAT
Date when the standard value was calculated
|
DZGDAT |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
ZCODE
Reference number for standard value code
|
DZCODE |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||
|
ZULNR
Basis for standard value calculation
|
DZULNR |
CHAR
|
5 | 0 | ||||||||||||||||||||||||||||
|
LOANZ
Number of Time Tickets
|
LOHNANZ |
DEC
|
3 | 0 | ||||||||||||||||||||||||||||
|
LOART
Wage Type
|
LOHNART |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
RSANZ
Number of confirmation slips
|
CR_RS_ANZ |
NUMC
|
3 | 0 | ||||||||||||||||||||||||||||
|
QUALF
Suitability
|
QUALF | T423 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
ANZMA
Number of employees
|
ANZMS |
DEC
|
5 | 2 | ||||||||||||||||||||||||||||
|
RFGRP
Setup group category
|
RUEFAGRP | T426 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
RFSCH
Setup group key
|
RUEFASCHLU | T425 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
RASCH
Setup Type Key
|
RUEARSCHLU | T428 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
AUFAK
Scrap factor
|
AUSCHUFAK |
DEC
|
5 | 3 | ||||||||||||||||||||||||||||
|
LOGRP
Wage group
|
LOHNGRP | T421 |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
UEMUS
Required overlapping
|
UEMUSKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
UEKAN
Optional overlapping
|
UEKANKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
FLIES
Indicator: continuous flow production
|
FLIESSKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
SPMUS
Required splitting
|
SPLITTUNG |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
SPLIM
Maximum number of splits
|
SPLITTANZ |
DEC
|
3 | 0 | ||||||||||||||||||||||||||||
|
ABLIPKZ
Indicator: simultaneous teardown and wait
|
ABLIPKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
RSTRA
Reduction strategy per operation/activity
|
RSTRA | T499Q |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
SUMNR
Node number of the superior operation
|
SUMKNTNR |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
SORTL
Sort Term for Non-Stock Info Records
|
SORTI |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
LIFNR
Account Number of Vendor or Creditor
|
LIFNR | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
PREIS
Price
|
PREIS |
CURR
|
11 | 2 | ||||||||||||||||||||||||||||
|
PEINH
Price Unit
|
PEINH |
DEC
|
5 | 0 | ||||||||||||||||||||||||||||
|
SAKTO
Cost Element
|
KSTAR | CSKA |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||||||||||||||||
|
INFNR
Number of Purchasing Info Record
|
INFNR | EINA |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
ESOKZ
Purchasing info record category
|
ESOKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
EKORG
Purchasing Organization
|
EKORG | T024E |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
EKGRP
Purchasing group for external processing
|
VG_EKGRP | T024 |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
KZLGF
Indicator: fixed lot external processing
|
KZLGF |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
KZWRTF
Indicator: Fixed price for external processing
|
KZWRTF |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
MATKL
Material Group
|
MATKL | T023 |
CHAR
|
9 | 0 | |||||||||||||||||||||||||||
|
DDEHN
Indicator: flexible duration
|
DAUDEHN |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ANZZL
Number of capacities required
|
ANZKAP |
INT1
|
3 | 0 | ||||||||||||||||||||||||||||
|
PRZNT
Work percentage
|
APROZENT |
INT1
|
3 | 0 | ||||||||||||||||||||||||||||
|
MLSTN
Usage
|
MILESTONE | T433 |
CHAR
|
5 | 0 | |||||||||||||||||||||||||||
|
PPRIO
Priority
|
PRIORITAET |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
ANFKO
Requesting cost center
|
ANFKO | CSKS |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
ANFKOKRS
Controlling area of the requesting cost center
|
ANFKOKRS | TKA01 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
INDET
Key for calculation
|
INDET |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
LARNT
Activity Type
|
LSTAR | CSLA |
CHAR
|
6 | 0 | |||||||||||||||||||||||||||
|
PRKST
Costs in the activity
|
PRKST |
CURR
|
11 | 2 | ||||||||||||||||||||||||||||
|
APLFL
Sequence
|
PLNFOLGE |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||
|
RUECK
Completion confirmation number for the operation
|
CO_RUECK |
NUMC
|
10 | 0 | ||||||||||||||||||||||||||||
|
RMZHL
Confirmation counter
|
CO_RMZHL |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
PROJN
Work breakdown structure element (WBS element)
|
PS_PSP_ELE | PRPS |
NUMC
|
8 | 0 | |||||||||||||||||||||||||||
|
OBJNR
Object number
|
J_OBJNR | ONR00 |
CHAR
|
22 | 0 | |||||||||||||||||||||||||||
|
SPANZ
Actual number of splits
|
SPLITTERM |
DEC
|
3 | 0 | ||||||||||||||||||||||||||||
|
BEDID
ID of the capacity requirements record
|
BEDID |
NUMC
|
12 | 0 | ||||||||||||||||||||||||||||
|
BEDZL
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
BANFN
Purchase requisition number
|
CO_BANFN |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
BNFPO
Item number of the purchase requisition in the order
|
CO_BNFPO | EBAN |
NUMC
|
5 | 0 | |||||||||||||||||||||||||||
|
LEK01
Indicator: No remaining activity expected
|
CO_LEIKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
LEK02
Indicator: No remaining activity expected
|
CO_LEIKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
LEK03
Indicator: No remaining activity expected
|
CO_LEIKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
LEK04
Indicator: No remaining activity expected
|
CO_LEIKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
LEK05
Indicator: No remaining activity expected
|
CO_LEIKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
LEK06
Indicator: No remaining activity expected
|
CO_LEIKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
SELKZ
Selection indicator for costing line items
|
CO_SELKZ | TCK08 |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||
|
KALID
Factory Calendar
|
WFCID | TFACD |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
FRSP
Earliest possible activity / Latest possible activity
|
FRSP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
STDKN
Node of operation within reference operation set
|
STDKN |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
ANLZU
Syst.Condition
|
ANLZU | T357M |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||
|
ISTRU
Assembly
|
ISTRU | MARA |
CHAR
|
18 | 0 | |||||||||||||||||||||||||||
|
ISTTY
BOM category
|
STLTY |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ISTNR
Bill of material
|
STNUM |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||||
|
ISTKN
BOM item node number
|
STLKN |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
ISTPO
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
IUPOZ
Subitem Number
|
UPOSZ |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
EBORT
Installation Point for Subitem
|
EBORT |
CHAR
|
20 | 0 | ||||||||||||||||||||||||||||
|
VERTL
Distr.cap.reqmts (plant maint.,process order, network)
|
CR_VERTN | TC29 |
CHAR
|
8 | 0 | |||||||||||||||||||||||||||
|
LEKNW
Indicator: No Remaining Work Expected
|
LEKNW |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
NPRIO
Priority
|
NW_PRIO | TCN07 |
CHAR
|
1 | 0 | |||||||||||||||||||||||||||
|
PVZKN
General counter for order
|
CO_APLZL |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
PHFLG
Indicator: Phase
|
PHFLG |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
PHSEQ
Control Recipe Destination
|
PHSEQ | TC52 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
KNOBJ
Number of Object with Assigned Dependencies
|
KNOBJ |
NUMC
|
18 | 0 | ||||||||||||||||||||||||||||
|
ERFSICHT
Recording View
|
QERFSICHT |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
QPPKTABS
Flow Variants for Inspection Point Completion
|
QPPKTABS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
OTYPE
Object Type
|
OTYPE | T778O |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
OBJEKTID
Object ID
|
OBJEKTID |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
QLKAPAR
Capacity category
|
QL_KAPART | TC26 |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
RSTUF
Reduction level which reduces operation lead time
|
RSTUF |
NUMC
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
NPTXTKY
Internal text number (12-character)
|
TXTKY |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||
|
SUBSYS
Subsystem Identifier for QM Subsystem Interface
|
QEIFSUBSYS |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||
|
PSPNR
Standard WBS element
|
PS_SPS_ELE |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
PACKNO
Package number
|
PACKNO |
NUMC
|
10 | 0 | ||||||||||||||||||||||||||||
|
TXJCD
Tax Jurisdiction
|
TXJCD | TTXJ |
CHAR
|
15 | 0 | |||||||||||||||||||||||||||
|
SCOPE
Object Class
|
SCOPE_CV |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
PRCTR
Profit Center
|
PRCTR | CEPC |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
NO_DISP
Effective for Materials Planning
|
NO_DISP_PLUS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
QKZPRZEIT
Interval = Time (Time-Related)
|
QKZPRZEIT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
QKZZTMG1
Quantity Confirmation for Each Partial Lot
|
QKZZTMG1 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
QKZPRMENG
Creation Cycle = Quantity (Quantity-Reference)
|
QKZPRMENG |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
QKZPRFREI
Interval Without Reference to Time or Quantity
|
QKZPRFREI |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
KZFEAT
Indicator Is Not Used Currently
|
QKZFEAT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
QKZTLSBEST
Operation with Stock-Related Partial Lot Assignment
|
QKZTLSBEST |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
AENNR
Change Number
|
AENNR | AENR |
CHAR
|
12 | 0 | |||||||||||||||||||||||||||
|
CUOBJ_ARB
Configuration (internal object number)
|
CUOBJ |
NUMC
|
18 | 0 | ||||||||||||||||||||||||||||
|
EVGEW
Aggregation weight for POC (PS progress)
|
EV_WEIGHTD |
DEC
|
8 | 0 | ||||||||||||||||||||||||||||
|
ARBII
Actual operating resources object identification
|
CR_OBJID_I | CRID |
NUMC
|
8 | 0 | |||||||||||||||||||||||||||
|
WERKI
Actual plant
|
WERKS_I | T001W |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
CY_SEQNRV
Sequence number operation
|
CY_SEQNRV |
NUMC
|
14 | 0 | ||||||||||||||||||||||||||||
|
KAPT_PUFFR
Operation floats after finite scheduling (in seconds)
|
KAPT_PUFFR |
INT4
|
10 | 0 | ||||||||||||||||||||||||||||
|
EBELN
Purchasing Document Number
|
EBELN | EKKO |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
EBELP
Item Number of Purchasing Document
|
EBELP | EKPO |
NUMC
|
5 | 0 | |||||||||||||||||||||||||||
|
WEMPF
Goods Recipient/Ship-To Party
|
WEMPF |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||
|
ABLAD
Unloading Point
|
ABLAD |
CHAR
|
25 | 0 | ||||||||||||||||||||||||||||
|
CLASF
Ind.: Take Activity Into Account for Project Summarization
|
CLASF |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
FRUNV
Indicator: External procurement data incomplete
|
FRUNV |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ZSCHL
Overhead key
|
AUFZSCHL |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||
|
KALSM
Costing Sheet
|
AUFKALSM |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||
|
SCHED_END
Ind.: Purchase requisition at activity finish date
|
SCEND_ACT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
NETZKONT
Indicator for the account assignment of a network(hdr/act.)
|
NETZKONT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
OWAER
Object currency for network activity
|
OWAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||||||||||||||||
|
AFNAM
Name of Requisitioner/Requester
|
AFNAM |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||
|
BEDNR
Requirement Tracking Number
|
BEDNR |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
KZFIX
Indicator: Purchasing info record data are fixed
|
CN_KZFIX |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
PERNR
Personnel number
|
CO_PERNR |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||
|
FRDLB
Indicator: Externally processed op. with subcontracting
|
CO_FRDLB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
QPART
Inspection Type
|
QPART | TQ30 |
CHAR
|
8 | 0 | |||||||||||||||||||||||||||
|
LOEKZ
Deletion flag
|
AUFLOEKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
WKURS
Exchange Rate
|
WKURS |
DEC
|
9 | 5 | ||||||||||||||||||||||||||||
|
PROD_ACT
Indicator: Activity is a production activity
|
PROD_ACT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
FPLNR
Billing plan number / invoicing plan number
|
FPLNR |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
OBJTYPE
Change indicator
|
OCM_OBJ_TYPE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
CH_PROC
Process that has lead to the change of an object
|
OCM_CH_PROC |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
KLVAR
Costing Variant
|
CK_KLVAR |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
KALNR
Cost Estimate Number for Cost Est. w/o Qty Structure
|
CK_KALNR |
NUMC
|
12 | 0 | ||||||||||||||||||||||||||||
|
FORDN
Framework Order
|
SFORDN |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
FORDP
Item of framework order
|
FORDP |
NUMC
|
5 | 0 | ||||||||||||||||||||||||||||
|
MAT_PRKST
Material planning in networks: primary costs
|
MAT_PRKST |
CURR
|
11 | 2 | ||||||||||||||||||||||||||||
|
PRZ01
Business Process
|
CO_PRZNR |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||
|
RFPNT
Reference point for BOM transfer
|
CN_RFPNT | TCNRFP |
CHAR
|
20 | 0 | |||||||||||||||||||||||||||
|
FUNC_AREA
Functional Area
|
FKBER | TFKB |
CHAR
|
16 | 0 | |||||||||||||||||||||||||||
|
TECHS
Parameter Variant/Standard Variant
|
TECHS |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||
|
ADPSP
Reference Element PM/PS
|
ADDCOMPARE_CORE |
CHAR
|
40 | 0 | ||||||||||||||||||||||||||||
|
RFIPPNT
Reference Point for Relationship Between iPPE and PS
|
CN_RPIP | TCNRPIP |
CHAR
|
20 | 0 | |||||||||||||||||||||||||||
|
MES_OPERID
Key of an Operation from an ME System
|
CO_MES_INT_OPERID |
CHAR
|
48 | 0 | ||||||||||||||||||||||||||||
|
MES_STEPID
Key of a Step in a Routing (SAP ME)
|
CO_MES_INT_STEPID |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||
|
/CUM/CUGUID
UUID in X form (binary)
|
SYSUUID_X | /CUM/AFCU |
RAW
|
16 | 0 | |||||||||||||||||||||||||||
|
/ISDFPS/OBJNR
Object number
|
J_OBJNR |
CHAR
|
22 | 0 | ||||||||||||||||||||||||||||
|
AFVC_STATUS
Status Combination
|
ACTCMB_DELE | ACTCMB_TAB |
INT1
|
3 | 0 | |||||||||||||||||||||||||||
|
MILL_OC_AUFNR_MO
Number of Combined Order
|
MILL_OC_AUFNR_MO |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||
|
OIO_HOLD
Indicator: Hold Delivery Onshore
|
OIO_HOLD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
WTY_IND
Warranty indicator
|
WTYSC_WTY_INDICATOR |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
TPLNR
Functional Location
|
TPLNR |
CHAR
|
30 | 0 | ||||||||||||||||||||||||||||
|
EQUNR
Equipment Number
|
EQUNR |
CHAR
|
18 | 0 | ||||||||||||||||||||||||||||
|
CPD_UPDAT
Time Stamp
|
/CPD/PFP_TSTMP |
DEC
|
15 | 0 | ||||||||||||||||||||||||||||
AFVC foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| AFVC | /CUM/CUGUID | SYST | MANDT |
/CUM/AFCU
CU: CU Instances
|
MANDT |
| AFVC | /CUM/CUGUID | AFVC | /CUM/CUGUID |
/CUM/AFCU
CU: CU Instances
|
CUGUID |
| AFVC | AENNR | AFVKI | MANDT |
AENR
Change Master
|
MANDT |
| AFVC | AENNR | AFVC | AENNR |
AENR
Change Master
|
AENNR |
| AFVC | AFVC_STATUS | SYST | MANDT |
ACTCMB_TAB
table for status combination
|
MANDT |
| AFVC | AFVC_STATUS | AFVC | AFVC_STATUS |
ACTCMB_TAB
table for status combination
|
ACTCMB |
| AFVC | ANFKO | CSKS | DATBI |
CSKS
Cost Center Master Data
|
DATBI |
| AFVC | ANFKO | AFVKI | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| AFVC | ANFKO | AFVC | ANFKOKRS |
CSKS
Cost Center Master Data
|
KOKRS |
| AFVC | ANFKO | AFVC | ANFKO |
CSKS
Cost Center Master Data
|
KOSTL |
| AFVC | ANFKOKRS | AFVKI | MANDT |
TKA01
Controlling Areas
|
MANDT |
| AFVC | ANFKOKRS | AFVC | ANFKOKRS |
TKA01
Controlling Areas
|
KOKRS |
| AFVC | ANLZU | CAUFVD | MANDT |
T357M
Machine operating condition
|
MANDT |
| AFVC | ANLZU | AFVC | ANLZU |
T357M
Machine operating condition
|
ANLZU |
| AFVC | ARBID | CRID | OBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| AFVC | ARBID | AFVC | ARBID |
CRID
CIM Resource - Entities
|
OBJID |
| AFVC | ARBID | AFVKI | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| AFVC | ARBII | AFVKI | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| AFVC | ARBII | CRID | OBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| AFVC | ARBII | AFVC | ARBII |
CRID
CIM Resource - Entities
|
OBJID |
| AFVC | BNFPO | AFVKI | MANDT |
EBAN
Purchase Requisition
|
MANDT |
| AFVC | BNFPO | AFVC | BANFN |
EBAN
Purchase Requisition
|
BANFN |
| AFVC | BNFPO | AFVC | BNFPO |
EBAN
Purchase Requisition
|
BNFPO |
| AFVC | BUKRS | AFVKI | MANDT |
T001
Company Codes
|
MANDT |
| AFVC | BUKRS | AFVC | BUKRS |
T001
Company Codes
|
BUKRS |
| AFVC | EBELN | AFVGD | MANDT |
EKKO
Purchasing Document Header
|
MANDT |
| AFVC | EBELN | AFVC | EBELN |
EKKO
Purchasing Document Header
|
EBELN |
| AFVC | EBELP | AFVC | EBELN |
EKPO
Purchasing Document Item
|
EBELN |
| AFVC | EBELP | AFVC | EBELP |
EKPO
Purchasing Document Item
|
EBELP |
| AFVC | EBELP | AFVGD | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| AFVC | EKGRP | AFVC | EKGRP |
T024
Purchasing Groups
|
EKGRP |
| AFVC | EKGRP | AFVKI | MANDT |
T024
Purchasing Groups
|
MANDT |
| AFVC | EKORG | AFVKI | MANDT |
T024E
Purchasing Organizations
|
MANDT |
| AFVC | EKORG | AFVC | EKORG |
T024E
Purchasing Organizations
|
EKORG |
| AFVC | FUNC_AREA | SYST | MANDT |
TFKB
Functional areas
|
MANDT |
| AFVC | FUNC_AREA | AFVC | FUNC_AREA |
TFKB
Functional areas
|
FKBER |
| AFVC | GSBER | AFVKI | MANDT |
TGSB
Business Areas
|
MANDT |
| AFVC | GSBER | AFVC | GSBER |
TGSB
Business Areas
|
GSBER |
| AFVC | INFNR | AFVKI | MANDT |
EINA
Purchasing Info Record: General Data
|
MANDT |
| AFVC | INFNR | AFVC | INFNR |
EINA
Purchasing Info Record: General Data
|
INFNR |
| AFVC | ISTRU | AFVC | ISTRU |
MARA
General Material Data
|
MATNR |
| AFVC | ISTRU | AFVGK | MANDT |
MARA
General Material Data
|
MANDT |
| AFVC | KALID | AFVC | KALID |
TFACD
Factory calendar definition
|
IDENT |
| AFVC | KTSCH | AFVKI | MANDT |
T435
Standard texts for routing/ref. op set items
|
MANDT |
| AFVC | KTSCH | AFVC | KTSCH |
T435
Standard texts for routing/ref. op set items
|
VLSCH |
| AFVC | LAR01 | AFVKI | MANDT |
CSLA
Activity master
|
MANDT |
| AFVC | LAR01 | AFVC | ANFKOKRS |
CSLA
Activity master
|
KOKRS |
| AFVC | LAR01 | AFVC | LAR01 |
CSLA
Activity master
|
LSTAR |
| AFVC | LAR01 | CSLA | DATBI |
CSLA
Activity master
|
DATBI |
| AFVC | LAR02 | AFVKI | MANDT |
CSLA
Activity master
|
MANDT |
| AFVC | LAR02 | AFVC | ANFKOKRS |
CSLA
Activity master
|
KOKRS |
| AFVC | LAR02 | AFVC | LAR02 |
CSLA
Activity master
|
LSTAR |
| AFVC | LAR02 | CSLA | DATBI |
CSLA
Activity master
|
DATBI |
| AFVC | LAR03 | AFVC | ANFKOKRS |
CSLA
Activity master
|
KOKRS |
| AFVC | LAR03 | AFVC | LAR03 |
CSLA
Activity master
|
LSTAR |
| AFVC | LAR03 | CSLA | DATBI |
CSLA
Activity master
|
DATBI |
| AFVC | LAR03 | AFVKI | MANDT |
CSLA
Activity master
|
MANDT |
| AFVC | LAR04 | CSLA | DATBI |
CSLA
Activity master
|
DATBI |
| AFVC | LAR04 | AFVKI | MANDT |
CSLA
Activity master
|
MANDT |
| AFVC | LAR04 | AFVC | ANFKOKRS |
CSLA
Activity master
|
KOKRS |
| AFVC | LAR04 | AFVC | LAR04 |
CSLA
Activity master
|
LSTAR |
| AFVC | LAR05 | AFVKI | MANDT |
CSLA
Activity master
|
MANDT |
| AFVC | LAR05 | AFVC | ANFKOKRS |
CSLA
Activity master
|
KOKRS |
| AFVC | LAR05 | AFVC | LAR05 |
CSLA
Activity master
|
LSTAR |
| AFVC | LAR05 | CSLA | DATBI |
CSLA
Activity master
|
DATBI |
| AFVC | LAR06 | AFVKI | MANDT |
CSLA
Activity master
|
MANDT |
| AFVC | LAR06 | AFVC | ANFKOKRS |
CSLA
Activity master
|
KOKRS |
| AFVC | LAR06 | AFVC | LAR06 |
CSLA
Activity master
|
LSTAR |
| AFVC | LAR06 | CSLA | DATBI |
CSLA
Activity master
|
DATBI |
| AFVC | LARNT | AFVC | ANFKOKRS |
CSLA
Activity master
|
KOKRS |
| AFVC | LARNT | AFVC | LARNT |
CSLA
Activity master
|
LSTAR |
| AFVC | LARNT | CSLA | DATBI |
CSLA
Activity master
|
DATBI |
| AFVC | LARNT | AFVGK | MANDT |
CSLA
Activity master
|
MANDT |
| AFVC | LIFNR | AFVKI | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| AFVC | LIFNR | AFVC | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| AFVC | LOGRP | AFVC | WERKS |
T421
Wage groups
|
WERKS |
| AFVC | LOGRP | AFVC | LOGRP |
T421
Wage groups
|
LOGRP |
| AFVC | LOGRP | AFVKI | MANDT |
T421
Wage groups
|
MANDT |
| AFVC | MANDT | AFVC | MANDT |
T000
Clients
|
MANDT |
| AFVC | MATKL | AFVKI | MANDT |
T023
Material Groups
|
MANDT |
| AFVC | MATKL | AFVC | MATKL |
T023
Material Groups
|
MATKL |
| AFVC | MLSTN | AFVKI | MANDT |
T433
Milestone Indicator
|
MANDT |
| AFVC | MLSTN | AFVC | MLSTN |
T433
Milestone Indicator
|
MLSTN |
| AFVC | NPRIO | SYST | MANDT |
TCN07
Priority
|
MANDT |
| AFVC | NPRIO | AFVC | NPRIO |
TCN07
Priority
|
NPRIO |
| AFVC | OBJNR | AFVKI | MANDT |
ONR00
General Object Number
|
MANDT |
| AFVC | OBJNR | AFVC | OBJNR |
ONR00
General Object Number
|
OBJNR |
| AFVC | OTYPE | AFVKI | MANDT |
T778O
Object Types
|
MANDT |
| AFVC | OTYPE | AFVC | OTYPE |
T778O
Object Types
|
OTYPE |
| AFVC | OWAER | SYST | MANDT |
TCURC
Currency Codes
|
MANDT |
| AFVC | OWAER | AFVC | OWAER |
TCURC
Currency Codes
|
WAERS |
| AFVC | PDEST | AFVC | PDEST |
TSP03
Spool: Printer declaration
|
PADEST |
| AFVC | PHSEQ | AFVC | WERKS |
TC52
Control Recipe Destinations
|
WERKS |
| AFVC | PHSEQ | AFVC | PHSEQ |
TC52
Control Recipe Destinations
|
PHSEQ |
| AFVC | PHSEQ | MANDT | AFVC |
TC52
Control Recipe Destinations
|
MANDT |
| AFVC | PLNTY | AFVKI | MANDT |
TCA01
Task list types
|
MANDT |
| AFVC | PLNTY | AFVC | PLNTY |
TCA01
Task list types
|
PLNTY |
| AFVC | PRCTR | AFVKI | MANDT |
CEPC
Profit Center Master Data Table
|
MANDT |
| AFVC | PRCTR | AFVC | PRCTR |
CEPC
Profit Center Master Data Table
|
PRCTR |
| AFVC | PRCTR | * |
CEPC
Profit Center Master Data Table
|
DATBI | |
| AFVC | PRCTR | * |
CEPC
Profit Center Master Data Table
|
KOKRS | |
| AFVC | PROJN | AFVKI | MANDT |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
MANDT |
| AFVC | PROJN | AFVC | PROJN |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
PSPNR |
| AFVC | QLKAPAR | AFVKI | MANDT |
TC26
Capacity category
|
MANDT |
| AFVC | QLKAPAR | AFVC | QLKAPAR |
TC26
Capacity category
|
KAPAR |
| AFVC | QPART | AFVC | MANDT |
TQ30
Inspection types
|
MANDT |
| AFVC | QPART | AFVC | QPART |
TQ30
Inspection types
|
ART |
| AFVC | QUALF | AFVKI | MANDT |
T423
Wage group qualification
|
MANDT |
| AFVC | QUALF | AFVC | WERKS |
T423
Wage group qualification
|
WERKS |
| AFVC | QUALF | AFVC | QUALF |
T423
Wage group qualification
|
QUALF |
| AFVC | RASCH | AFVKI | MANDT |
T428
Setup Type Key
|
MANDT |
| AFVC | RASCH | AFVC | WERKS |
T428
Setup Type Key
|
WERKS |
| AFVC | RASCH | AFVC | RASCH |
T428
Setup Type Key
|
RASCH |
| AFVC | RFGRP | AFVC | WERKS |
T426
Setup group categories
|
WERKS |
| AFVC | RFGRP | AFVC | RFGRP |
T426
Setup group categories
|
RFGRP |
| AFVC | RFGRP | AFVKI | MANDT |
T426
Setup group categories
|
MANDT |
| AFVC | RFIPPNT | SYST | MANDT |
TCNRPIP
Reference point for relationship between IPPE & PS.
|
MANDT |
| AFVC | RFIPPNT | AFVC | RFIPPNT |
TCNRPIP
Reference point for relationship between IPPE & PS.
|
RFPNT |
| AFVC | RFPNT | AFVC | RFPNT |
TCNRFP
Reference Point for BOM transfer
|
RFPNT |
| AFVC | RFPNT | AFVC | MANDT |
TCNRFP
Reference Point for BOM transfer
|
MANDT |
| AFVC | RFSCH | AFVKI | MANDT |
T425
Setup group keys
|
MANDT |
| AFVC | RFSCH | AFVC | WERKS |
T425
Setup group keys
|
WERKS |
| AFVC | RFSCH | AFVC | RFGRP |
T425
Setup group keys
|
RFGRP |
| AFVC | RFSCH | AFVC | RFSCH |
T425
Setup group keys
|
RFSCH |
| AFVC | RSTRA | AFVC | WERKS |
T499Q
Reduction strategies
|
WERKS |
| AFVC | RSTRA | AFVC | RSTRA |
T499Q
Reduction strategies
|
RSTRA |
| AFVC | RSTRA | AFVKI | MANDT |
T499Q
Reduction strategies
|
MANDT |
| AFVC | SAKTO | AFVKI | MANDT |
CSKA
Cost Elements (Data Dependent on Chart of Accounts)
|
MANDT |
| AFVC | SAKTO | CSKA | KTOPL |
CSKA
Cost Elements (Data Dependent on Chart of Accounts)
|
KTOPL |
| AFVC | SAKTO | AFVC | SAKTO |
CSKA
Cost Elements (Data Dependent on Chart of Accounts)
|
KSTAR |
| AFVC | SELKZ | AFVKI | MANDT |
TCK08
Indicator for Relevancy to Costing
|
MANDT |
| AFVC | SELKZ | AFVC | SELKZ |
TCK08
Indicator for Relevancy to Costing
|
SELKZ |
| AFVC | STEUS | AFVKI | MANDT |
T430
Operation/Activity control key
|
MANDT |
| AFVC | STEUS | CAUFVD | PLNAW |
T430
Operation/Activity control key
|
PLNAW |
| AFVC | STEUS | AFVC | STEUS |
T430
Operation/Activity control key
|
STEUS |
| AFVC | TXJCD | AFVKI | MANDT |
TTXJ
Check Table for Tax Jurisdiction
|
MANDT |
| AFVC | TXJCD | CAUFVD | KALSM |
TTXJ
Check Table for Tax Jurisdiction
|
KALSM |
| AFVC | TXJCD | AFVC | TXJCD |
TTXJ
Check Table for Tax Jurisdiction
|
TXJCD |
| AFVC | TXTSP | AFVC | TXTSP |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| AFVC | VERTL | AFVGK | MANDT |
TC29
Distribution key for capacity load
|
MANDT |
| AFVC | VERTL | AFVC | VERTL |
TC29
Distribution key for capacity load
|
VERTL |
| AFVC | VGWTS | AFVKI | MANDT |
TC21
Standard value key
|
MANDT |
| AFVC | VGWTS | AFVC | VGWTS |
TC21
Standard value key
|
VGWTS |
| AFVC | VPLTY | AFVC | VPLTY |
TCA01
Task list types
|
PLNTY |
| AFVC | VPLTY | AFVKI | MANDT |
TCA01
Task list types
|
MANDT |
| AFVC | WAERS | AFVKI | MANDT |
TCURC
Currency Codes
|
MANDT |
| AFVC | WAERS | AFVC | WAERS |
TCURC
Currency Codes
|
WAERS |
| AFVC | WERKI | AFVKI | MANDT |
T001W
Plants/Branches
|
MANDT |
| AFVC | WERKI | AFVC | WERKI |
T001W
Plants/Branches
|
WERKS |
| AFVC | WERKS | AFVC | WERKS |
T001W
Plants/Branches
|
WERKS |
| AFVC | WERKS | AFVKI | MANDT |
T001W
Plants/Branches
|
MANDT |
| AFVC | ZERMA | AFVC | WERKS |
T429
Standard Times Calculation Type
|
WERKS |
| AFVC | ZERMA | AFVC | ZERMA |
T429
Standard Times Calculation Type
|
ZERMA |
| AFVC | ZERMA | AFVKI | MANDT |
T429
Standard Times Calculation Type
|
MANDT |